Home > IT Blogs > SQL Server with Mr. Denny > T/SQL Back To Basics
>>VIEW ALL POSTS  

SQL Server with Mr. Denny

« New Article: Configuring SQL Server memory settings
New Paper Published: Bullet-proof Change Management – Don’t just Cross your Fingers and Hope »
Mar 3 2008   10:00AM GMT

T/SQL Back To Basics



Posted by: mrdenny
SQL Server 2000, SQL, SQL Server 2005, SQL Server 2008, Back To Basics

I’ve seen a lot of posts online over the last few weeks with people asking about basic query syntax.  So over the next few posts I’m going to show some basic T/SQL queries as well as some more “advanced” features and syntaxes.

Hopefully you’ll find these syntaxes useful.

All the code syntaxes will cover SQL 2000 and SQL 2005.  Where code only works in one version or another it will be noted.

Denny

AddThis Social Bookmark Button     Comment     RSS Feed     Email a friend

Comment on this Post


You must be logged-in to post a comment. Log-in/Register

MarlonR  |   Mar 6 2008   3:43AM GMT

and some codes/articles for the service broker…

-marlon ribunal


 

Mrdenny  |   Mar 6 2008   7:05AM GMT

Sure, I can write about service broker as part of the series. I’ve got some other stuff that I’ve got planned, so it’ll probably be a few weeks until it shows up on the site.

I’m a huge fan of Service Broker, so it’ll be no problem.

Denny


 

Mrdenny  |   Mar 6 2008   7:12AM GMT

If anyone else has a request for something they would like to see as part of this series, please feel free to let me know.