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,692 reads
Display row value as a TABLE column using SQL select statement
2012-01-12 (first published: 2007-10-26)
4,692 reads
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)
316 reads
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)
681 reads
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
105 reads
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
210 reads
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
155 reads
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
446 reads
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
276 reads
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Dears, I was told that I cannot access delta files in SQL Server Managed...