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

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

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?

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

What is schemabinding a view?

0 Answers  

---

How to select an exiting database using mssql_select_db()?

0 Answers  

---

How to replace given values with null using nullif()?

0 Answers  

---

How to delete a database in ms sql server?

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---