SQL syntax

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 mohammadk-1135894 » SQL syntax

38 posts, Page 1 of 4

1 2 3 4 »»»

SQL syntax

Rate Topic

Display Mode

Topic Options

Author

Message

mohammadk-1135894

Posted Thursday, May 27, 2010 10:20 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, March 11, 2013 11:25 PM
Points: 1,241, Visits: 81

Comments posted to this topic are about the item SQL syntax

Post #929438

malleswarareddy_m

Posted Thursday, May 27, 2010 10:24 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 12:06 AM
Points: 1,846, Visits: 974

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

mohammadk-1135894

Posted Thursday, May 27, 2010 10:33 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, March 11, 2013 11:25 PM
Points: 1,241, Visits: 81

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

Henrico Bekker

Posted Thursday, May 27, 2010 11:56 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

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

Jinesh-I

Posted Friday, May 28, 2010 12:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 6:14 AM
Points: 36, Visits: 36

I have been using
select *from table_name in SSMS 2005, since 2 years & it works fine.
Please try once.

Jinesh.

Post #929473

mohammadk-1135894

Posted Friday, May 28, 2010 12:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, March 11, 2013 11:25 PM
Points: 1,241, Visits: 81

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

emginet-874462

Posted Friday, May 28, 2010 12:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:47 PM
Points: 134, Visits: 285

Hi All the querys are correct

Post #929479

sharath.chalamgari

Posted Friday, May 28, 2010 12:53 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679

all the query works without any error

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

confusing Hehe

Post #929483

Carlo Romagnano

Posted Friday, May 28, 2010 1:27 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 1,969, Visits: 1,820

???????????????????????????????????
Cool

Try this:
select*from sysobjects order by 1desc
No space in 1desc

Post #929496

Hugo Kornelis

Posted Friday, May 28, 2010 1:55 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:48 AM
Points: 5,235, Visits: 7,037

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

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 »

38 posts, Page 1 of 4

1 2 3 4 »»»

Permissions