Thank this author by sharing:
By Luis Atondo,
How to use:
DECLARE @DTest datetime
SELECT @DTest as Test
Result: 2009-07-11 14:00:00.000
This function gets a variable and converts to DateTime format string 'YYYYMMDDHHMM'
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 h...
Post by Dhananjay
Format of the field returned in the output of isql & SQLCMD is different
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.