Below are few points which make difference between WQL and SQL :
- WMI provides its own query language that allows you to query managed objects as data providers
- WMI Query Language (WQL) is essentially a subset of SQL (Structured Query Language) with minor semantic changes.
- Unlike SQL, WQL does not provide statements for inserting, deleting, or updating data and does not support stored procedures.
- WQL does have extensions that support WMI events and other features specific to WMI. WQL is the basis for Configuration Manager queries, whereas SQL is used for ConfigMgr reports.
- One important advantage of WQL is that a WQL query can return WMI objects as well as specific properties.
- Because management applications such as the Configuration Manager console interact with WMI objects, WQL queries can return result sets that you can use within the ConfigMgr infrastructure.
Eg: Configuration Manager collections are based on WQL queries.
Ref: http://systemcentersupport.blogspot.com/2010/01/what-is-wmi-query-langauge-or-wql.html
No comments:
Post a Comment