No announcements
Found 3867429 threads
-
0 VotesAzyre SQL Data Sync between Row-stored table and Column-stored table?
Can the SQL Data Sync synchronize the data between Row-stored table and Column-stored ...Answered | 4 Replies | 665 Views | Created by Yoshihiro Kawabata - Friday, February 1, 2019 11:31 AM | Last reply by Yoshihiro Kawabata - Saturday, February 2, 2019 1:59 AM
-
0 Votes
how to share table between stored procedure?
more data. the problem is that between the calls the data on the temp table doesn't save. my question is how can i share a temp table ...Answered | 1 Replies | 17 Views | Created by Anonymous - Saturday, July 14, 2012 12:51 PM | Last reply by Anonymous - Saturday, July 14, 2012 2:16 PM -
0 Votes
Stored procedure and table
find stored procedure 'dbo.aspnet_CheckSchemaVersion' and could you please tell me the use of that SP.and clearly explain the aspnet_Users table. ...Answered | 5 Replies | 22 Views | Created by Anonymous - Friday, December 28, 2007 4:36 AM | Last reply by Anonymous - Tuesday, January 1, 2008 10:31 PM -
0 Votes
refresh stored data into table
User-2104093092 posted hi all, i have create a form in asp.net & C# using SQL server.. after i click save button data ...Answered | 2 Replies | 5 Views | Created by Anonymous - Monday, October 4, 2010 2:02 AM | Last reply by Anonymous - Monday, October 4, 2010 2:40 AM -
3 Votes
how to share table between stored procedure?
hi, i have a stored procedure which creates a table and fills it up, this stored procedure call it self again and continue fill it up ...Answered | 3 Replies | 7177 Views | Created by moshik.salem - Saturday, July 14, 2012 4:49 PM | Last reply by Ahsan Kabir - Saturday, July 14, 2012 8:46 PM -
0 Votes
Stored procedure that return row wise data from a table.
can you return from a stored procedure row by row data from a table. I replied that in my previous post, in such case you can ...Answered | 6 Replies | 25 Views | Created by Anonymous - Friday, February 18, 2011 10:59 PM | Last reply by Anonymous - Wednesday, February 23, 2011 8:20 AM -
0 Votes
SQL Server peer-to-peer synchronize between table and data stored in XML
without much tranforming of the data when doing the Sync. If you want to sync between a XML store (even it may be stored in a ...Answered | 6 Replies | 7278 Views | Created by Glenn2654 - Monday, June 7, 2010 3:30 PM | Last reply by jigu2014 - Tuesday, June 8, 2010 5:24 PM -
0 Votes
Differences between SQL Stored Procedures and table-valued functions
The context wherein table-valued functions and stored procedures come into picture is when data needs to be shared between stored procedures.Answered | 3 Replies | 23005 Views | Created by Robert Barnes - Wednesday, September 6, 2006 5:26 AM | Last reply by Sirisha Kommushetty-MS - Wednesday, September 6, 2006 6:23 AM -
0 Votes
Stored proc and temp table
Hello Sarah, Yes, that's possible to insert the result set of a stored procedure into a (temporary) table by usingAnswered | 2 Replies | 9771 Views | Created by Sarah2005 - Monday, November 28, 2011 6:23 PM | Last reply by Sarah2005 - Wednesday, December 14, 2011 2:59 AM -
0 Votes
Stored Procedure for Sort the table and then update the column of Table in SQl Table
;row (ID='1' ) of column Name as G How will we do this using Stored proc not with simple table order by and update ...Answered | 8 Replies | 581 Views | Created by VeeraGangala - Thursday, April 21, 2016 6:25 AM | Last reply by TiborK - Thursday, April 21, 2016 11:01 AM -
0 Votes
Data not stored in table
stored in the database table. It was perfectly doing until I deleted some columns of the database table and added one column. I use profile ...Answered | 5 Replies | 60 Views | Created by Anonymous - Friday, September 2, 2016 9:57 PM | Last reply by Anonymous - Sunday, September 4, 2016 12:11 PM -
0 Votes
Table and Column usage in Stored Procedures
Hi there, Could any one suggest a query which yields the list of tables and columns used in a stored procedures. I know sp_depends has similar functionality, but ...Answered | 1 Replies | 5609 Views | Created by MadhuBabu - Thursday, November 22, 2007 1:34 AM | Last reply by Madhu K Nair - Thursday, November 22, 2007 2:03 AM -
0 Votes
Stored procedure column data
those same properties. Basically exactly like Linq to Sql does. However, I can't find where that information is held in my sql database. Is there a system ...Answered | 3 Replies | 14 Views | Created by Anonymous - Monday, November 3, 2008 9:17 AM | Last reply by Anonymous - Monday, November 3, 2008 4:29 PM -
0 Votes
TABLE DATA FROM STORED PROCEDURE?
as begin set nocount on if @Table_Name is NULL begin raiserror('You ...Answered | 3 Replies | 3298 Views | Created by cmk1 - Thursday, May 6, 2010 11:43 PM | Last reply by K H Tan - Friday, May 7, 2010 1:06 AM -
0 Votes
Table Variable in stored procedure
and staging data is inserted into that table I am going to use the table variable in stored procedure which will be ...Answered | 1 Replies | 1577 Views | Created by S Prashant - Wednesday, March 6, 2013 9:06 AM | Last reply by Nitesh Rai - Wednesday, March 6, 2013 9:13 AM -
1 Votes
what is difference between views and table and stored procedure
Hello, Tables contains data, views are defined queries basing on the tables and/or other views. Stored procedures can contain various ...Answered | 3 Replies | 6853 Views | Created by pnreddy - Wednesday, February 1, 2012 6:10 PM | Last reply by Kalman Toth - Saturday, February 4, 2012 11:17 AM -
0 Votes
MDS stored in table
You can use the OPENQUERY and pass the query from table as string.. Using EXECUTE SQL task you can get the query from the table and ...Answered | 4 Replies | 3780 Views | Created by SSAS_5000 - Friday, August 12, 2011 9:53 PM | Last reply by Thomas Ivarsson - Saturday, August 13, 2011 4:55 PM -
0 Votes
Temp table in sql stored orcedure
. in two codition 1.in case of multisession 2. if transaction drop in between even i drop Table in ...Answered | 1 Replies | 7 Views | Created by Anonymous - Tuesday, June 15, 2010 7:22 AM | Last reply by Anonymous - Tuesday, June 15, 2010 8:26 AM -
1 Votes
Stored Procedures and table references
You can get list of Views, SP, functions which use your table by executing below SQL: EXEC sp_depends @objname = N'dbo.MyTable' ; To get the ...Answered | 4 Replies | 688 Views | Created by warnerrj79 - Monday, July 28, 2014 11:36 AM | Last reply by Kalman Toth - Monday, July 28, 2014 5:55 PM -
0 Votes
XML data inserted into SQL table via stored proc
proc that will query this column and insert the data into a table IF the CompanyID matches any in another table in a different DB. The stored ...Answered | 2 Replies | 1459 Views | Created by TBAN65 - Tuesday, February 5, 2013 10:38 PM | Last reply by TBAN - Friday, February 8, 2013 2:54 PM - Items 1 to 20 of 3867429 Next ›
No announcements
