Store Procedure Output in a Table
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,488 reads
This script show a demonstration of how to interst tore Procedure Output in a Table.
2010-01-08 (first published: 2009-12-18)
2,488 reads
2009-02-16 (first published: 2009-02-03)
2,627 reads
This Store procedure is used to add primary key to all tables in a database, if table does not contain it.
2008-11-04
980 reads
2008-11-04
1,954 reads
2008-03-14 (first published: 2008-01-29)
1,274 reads
This procedure is used to shrink the databases. Many times we use shrink option to shrink the databases for backup. and we do it N number of times, when we take the back of databses or make free space of drive.instructions:- Follwo the step.1. run script.2. And execute the statement, exec shrink_databasesI m new, if […]
2007-06-27
795 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers