Technical Article

Advanced Search Stored Procedure

The script finds occurrences of string(s) in stored procedures, triggers and views. You can use typical boolean logic as described in the script comments. Very useful.  It was found on the companion cd to [Gurus Guide to Transact-SQL] by Henderson.  I left in the original credits.  Excellent procedure.  Some may scoff but I place it […]

2004-07-15 (first published: )

558 reads

Technical Article

CSV Lists of Columns in Different Formats

This script creates comma separated lists of columns in different formats. These lists can be copied and pasted into other T-SQL statements.  The lists are formatted as: a simple list of column names, a list with the column names as declared variables (@ + column name + data type), a list with column names as […]

2002-12-26

198 reads

Blogs

Restore HEADERONLY and FILELISTONLY

By

Good day reader.  This post is coming to you from a busy week in...

DevOps From Redgate

By

In a few weeks at the PASS Data Community Summit, I’ll be joining several...

Daily Coping 4 Oct

By

Today’s coping tip is to free up time by canceling any unnecessary plans. I....

Read the latest Blogs

Forums

Bệnh thủy đậu: Nguyên nhân, triệu chứng, biến chứng và cách điều trị

By laciannette

Bệnh thủy đậu là bệnh lành tính, không có triệu chứng nặng nề ngoài...

Where to Buy Sugilite Gemstone for Spiritual healing powers

By bslmgold

Sugilite Gemstone Bertoua Savanna Local Miners (BSLMgold), Sugilite is one of the major love...

How to buy diseased free Ox/Cow Cattle Gallstone

By bslmgold

Bertoua Savanna Local Miners (BSLMgold) After extracting the gallstones from the cattle's intestines they...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers