Answer Posted / anindya basu
The different types of queries are:
a. DDL- e.g. Create, Alter, Rename, Drop, Truncate etc.
b. DML - e,g, Insert, Update, and De;e
c. DCL - Grant, Revoke etc.
d. TCL - Begin Tran, Commit Tran, Rollback Tran
e. DQL - Select
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the steps you can take to avoid “deadlocks”?
What are the requirements on sql server network connections?
How can I create a new template for import ? : sql server management studio
Explain transaction server explicit transaction?
What is 2nf normalization?
What is the purpose of a table?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Benefits of Stored Procedures?
What are the advantages dts has over bcp?
When columns are added to existing tables, what do they initially contain?
Where the sql logs gets stored? : sql server database administration
What is table level trigger?
Explain the difference between function and stored procedure?
What do you understand by triggers and mention the different types of it?