SQL Script

Question

SQL Script

martin.kerr 34088

SSCommitted

Points: 1752
More actions
July 18, 2011 at 2:21 am

#389995

Hi, I am quite new to SQL and would like a list of all the script words/language that i will need if possible.
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 1

you can go thorugh the script section of SSC. There are quite many useful scripts. Apart go through the system functions and DMVs that would really help you out from BOL.

martin.kerr 34088 SSCommitted Points: 1752 More actions · Answer 2

ok thanks for that, but what i was looking for was starting simple script e.g. GO, FROM ect and what it actually does.

Thanks

sonwane.pratibha SSC Journeyman Points: 88 More actions · Answer 3

just right clik on table-->script to table--> will avaialable all create/alter/drop etc select --> click new query window

martin.kerr 34088 SSCommitted Points: 1752 More actions · Answer 4

Thanks for the reply, but all i am looking for is a document that states what does what in the script.

kramaswamy SSCoach Points: 18181 More actions · Answer 5

there's plenty of beginner-level tutorials in to database programming. The site that I find does the job best is W3Schools. See here for their tutorial on SQL: http://www.w3schools.com/sql/default.asp

GSquared SSC Guru Points: 260824 More actions · Answer 6

Books Online or MSDN have the definitions of what the T-SQL commands/functions/clauses do.

For examples:

GOTO http://msdn.microsoft.com/en-us/library/ms180188.aspx

FROM http://msdn.microsoft.com/en-us/library/ms177634.aspx

And so on.

Just search MSDN for the keyword you want. I use searches like "t-sql goto" and "t-sql from".

- 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

Bruce W Cassidy SSChampion Points: 12668 More actions · Answer 7

Try hitting the F1 key. I actually find the SQL Server books online pretty handy.

Eric M Russell SSC Guru Points: 125560 More actions · Answer 8

martin.kerr 34088 (7/18/2011)
Hi, I am quite new to SQL and would like a list of all the script words/language that i will need if possible.
Thanks

"To know ten thousand things, know one well" — Miyamoto Musashi

http://msdn.microsoft.com/en-us/library/ms167593.aspx

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho