UDF that returns a DATETIME which is the concatination of the TIME portion of one DATETIME and the DATE portion of another.EXAMPLES:DECLARE @Date DATETIME, @Time DATETIMESET @Date = '7/1/03 16:00'SET @Time = '5/16/1999 9:30 AM'PRINT dbo.FN_AddDateTime(@Date,@Time )RETURNS: Jul 1 2003 9:30AMPRINT dbo.FN_AddDateTime(@Date,0)RETURNS: Jul 1 2003 12:00AM
2003-07-01
105 reads
This script is useful when want find out the list of the object on a given filegroup.
2003-07-01
254 reads
David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle!
2003-07-01
11,315 reads
2007-03-07 (first published: 2003-06-30)
435 reads
This article from Veritas does a good overview of the complexities involved in managing a SAN. SAN's are here to stay, even if you don't have one, you should be reading about them.
2003-06-26
550 reads
Sometimes you have to deal with denormalized database.And specially when links to another table are stored in oneof the fields as comma delimited list of IDs.This script shows how to make a single SELECT statement to fetch linked records
2003-06-23
323 reads
This script generates seril numbers (0, 1, 2, 3.4,,,)In this example I use 0 - 9999
2003-06-19
193 reads
Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.
2003-06-19
1,922 reads
This script kills all the user sessions except its own.This T-SQL block can be converted into a stored procedure by adding following lines in the begining of the script - Create Proc Kill_Sessions As
2003-06-18
2,788 reads
This function takes a decimal representation of a height value and returns a properly formatted string value. For example, a height of 5 feet 9 inches, which would be passed in as the decimal 5.90, would be returned as 5'9". Similarly, a height of 4 […]
2003-06-18
1,762 reads
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...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
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...
Comments posted to this topic are about the item Negative and Positive Numbers
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