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 «««45678

How many Records Will Get Selected Expand / Collapse
Author
Message
Posted Saturday, July 17, 2010 12:39 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 4:18 PM
Points: 9,928, Visits: 11,206
Stupid question. This post gives me one point back.



Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #954423
Posted Monday, July 19, 2010 11:08 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Paul White NZ (7/17/2010)
Stupid question. This post gives me one point back.


Yeah, but not on your "Question of the Day" score.
Post #954975
Posted Thursday, December 30, 2010 4:58 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:39 AM
Points: 81, Visits: 26
when we run it on sql server only one record is getting stored in table becoz of check constraint.how come only 3 records??Can anyone explain me after executing in sequel
Post #1040817
Posted Sunday, January 2, 2011 3:13 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:02 PM
Points: 6,133, Visits: 8,395
deeptidas23 (12/30/2010)
when we run it on sql server only one record is getting stored in table becoz of check constraint.how come only 3 records??Can anyone explain me after executing in sequel

If you executed the script exactly as shown, there would not have been a check constraint. The ALTER TABLE statement that creates it has a syntax error, and therefore is not executed.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1041665
Posted Monday, June 6, 2011 1:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:09 AM
Points: 395, Visits: 168


Trick question.

But I learned, if you need to change the script, you mustn't answer it!
Post #1120548
Posted Monday, June 20, 2011 7:12 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, September 21, 2014 12:18 AM
Points: 375, Visits: 116
I do not like this kind of question at all. The QotD should be a learning opportunity, with clear questions and no tricks.

There is nothing to be learned from this question. In a real situation, the error in the syntax would be obvious as soon as the code is executed, and it would be corrected before users get to add data.

It was a bad question as per me....
Post #1128217
« Prev Topic | Next Topic »

Add to briefcase «««45678

Permissions Expand / Collapse