Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Luis Atondo,
To use this function:
DECLARE @DTest NVARCHAR(12)
SELECT @DTest as Test,getdate()
Result : '200907111405'
SET @DTest=dbo.GetDateTimeString('01/05/2009 2:00 PM')
SELECT @DTest as Test
Result : '200901051400'
This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM'
I have a single test.sql file with about 7 stored procedures in it.
create proc xxx1 as
We are writing queries to determine if a transaction log was truncated since the last backup. We ha...
Post by Dhananjay
Format of the field returned in the output of isql & SQLCMD is different