2013-12-19 (first published: 2007-08-27)
15,324 reads
Deepthi Viswanathan Nair
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
2010-07-09 (first published: 2009-07-23)
32,651 reads
2008-09-09
1,048 reads
Get list of tables used in a stored procedure
It used to find the table dependencies, helps the developers during an enhancement stage to find the tables are used in a stored procedure.
2007-08-30 (first published: 2007-03-16)
3,112 reads
Generate Stored Procedure/Functions Script with SP
It will help to generate DBscript of Stored Procedure/User defined Functions in SQL server without selecting those thru Enterprise manager.Pass the name of Stored procedures/Functions as parameters to the sp_Generate_Script, it generates the scripts and displayed on screen. Choose text format for result display.
2007-03-23 (first published: 2007-03-14)
2,068 reads
List of stored procedures which refer a DB table
It used to find stored procedures where a DB has been used.
2007-03-22 (first published: 2007-03-16)
448 reads
Blogs
VSCode Tips–Remove the Highlighted Line
By Steve Jones
VSCode was making me crazy as I was writing a script. I like a...
Use T-SQL, not the GUI
By Jen McCown
There’s a very good reason to do most of your DBA work using T-SQL,...
Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".
By Gethyn Ellis
To be honest you probably think that migrating to the cloud sounds great, and...
Forums
SQL Tamagotchi! Mini-Servers as Database Pets
Comments posted to this topic are about the item SQL Tamagotchi! Mini-Servers as Database...
SQL 2014 (or any other versions) Standard - ~Embedded Licensing~
Anyone have any insights on how this licensing works and what the "Use Rights"...
SSIS - Adding Columns to existing table and load data
I am working in SSIS (Sql server version 2012) , I have a requirement...
Ask SSC