Display row value as a TABLE column using SQL select statement
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,720 reads
Gulappa Vijaya Kumar
Replace Object Owner
This SP is used to identify and replace the owner of the database objects. This SP will give display object id, object name, owner id, owner name and concatenate object + owner name with brackets. SP does change the owner for the following objects. SP should available in "master" database to execute in more than […]
2005-12-06 (first published: 2005-05-10)
333 reads
Convert Unique Identifier to Varchar data type
Script will drop the Default, Primary, Unique, Foreign Constraints, Index and ROWGUID on Unique Identifier data type column and finally it alters the unique identifier to varchar (38) data type. I have compile and execute the script in my database server. Script has executed successfully.
2005-01-12 (first published: 2004-12-24)
777 reads
DisplayColumnNames
This sp will return the column names for a table(s) and form a "Select Statement" for a table(s). We can pass a table name as a parameter to display a "Select Statement" for that table.
2004-03-04
118 reads
DependencyDetails
This sp will return the dependency details of the select table or all tables as a resultset. This resultset will display the dependency details if it is used in 1. select * from table or2. insert/delete/update dml statement or 3. select col1, col2 from table.
2004-02-25
230 reads
ClearData
We can use this sp to clear data in tables. I mainly created this sp for two reason. 1.This is useful to commence the testing from scratch. 2.Whenever we ask the database backup from our customer. They hesitant to give the production database because of confidential. I have used Delete and Truncate statement to clear […]
2003-11-06
180 reads
User-defined data type dependencies
MSSQLServer has got sp_depends system sp to display the dependencies for a stored procedure, table and view. sp_depends does not support to display the User-defined data type dependencies. For custom database, we will create user defined data types (UDDT) and add this UDDT to a column/variable in a table/stored procedure. This sp (UDTDepends) will help […]
2003-10-30
458 reads
Stabilize Index
This sp is used to update index in a database. This sp has got three optional varchar parameters. First parameter will take the tablename. Second parameter will take the indexname. Third parameter will take the fillfactor. The following option we can execute the sp in a user database.1. exec StabilizeIndexIt will update all index in […]
2003-10-29
288 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Lingkar Timur TELP/CS:083135765355
Whatsapp:083135765355 Jl. Salak No.99 & 100, Lkr. Tim., Kec. Singaran Pati, Kota Bengkulu, Bengkulu...
BCA KCP Pasar Minggu Tlp (+62 821°3111°179
Jl. Raya Pasar Minggu No.6, Kalibata, Kec. Pancoran, Kota Jakarta Selatan, Daerah Khusus Ibukota...
BCA KCP Batu Ceper Telp:Cs.08216977726
Whatsapp:08216977726 Kawasan Pusat Niaga Terpadu Blok A No. 8 F, Jl. Daan Mogot No.Km....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers