Basic Commands

[WaitronUnit]

New to SQL... where's a source on the 'net that provides some basic SQL stuff for beginners? I'm involved with a POS project that requires extracting sales and item data from a SQL-based app and just need some basics to get started.

 

[nigelrivett]

Don't you have anyone to help you?
Just finding the syntax isn't going to help in writing efficient (or correct) queries.

Have a look in bol (books on-line) which should have neen installed with sql server.
If not

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[WaitronUnit]

nigelrivett -

Thanks for the tip... everything helps right now; became the "go-to guy" when a company's IT guru took another job and I just happened to be onsite performing a POS installation.

I'll check out your recommendation.

 

[sunila7]

Have a look at this FAQ in FAQ's section apart from nigelrivett's suggestion

Sunil

 

[sunila7]

forgot to put the FAQ no ;-) faq183-513

Sunil

 

[SQLBill]

BTW-to add to Nigel's comment about the BOL, you can find it at Start>Programs>Microsoft SQL Server>Books OnLine.

(Also, you are using Microsoft SQL Server aren't you? If not, then these suggestions won't really be of help. MS SQL Server's Transact-SQL is different from the other forms of SQL (MS Access, Oracle, MySQL, SyBase, etc.)

-SQLBill