This scipt is inspired by FormatDate - Mimics the VB Format routine for date. But this script work actually only whith a english Server. I improved this by a language independant. I use 2 others functions to retrieve the Long and short month name.
2006-02-27 (first published: 2004-07-23)
211 reads
This script takes a string of up to 8000 characters with a single character delimtier and returns a table with each substring in its own row. A identity column is also returned so you can easily find the n'th item in the list.Script is similar to kmlakov's but doesn't require the item count and adds […]
2006-02-21 (first published: 2005-01-19)
1,262 reads
This script notifies the DBA or Developers with the list of failed jobs. This script useful if you want to use either Mater-Target server option or even single server to monitor the Target servers jobs. You must have SQL MAIL configured on the SQL Server.
2006-02-20 (first published: 2004-08-25)
2,109 reads
Once devs are pushed toward using parameters, they get confused as to why their sp is not reused and has many compilations when in use.The reason is most of the time, that the parameters are defined with a wrong datatypemapping in the application or have different datatypes in a # of applications.I use this proc […]
2006-02-16 (first published: 2006-02-06)
305 reads
2006-02-15 (first published: 2006-02-13)
1,425 reads
This script has been on the SQL Server Central site for a while and has been revised a number of times. I enclose yet another revision that works with SQL Server 2005 (June CTP anyway) with much thanks to all those who have contributed to it in the past.Terry Grignon
2006-02-08 (first published: 2005-11-11)
1,091 reads
This script will dump most of the structure of a DTS package to a text file. This includes connections strings (note SQL Server connections have their passwords encrypted so the won't dump), tasks, steps, global veriables, etc.) The script is command line drive and should allow for the use of trusted or SQL logins. I […]
2006-02-07 (first published: 2006-01-30)
390 reads
Uses sp_ob by Saket Mittal to search all databases for objects of a like name. Examples: To search for a table named 'customer' : exec master..usp_SearchObjectsAllDBs @searchname = 'customer', @type = 'U' To search for a procedure named 'customer' : exec master..usp_SearchObjectsAllDBs @searchname = 'customer', @type = 'P'
2006-02-02 (first published: 2006-01-18)
109 reads
2006-02-01 (first published: 2006-01-27)
1,862 reads
2006-01-31 (first published: 2006-01-27)
134 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers