What is DQL? Dynamic Query Language?

Posted by Naimishforu under Sql Server on 2/10/2011 | Points: 10 | Views : 4165 | Status : [Member] [MVP] | Replies : 3
What is so called as DQL? Something Dynamic Query Language?? Can anyone please describe the proper use of it??

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/



Responses

Posted by: Dn2010 on: 2/10/2011 [Member] Starter | Points: 25

Up
0
Down
hi,

Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements. This can be helpful when it is necessary to write code that can adjust to varying databases, conditions, or servers. It also makes it easier to automate tasks that are repeated many times.

Dynamic SQL statements are stored as strings of characters that are entered when the program runs. They can be entered by the programmer or generated by the program itself, but unlike static SQL statements, they are not embedded in the source program. Also in contrast to static SQL statements, dynamic SQL statements can change from one execution to the next.

Dynamic SQL statements can be written by people with comparatively little programming experience, because the program does most of the actual generation of the code. A potential problem is reduced performance (increased processing time) if there is too much dynamic SQL running at any given time.


THANKS.

Naimishforu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Naimishforu on: 2/10/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
HI,

Thanks, but I want to understand the same in simple language.

I have already done Google :)

Thanks

Thanks,
Naimish
http://dotnetinterview.zxq.net/
http://naimishpandya.blogspot.in/

Naimishforu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 2/10/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
In simple
DQL language:means Data Query Language which is used to retrieve information from the table... SELECT Statement is DQL

Thanks
Karthik
www.f5Debug.net

Naimishforu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response