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: Today @ 8:45 AM
Points: 5,590, Visits: 24,974
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: Today @ 8:53 AM
Points: 1,632, Visits: 5,584
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: 2 days ago @ 10:51 AM
Points: 1,320, Visits: 480
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: Today @ 1:38 AM
Points: 1,755, Visits: 477
Thanks for the easy question - nice to check the basics again.
Post #1256479
Posted Thursday, February 23, 2012 2:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:32 AM
Points: 919, Visits: 2,089
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:32 PM
Points: 11,194, Visits: 11,140
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: Wednesday, July 23, 2014 11:04 AM
Points: 1,256, Visits: 13,552
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: Today @ 7:58 AM
Points: 2,528, Visits: 1,030
Good syntax question; not sure why collation info was included. Thanks!
Post #1256657
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse