What are the different types of queries?
Answer / 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 |
How to use subqueries in the from clause in ms sql server?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What types of Joins are possible with Sql Server?
Can you pass expressions to stored procedure parameters?
Can we perform backup restore operation on tempdb? : sql server database administration
How can i change the column name.
13 Answers HCL, Yardi Software,
What is schemabinding a view?
How to select an exiting database using mssql_select_db()?
How to replace given values with null using nullif()?
How to delete a database in ms sql server?
Which virtual table does a trigger use?
how do we insert 100 records at a time in a table without using for loop in database
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)