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 […]

You rated this post out of 5. Change rating

2004-07-15 (first published: )

626 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 […]

You rated this post out of 5. Change rating

2002-12-26

198 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

Estimated rollback completion: 0%. Estimated time remaining: 0 seconds

By xiaoluma

Greetings! I have a process that has been running for over a day (normally...

Need help read JSON file

By Adelia

Hello, I've JSON file format as following, { "acc_div": [ { "level1_code" : 1104,...

Troubleshooting sql issue where multiple sessions are involved

By vsamantha35

Hi All, We have an application that spawns multiple spid's, runs multiple multiple batches...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers