SFormat is UDF function that can convert seconds to HH:MM:SSEx:1- Select dbo.SFormat(130) will return 00:02:102- Select dbo.SFormat(dbo.test.Duration) as Dur (to be used with tables). where 'Test' is table name and 'Duration is a field(int).
2002-05-10
464 reads
Rather than invent (or learn) a whole new set of tools to preserve and version all DDL underneath our databases, we decided to use SourceSafe (something we're already using for all other source code). -- We've developed this VBscript to run nightly; it recreates object-level DDL in a given database and compares each object's script […]
2002-05-09
176 reads
This script gives the count of records of each user table in the current database along with the table name. This script eliminates the need of going through all the tables and counting them. Works on SQL 2000 (For SQL 7.0 - use 'rows' instead of rowcnt).
2002-05-09
2,385 reads
This script gives the count of records of each user table in the current database along with the table name using a single SQL Statement. It has been tested on SQL 7 and SQL 2000
2002-05-09
957 reads
Like the replace function, but can replace more than 1 value at a time.e.g. select dbo.multiple_replace('hello', 'e', '1', default) gives 'h1llo'. Equivalent to: select replace('hello', 'e', '1')e.g. select dbo.multiple_replace('hello world', 'e;w;ld', '1;2;END', default) gives 'h1llo 2orEND'e.g. select dbo.multiple_replace('hello world', 'e$w$ld', '1$2$END', '$') gives 'h1llo 2orEND'
2002-05-09
483 reads
This function was written to supplant cumbersome age-at calculations. To execute, simply set a local INT variable equal to the output of the function. For example, the following, given my birthdate, computes my own age: DECLARE @age_at INT SET @age_at = dbo.f_age_at ('2/16/1954', GETDATE ())
2002-05-09
1,077 reads
This script generates script to give permissions to Particular user(s) to give exectue permission. This can be changed to give permission to tables, views also.
2002-05-09
232 reads
This stored procedure will retrieve list of parameters for specified stored procedure.To check similar names,like 'myproc_xxx', pass any char in the second parameter(optional).
2002-05-09
1,246 reads
A user-defined function that returns a table of numbers between a and b (using the most efficient way I can think of).e.g. select * from table_of_numbers(1, 4) gives a table with rows 1, 2, 3 and 4.
2002-05-09
182 reads
This function takes a number of Seconds in BIGINT format and calculations and displays that in a DDD:HH:MM:SS format.I wrote this because I needed to work out the duration between two datetimes and required the result to be displayed in a Report (VARCHAR (12)) format from a Select statementTo Use:SELECT dbo.csp_SecondsToDaysHoursMinutesSeconds(DATEDIFF(SS, , )) AS DurationFROM […]
2002-05-09
353 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers