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,505 reads
Vinay Kumar
- Interests: Hi, I worked with different technologies like C#, ASP.NET, Web services and sql server. But i was fall in love with sql server and became a DBA. I always try to learn something new or recall old stuff. Frankly speaking, i don't think that i am a DBA. Still learning. I like to spend my spare time with my family and friends. Recently, i have stared blogging and improving my writing way. :-). that's all about me. Keep Learning - Keep Growing !!! Thanks Vinay Kumar
2009-02-16 (first published: 2009-02-03)
2,659 reads
Add Primary key
This Store procedure is used to add primary key to all tables in a database, if table does not contain it.
2008-11-04
999 reads
2008-11-04
1,972 reads
2008-03-14 (first published: 2008-01-29)
1,292 reads
Shrink databases
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
810 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Metro Pasar Baru Telp:0821°8200°203
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
Alamat BCA KCP Kyai Caringin Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Balikpapan No.21 A-B, RT.9/RW.6, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Tanah Abang Blok A Telp:0821°7555°651
Telp/Wa 628217555651 Pasar Regional Tanah Abang, Kios No.F-081 Blk A Basement I/G-063, F-080, Kp....
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers