Thank this author by sharing:
By Luis Atondo, 2009/07/30
How to use:
DECLARE @DTest datetime
SET @DTest=dbo.GetDateTime('200907111400')
SELECT @DTest as Test
Result: 2009-07-11 14:00:00.000
This function gets a variable and converts to DateTime format string 'YYYYMMDDHHMM' Ex. '07/11/2...
Hi, 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.
Join us!
Steve Jones Editor, SQLServerCentral.com