Understanding the syntax of the Insert,Delete,Merge.. and more syntax

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Articles Requested » Understanding the syntax of the...

Understanding the syntax of the Insert,Delete,Merge.. and more syntax

Rate Topic

Display Mode

Topic Options

Author

Message

jwbart06

Posted Tuesday, July 26, 2011 11:48 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:26 AM
Points: 2,197, Visits: 374

I believe it would be a great article or stairway to understanding how to read the syntax presented in say MCTS database developement exam book.

example:

Insert Statement Syntax

The insert Syntax is as follows:

[WITH <common_table_expression> [,.....n]]
INSERT
[ TOP (expression) [ PERCENT]]
[ INTO ]
{ <object> | rowset_function_limited

So what is "rowset_function_limit", what are the "[" for and for understanding sake what "|" is, which I know means "or", but that is my point. I think it would benefit me as well as other developers to understand everything in the syntax of the SQL syntax.

If there is an article or link to one that would be great as well.

Thank you, Cool

Post #1148541

Steve Jones - SSC Editor

Posted Tuesday, July 26, 2011 12:24 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Interesting. I'll see if we can come up with an article on this.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1148567

GSquared

Posted Tuesday, July 26, 2011 12:44 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

Does this help? http://msdn.microsoft.com/en-us/library/ms177563.aspx

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1148582

jwbart06

Posted Tuesday, July 26, 2011 2:55 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:26 AM
Points: 2,197, Visits: 374

That does help, I don't know why I couldn't find it?

Thank you,
BigGrin

Post #1148707

« Prev Topic | Next Topic »

Permissions