Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.
I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.
Let me know your opinion and if you find this useful.
Download SQL Server Cheatsheet
Reference : Pinal Dave (https://blog.sqlauthority.com)
64 Comments. Leave new
Hi pinaldave,
I found this cheat sheet is very useful for me.
wonderful idea… :)
regards
Vasanth
the cheat sheet is very useful.thanks
this is nis
I can’t download the cheatsheet, my browser is grinding for a long time with no file download. Please help.
Srikanth,
I did not find any problems. Please try again.
Regards,
Pinal
Sorry my bad. It worked today :) I downloaded the cheat sheet.
Thanks the cheat sheet is really useful. You have done a wonderful job.
Good print out to have near me on my desk, thanks!
Very usefull – thanks!
Hello Sir,
The information there on this blog is very useful & helpful thanks for providing such informative infromation.
Sir i have a query in ms-sql server2000
can we convert numeric(18,0) to identity(1,1) which will be primary key ,
since this ID numeric(18,0) is a foreign key in another table so i wanted that this key should be as primary auto incrementing key
whereas i am also unable to do insert into statement for the same
error ocuuring is as : Cannot insert explicit value for identity column in table
Can you please help me out.
Thanks for Sheet , Great Idea …. Really Use ful .. Thanks a Lot …
Clear, infomartvie, simple. Could I send you some e-hugs?
nice
Ya… Its a Good One..
Kishor K
MCTS
-Kerala
I am unable to download the Cheat Sheet.
Can you assist me to download the file. it give me error on my browser.
Thanks
Sudarshan
This sheet really nice and very usefull for all levels.
Thanks
Veerendra
This Cheat Sheet is very good and usefull for Beginners
HI pinaldave,
Really its usefull….I found most of the things , This is more than enough for glance
hi, i would like to ask a question,
do you know how to get month from a query?
if i want to get a date, i use
select birthday
from user
where…
what if i want to get a query where the birthday month is May for example?
where datename(month,birthday)='may'
HI Dave sir,
I m new to sql server .. can u please provide me some links where i can find out how sql server is used on application point of view. How we stored procedures are useful in practical scenerio..
provide me some good links for clearing basic concepts
Thanks soo much for your help.
regards
Harpreet
Hi,
Can anybody tell me the difference between server studio and server studio express?
Dont mind if this is silly qtn. m new to sql server.
thanks munch in advance.
Hello Sir,
i have a query on Sql server 2000. Can we Restore selective databases from Tape Drive(BrightStor ARCserve Backup Tape Drive) having tape of Ultrium(800 GB) to a remote server’s folder location through Query analyser. Because it is showing error in restoring that database to that remote server from that Tape Drive due to Space issue. So i want to directly restore that database from query analyser without coping it to that location and then from there to restore.
regards
manoj kumar