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,506 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,661 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
1,000 reads
2008-11-04
1,974 reads
2008-03-14 (first published: 2008-01-29)
1,293 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
811 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Telp BCA KCU BANGKALAN Cs 0823-7497-7784
Wa:082374977784 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers