Basic SQL query scripts for SAP B1

[Former Member]

hi guys,

do you have any documents, guides or reference links regarding basic SQL query scripts for SAP B1?

thanks and have a nice day!

blake p.

[Former Member]

Hi

You can also check SBONotes.com.

For sql understanding , you can search in websearch - tsql and it will pop up with informations you need.

You can also refer to forum once you understand the basic techniques

Hope this helps

Bishal

[Former Member]

Hello Blake,

Check this link http://msdn.microsoft.com/en-us/library/ms189826.aspx

Suda

[Former Member]

Hi Blake,

One to get basic SQL query scripts for B1 would be searching this forum. There are many queries available here.

Thanks,

Gordon

[Former Member]

Hello Blake,

If you would like to learn SQl then there are many website to learn the logic of SQL as Business One is mainly based on SQL transactions. However could be please explain more clearly what it is that you are trying to achieve?

Regards,

Paul