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
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Explain what stored procedure sp_replcounters is used for? : sql server replication
Define compound operators?
What are the differences between stored procedure and view in sql server?
How to create an index on an existing table in ms sql server?
What is clustered primary key?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How many types of attribute relationships are there? : sql server analysis services, ssas
Do you know what is replace and stuff function in sql server?
How to invoke a trigger on demand?
What is TDS(Tabular Data Stream) Gateway?
What are built in functions?
What’s the use of custom fields in report?
How to use old values to define new values in update statements in ms sql server?
What is replication and database mirroring?