Get concatenated value for a column without cursor
This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.
2010-07-06 (first published: 2010-06-14)
2,334 reads
This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.
2010-07-06 (first published: 2010-06-14)
2,334 reads
This is a quick way of outputting the location of your database files/dbsize/date created on your instance.
2010-07-02 (first published: 2010-06-06)
1,395 reads
SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED
ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'
2010-06-30 (first published: 2010-06-08)
2,859 reads
2010-06-29 (first published: 2010-06-09)
1,195 reads
This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.
2010-06-23 (first published: 2010-06-01)
2,278 reads
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
3,462 reads
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2010-06-15 (first published: 2010-05-13)
1,916 reads
As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...
2010-06-14 (first published: 2010-05-07)
3,661 reads
IsNumber does weak checking and fails cast to BigInt so I wrote IsBigInt to replace it.
2010-06-11 (first published: 2010-05-05)
3,556 reads
Sometimes you need to scan a large number of datetime columns for most recent access.
2010-06-08 (first published: 2010-05-04)
1,907 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers