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

SQL syntax Expand / Collapse
Author
Message
Posted Thursday, May 27, 2010 10:20 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:30 PM
Points: 1,669, Visits: 89
Comments posted to this topic are about the item SQL syntax
Post #929438
Posted Thursday, May 27, 2010 10:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,938, Visits: 1,162
I did not understand this question.in question it shows that to select wrong sytax.but all resturns table data without any error.then i did not found the wrong answer.so i applied three answers.got my point.

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #929440
Posted Thursday, May 27, 2010 10:33 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:30 PM
Points: 1,669, Visits: 89
Question was "Which of these SQL statements is correct?". Since all the SQL statements are correct then you have to check all the three answers.
Post #929443
Posted Thursday, May 27, 2010 11:56 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,904, Visits: 2,846
The question was:
"Which of these SQL statements is correct? Please guess error message for those stements which are wrong. (select all that apply)"

So 1st you have to select all the statements that are correct, then guess the error statements?

?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #929468
Posted Friday, May 28, 2010 12:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 2:59 AM
Points: 36, Visits: 41
I have been using
select *from table_name in SSMS 2005, since 2 years & it works fine.
Please try once.

Jinesh.
Post #929473
Posted Friday, May 28, 2010 12:36 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 9:30 PM
Points: 1,669, Visits: 89
Hi, It seems my question was little confusing. but I want to ask which of these SQL statement are right?

So all of the SQL statements was right!!! so you are rightly using the sytatement "select *from table_name"

Sorry for the confusion.
Post #929476
Posted Friday, May 28, 2010 12:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 9:13 AM
Points: 134, Visits: 334
Hi All the querys are correct
Post #929479
Posted Friday, May 28, 2010 12:53 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 10:39 AM
Points: 1,194, Visits: 787
all the query works without any error

You could have provided the a 4th option which says that all works without any error.

confusing
Post #929483
Posted Friday, May 28, 2010 1:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:53 AM
Points: 2,529, Visits: 2,402
???????????????????????????????????

Try this:
select*from sysobjects order by 1desc
No space in 1desc
Post #929496
Posted Friday, May 28, 2010 1:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:36 PM
Points: 6,002, Visits: 8,267
I agree with others that the second sentence of the question: "Please guess error message for those stements which are wrong. (select all that apply)" gave the impression that we had to check which answers would result in an error message.

Otherwise an intrigueing question about an interesting bit of information that, I hope, nobody will ever use in practice. I'm hoping to see more questions from you in the future.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #929503
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse