Help needed to learn SQL

[Former Member]

Hi,

My new client has SQL database on Wndows2k.I am working as a Basis Consultant and new to SQL.

Can anybody help me with necessary docs,links,ebooks etc to gain mastery over SQL databse ? Any help regarding know-how of SQL db from BASIS perspective will be extremely helpful.

Points guarranteed.

Thanks,

s<i><b>A</b></i>mik.

[Former Member]

Yes from the SAP standpoint only Architecture Details , Optimization / Performance and Backup / Recovery procedures are required.

Regards,

Siddhesh

[Former Member]

Hi Siddhesh,

Any link on "important SQl queries" that can be run from Query Analyzer,some basic queries,e.g. how to check version of a database etc.

Thanks,

s<i><b>A</b></i>mik.

[Former Member]

Hi,

Start SQL Query Analyzer with admin privledges and give this query:

SELECT @@VERSION

GO

Or else, check this link, for another way:

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Regards,

Siddhesh

Message was edited by:

Siddhesh Ghag

[Former Member]

Another suggestion is that with the current information you have , you should go on exploring on your own , I am sure you will find lot of interesting stuff available on various websites provided by me and others.

Regards,

Siddhesh

[Former Member]

Hi,

Thanks for the query.It worked.

Regards,

s<i><b>A</b></i>mik.

[Former Member]

Hi Samik,

Glad it worked, if your question is answered, you should mark this question as answered.

Regards,

Siddhesh