Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Thursday, March 13, 2014 7:50 AM
Points: 26, Visits: 120
Comments posted to this topic are about the item Script Logins
Post #1087825
Posted Monday, April 4, 2011 6:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 3:33 AM
Points: 278, Visits: 1,068
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: Thursday, March 13, 2014 7:50 AM
Points: 26, Visits: 120
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 260, Visits: 1,030
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: Thursday, March 13, 2014 7:50 AM
Points: 26, Visits: 120
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