T-SQL datediff function

by Joe Hunter 5. March 2010 16:34

To get the difference in days between two dates use the DateDiff function.

Example:

select datediff(d, mydob , getdate()) as [My Age in Days]

T-SQL function to return name of log file for a database ALTER FUNCTION [dbo].[UDF_DB_LOG_FILE_NAME] ( &...Encrypting stored procedures and functionsTo encrypt sprocs and functions prior to deployment include the WITH ENCRYPTION option: E.g. CREATE...Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servername