Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script Logins Expand / Collapse
Author
Message
Posted Saturday, April 2, 2011 2:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 14, 2015 10:48 AM
Points: 26, Visits: 138
Comments posted to this topic are about the item Script Logins
Post #1087825
Posted Monday, April 4, 2011 6:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 4:39 AM
Points: 309, Visits: 1,138
Just a reminder that in SQL Server 2008 onwards you can use the following to represent a binary value as a character string (rather than a CTE or sp_hexadecimal):

SELECT CONVERT(VARCHAR(12), 0x68656c6c6f, 1)

--0x68656C6C6F

Chris
Post #1087993
Posted Monday, April 4, 2011 7:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 14, 2015 10:48 AM
Points: 26, Visits: 138
True, thank you, that would eliminate the need for those CTEs. I wish the servers in our environment were all 2008.
Post #1088045
Posted Monday, April 25, 2011 2:37 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 3:31 PM
Points: 340, Visits: 1,546
This Script is generating all kinds of Syntax Errors both in SQL 2005 and SQL 2008R2! Does anyone faced the same issue?
Post #1098291
Posted Monday, April 25, 2011 8:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 14, 2015 10:48 AM
Points: 26, Visits: 138
I have had errors with non-default collations or trying to create the procedure in a database in 80 compatibility. Hard to guess without knowing the errors.
Post #1098386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse