It will display the multiple
rows values in one row value.Like if there are 5 rows with values then that will be displayed in single row with specified separator.
2011-01-10 (first published: 2010-12-23)
3,640 reads
This procedure creates insert statements for the given table and given range of values of primary key column.
2011-01-07 (first published: 2010-12-23)
3,004 reads
This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.
2011-01-06 (first published: 2010-12-23)
2,108 reads
Map the Orphan Login and Users.
2011-01-03 (first published: 2010-12-15)
2,994 reads
A T-SQL script that reveals how appropriate your choice of column sizes is.
2010-12-30 (first published: 2010-03-18)
2,494 reads
Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.
2010-12-29 (first published: 2010-12-15)
1,510 reads
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
6,795 reads
SQL Script to generate columns for triggers
2010-12-27 (first published: 2010-12-10)
1,185 reads
I have added 2 functions here, one for email validation and another to split the string by specified separator by user.
2010-12-23 (first published: 2010-12-11)
1,699 reads