No announcements
Found 1689458 threads
-
1 VotesStored Procedures and table references
SELECT DISTINCT O.name as SP_Name , OO.name as Table_Name ,o.xtype FROM sys.sysdepends D INNER JOIN sys.sysobjects O ...Answered | 4 Replies | 883 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
Find Tables refered by stored procedures
Hi All I need a script that returns list of tables being refrenced by stored procedure in sql server 2005 including cross ...Answered | 4 Replies | 1513 Views | Created by Trehan11 - Thursday, May 15, 2014 10:47 AM | Last reply by Olaf Helper - Friday, May 16, 2014 7:21 AM -
0 Votes
Tables and stored procedures that refer these tables in comma seperated
Both have the problem that typically they fail to record dependencies for queries that include temp tables.Answered | 2 Replies | 1458 Views | Created by Chaithanya Reddy - Thursday, October 25, 2012 7:23 AM | Last reply by Erland Sommarskog - Thursday, October 25, 2012 7:52 AM -
0 Votes
Scripting Stored Procedures to Table
In SSMS, open the file of stored procedures you saved above, and run it.Answered | 4 Replies | 4520 Views | Created by Trancedified - Wednesday, June 22, 2011 12:13 AM | Last reply by Trancedified - Thursday, June 23, 2011 4:07 PM -
0 Votes
Reference a Stored Procedure from another Stored Procedure.
The procedure can then use object_name(@@procid) to get the name of the procedure.Answered | 6 Replies | 4506 Views | Created by holt.rh - Monday, January 10, 2011 5:52 PM | Last reply by holt.rh - Tuesday, January 11, 2011 1:08 PM -
0 Votes
PowerPivot tables and stored procedures
I have a stored procedure which I want to mirror it's query result as a Pivot Table in Excel, and have done so by hard coding the execution code and imported it to Excel.Answered | 4 Replies | 850 Views | Created by Onyx101 - Tuesday, July 29, 2014 9:24 AM | Last reply by Onyx101 - Tuesday, July 29, 2014 11:06 AM -
1 Votes
Reference global temp table created in another stored procedure
We resolve the temp table shape in the scope of the code where it is being created, as we do not understand the execution graph at design time, we cannot determine the ...Answered | 4 Replies | 4609 Views | Created by Torsten Tiedt - Thursday, March 29, 2012 2:00 PM | Last reply by Gert Drapers - Tuesday, September 4, 2012 9:44 PM -
0 Votes
Transfer Stored Procedure's result into table
Is it possible to Transfer Stored Procedure's result into table in SQL 2005?Answered | 3 Replies | 5373 Views | Created by sesquipedalian - Wednesday, February 9, 2011 8:47 PM | Last reply by Kalman Toth - Tuesday, February 15, 2011 3:22 PM -
8 Votes
Drop and recreate table in stored procedure
More importantly, a change to the structure of ANY table will require that every usage of and reference to that table be reviewed (and probably corrected).Answered | 13 Replies | 42068 Views | Created by Greenbow1986 - Thursday, March 12, 2015 10:35 AM | Last reply by pituach - Thursday, March 12, 2015 7:55 PM -
0 Votes
Data tables for SQL Stored Procedures
I created a single data table in Azure Mobile Services to handle the stored procedures.Answered | 7 Replies | 1405 Views | Created by Michelle McCabe - Saturday, September 20, 2014 11:20 AM | Last reply by Michelle McCabe - Tuesday, November 11, 2014 11:47 AM -
0 Votes
Table Parameter of Store Procedure Limitation
I am thinking to passing matched records with id issued in application server as table parameter into store procedures.Answered | 2 Replies | 5433 Views | Created by TravelMan - Tuesday, May 31, 2011 2:31 PM | Last reply by TravelMan - Thursday, June 2, 2011 9:58 PM -
0 Votes
converting table scripts to stored procedure
So the above script creates the tables in the database where the stored procedure is running, not the database that is passed in @dbname.Answered | 3 Replies | 976 Views | Created by mirandaroopa - Wednesday, August 5, 2015 5:56 AM | Last reply by Prakash Machiraju - Thursday, August 6, 2015 5:26 PM -
0 Votes
Help with relational table with Stored Procedure.
Hi Pure Deal, If you want to one-to-many relationship, I would suggest that you could use EntitySet attribute instead of stored procedure. the following article ...Answered | 1 Replies | 776 Views | Created by Pure Deal - Thursday, July 28, 2016 3:51 PM | Last reply by Zhanglong Wu - Friday, July 29, 2016 3:31 AM -
0 Votes
SSRS and Temp tables in stored procedures
If so , which type temp table you choose for the procedure ?Answered | 2 Replies | 3885 Views | Created by bdjb - Monday, September 17, 2018 3:17 PM | Last reply by Mitarai Queen - Tuesday, September 18, 2018 6:26 AM -
6 Votes
stored procedures for updating multiple tables
Especially try to describe how you like to use your stored procedure.Answered | 11 Replies | 8021 Views | Created by fjaconda199 - Tuesday, November 22, 2011 3:49 PM | Last reply by fjaconda199 - Monday, November 28, 2011 10:55 AM -
1 Votes
Debugging stored procedures with temp tables
How to: Debug Stored Procedures How to debug stored procedures in Visual Studio ...Answered | 4 Replies | 2283 Views | Created by JFBconsul - Wednesday, May 21, 2014 11:37 AM | Last reply by Dave Patrick - Thursday, May 22, 2014 1:38 AM -
7 Votes
Correct way to reference system stored procedure sp_executesql
Most of our databases have user Stored procedures/ Views which do refer to CDC functions.Answered | 10 Replies | 21743 Views | Created by noonie - Friday, July 15, 2011 12:11 AM | Last reply by Calico Eric - Wednesday, July 10, 2013 11:53 PM -
0 Votes
detecting table/stored procedure usage?
If you have all logic capsulated in stored procedures instead of querying the data tables directly you could extend your procs doing a extra logging within the ...Answered | 5 Replies | 5309 Views | Created by CraigL77 - Saturday, February 14, 2009 9:07 PM | Last reply by Jens K. Suessmeyer - - Sunday, February 15, 2009 12:05 PM -
0 Votes
Easy Deployment of Stored Procedures and Tables
How can I easily deploy Tables and Stored Procedure in my databases?Answered | 1 Replies | 2329 Views | Created by Ton-Ton Keaton - Wednesday, December 7, 2011 1:40 AM | Last reply by Naomi N - Wednesday, December 7, 2011 2:57 AM -
0 Votes
Using a synonym table within a synonym stored procedure
Is that possible that you are facing a default schema issue as described in this SO thread?Answered | 2 Replies | 1144 Views | Created by JonnyBravoII - Sunday, December 25, 2016 1:05 AM | Last reply by Ekrem Önsoy - Monday, December 26, 2016 7:11 AM - Items 1 to 20 of 1689458 Next ›
No announcements
