How many Records Will Get Selected

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by SQL Buzz » How many Records Will Get Selected

76 posts, Page 8 of 8

«««4 5 6 7 8

How many Records Will Get Selected

Rate Topic

Display Mode

Topic Options

Author

Message

Paul White

Posted Saturday, July 17, 2010 12:39 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:43 PM
Points: 10,990, Visits: 10,576

Stupid question. This post gives me one point back.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #954423

UMG Developer

Posted Monday, July 19, 2010 11:08 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:49 PM
Points: 2,163, Visits: 2,150

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. Wink

Post #954975

deeptidas23

Posted Thursday, December 30, 2010 4:58 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:56 PM
Points: 81, Visits: 22

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

Hugo Kornelis

Posted Sunday, January 02, 2011 3:13 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:55 AM
Points: 5,293, Visits: 7,230

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

Rafael Krisller

Posted Monday, June 06, 2011 1:14 PM

Old Hand

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:12 PM
Points: 369, Visits: 165

Trick question.

But I learned, if you need to change the script, you mustn't answer it!

Post #1120548

khullargirish02

Posted Monday, June 20, 2011 7:12 AM

Old Hand

Group: General Forum Members
Last Login: Monday, February 18, 2013 10:54 PM
Points: 371, Visits: 110

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.... Angry

Post #1128217

« Prev Topic | Next Topic »

76 posts, Page 8 of 8

«««4 5 6 7 8

Permissions