Writing SQL Queries

[former_member418241]

Hi All

Does any body suggest where can we get SQL material to learn how to write advanced queries ?

Does anybody suggest any books to follow?

Is there a separate SQL language which is used by SAP Business One?

thanks

SV Reddy

Edited by: SV Reddy on Sep 29, 2008 5:39 PM

[Former Member · Accepted solution]

you may have a look at http://sqlcommunity.com/. this is a really good community for sql. of course there are some good books. In my opinion O´Reilly has the best.

[former_member418241]

Thanks All,

I have taken a note of all suggestions and looking for the material online.

points assigned

SV Reddy

[former_member186095]

Hi SV,

The query in the SBO GUI application is somewhat different with general SQL query. Nevertheless, it is useful to read the query book or join the community e.g. this forum link:

http://sql-server-performance.com/Community/forums/t/24533.aspx.

you could have more better query knowledge.

Rgds,

[former_member583013]

Hello Reddy,

Online material at Mirosoft website are a good source but some of the Advanced SQL books that are generally available in the stores/online are better presented and easy to understand and practise.

Best wishes

Suda

[Former Member]

All SQL referenses for SQL server are readily available online on Microsoft website. Go to: http://msdn.microsoft.com/en-us/library/bb545450.aspx to find everything your need. All references are well prepared including examples.

Thanks,

Gordon

[Former Member]

Hi SV Reddy

There are some minor differences between SQL transact and SAP Business One in that SAP has blocked some features of SQL such as UPDATE statements. It is important to remember that such commands should not be used, even outside of SAP Business One. With other words, any command that will update, remove, delete or change a field, table or record is not allowed by SAP. You are limited to a "READ ONLY" access via any SQL statements at SAP's request (or should I say insistence for support purposes).

You can look at Start > All Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > SQL Server Books Online (If installed),

or Start > All Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > Tutorials > SQL Server Tutorials for help as well as purchase any books on the subject.

Kind regards

Peter Juby