T SQL Commands

Question

T SQL Commands

jrw39

Mr or Mrs. 500

Points: 565
More actions
August 14, 2009 at 8:52 am

#203843

I was wondering if anyone knew of a link to a website that has T SQL Commands such as greater than, less than, blank, null, etc... I'm still converting Access 07 queries to SQL Server 2005 and I'm making significant progress thanks to the suggestions I've received out here.
Thanks in advance

Viewing 7 posts - 1 through 6 (of 6 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

No website required. You can get all of this from BOL (Books Online, the SQL Server Help System). You can access it from SSMS by pressing the {f1} function key.

jrw39 Mr or Mrs. 500 Points: 565 More actions · Answer 2

jrw39

Mr or Mrs. 500

Points: 565

August 14, 2009 at 9:18 am

#1039448

thanks

😀

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

try this

http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Grant Fritchey SSC Guru Points: 398913 More actions · Answer 4

And the Books Online can be accessed... wait for it.... online:

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

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 5

Grant Fritchey (8/14/2009)
And the Books Online can be accessed... wait for it.... online:
http://msdn.microsoft.com/en-us/library/ms130214.aspx

.. but you can use Lynn's approach for accessing Books Online offline.

😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 6

Alvin Ramard (8/14/2009)
Grant Fritchey (8/14/2009)
And the Books Online can be accessed... wait for it.... online:
http://msdn.microsoft.com/en-us/library/ms130214.aspx
.. but you can use Lynn's approach for accessing Books Online offline.
😀

Peraonally, I'm still waiting for Books Inline. 😛

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]