Here is a simple view that is useful to pull basic data dictionary information out of your DB user tables. The description field is an extended property that I like to use for built in documentation of fields. This only works with 2000, 7 had a slightly different layout for the system tables.
2004-10-27 (first published: 2004-08-20)
336 reads
Updated! Now supports both SQL Litespeed and native backup commands in one script! Several new bug fixes please see the header of the script. Error messages to add are now at the bottom of the script! This stored procedure will backup a single database or all databases it will also perform ether a full, diff, […]
2004-10-26 (first published: 2004-05-27)
990 reads
usp_restore - This will restore a backup performed with SQL LiteSpeed from DBAssocatesIT or by the standard backup database routines in SQL Server Please check below the declarations to find the user settable options for this script If the target database is currently in a loading status or cannot be read from this restore it […]
2004-10-25 (first published: 2004-05-27)
618 reads
A kind of sp_lock with an ORDER BY possibility. It gives also the name of the locked object (table) if executed in the same database.
2004-10-22 (first published: 2004-07-26)
716 reads
This code will show rows from 17th and then next 3 ordered by name from table authors in database pubs. Table must have primary key and of course ordered column. You can change value 'from' in line 'SET ROWCOUNT 17' and value 'next' (how many rows)in line SELECT TOP 3. It is good to show […]
2004-10-21 (first published: 2004-07-29)
198 reads
integer IP-address converted to varchar dot-notationUsage SELECT dbo.IPNumberToString(-2037012288)
2004-10-20 (first published: 2004-07-29)
430 reads
This is a modification to Automate Audit Trigger Generation at http://www.sqlservercentral.com/scripts/contributions/1073.asp by walkerjet. The changes were made to accommodate tables using different types for their primary keys, (i.e. int, smallint, char, etc.), add the ModifiedById and DTStamp columns, exclude legacy tables that do not have a primary key defined, exclude fields of type text, ntext, […]
2004-10-19 (first published: 2004-07-29)
359 reads
After seeing a thread in the forums about converting a Julian date to Gregorian, I decided to write these functions. There are two functions in the script, getJulian and getGregorian. getJulian accepts a datetime parameter and returns the Julian date as an integer. getGregorian accepts an integer and returns the Gregorian date as datetime. A […]
2004-10-18 (first published: 2004-08-03)
1,096 reads
This User defined Function will provide you the facility of fetching the nth Value from a Delimited string. The Parameter for the function which you have to pass is, the Delimited String, the Delimiter of the string, nth Position of the string. In this function , you can dynamically change the Delimiter as well as […]
2004-10-15 (first published: 2004-08-04)
1,436 reads
If you set up a default on a column AFTER data has been entered, then this procedure will apply the default to all NULL values within that column. Limitations: It only works with numeric values right now.You will also need the INSTR function, which you can also get from this site.This is my first […]
2004-10-13 (first published: 2004-07-22)
94 reads
By Steve Jones
Train employees well enough that they could get another job but treat them well...
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Comments posted to this topic are about the item Create an HTML Report on...
Hi when i think of server hops , i think of how kerberos assists...
Comments posted to this topic are about the item Can/Can't Do/Don't
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers