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 123»»»

Object_Id 1 Expand / Collapse
Author
Message
Posted Wednesday, February 22, 2012 9:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Comments posted to this topic are about the item Object_Id 1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1256386
Posted Wednesday, February 22, 2012 10:01 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 3:46 AM
Points: 2,223, Visits: 177
Thanks for the easy question.
Post #1256393
Posted Thursday, February 23, 2012 1:28 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:23 AM
Points: 1,632, Visits: 5,707
Does the collation actually make a difference here, or was that included as a bit of misdirection?
Post #1256451
Posted Thursday, February 23, 2012 1:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:36 AM
Points: 1,379, Visits: 510
But there is a documentation that it must be uppercase: ms179899
Post #1256465
Posted Thursday, February 23, 2012 2:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 5:11 AM
Points: 1,855, Visits: 508
Thanks for the easy question - nice to check the basics again.
Post #1256479
Posted Thursday, February 23, 2012 2:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:37 AM
Points: 1,037, Visits: 2,341
YAY!!!. I got one point.

(representation of N - has nothing to do with the collation)


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1256492
Posted Thursday, February 23, 2012 6:28 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Made me think for a minute and I got my point. Thanks for submitting.

http://brittcluff.blogspot.com/
Post #1256597
Posted Thursday, February 23, 2012 7:01 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 12:56 AM
Points: 9,928, Visits: 11,198
And once again I fail as a T-SQL parser.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1256622
Posted Thursday, February 23, 2012 7:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:08 AM
Points: 1,262, Visits: 13,557
good question!
thanks!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1256645
Posted Thursday, February 23, 2012 7:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:08 AM
Points: 2,625, Visits: 1,056
Good syntax question; not sure why collation info was included. Thanks!
Post #1256657
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse