Answer / Sumeet Bhatnagar

SQL supports several types of statements to manipulate and query data in a relational database:
1. Data Definition Language (DDL) Statements: These statements are used to create, alter, or delete database objects such as tables, views, indexes, and schemas.
2. Data Manipulation Language (DML) Statements: These statements are used to insert, update, delete, and retrieve data from the database.
3. Transaction Control Statements: These statements are used to manage transactions, such as COMMIT, ROLLBACK, SAVEPOINT, and BEGIN TRANSACTION.
4. Catalog (Metadata) Statements: These statements are used to retrieve information about database objects, such as DESCRIBE, TABLE, INDEX, and SP_HELP.
5. Control of Flow Statements: These statements are used to control the flow of execution in SQL code, such as IF-ELSE, CASE, LOOP, WHILE, and GOTO.

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

How do indexes help, types?

1 Answers  

---

What is 4nf in normalization form?

1 Answers  

---

Explain in brief about Microsoft SQL server?

1 Answers  

---

What are locks in sql?

1 Answers  

---

What are the different types of replication are there in sql server 2000?

1 Answers  

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1 Answers  

---

in how many ways we can use count()

2 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

What is an Index?

3 Answers   Yardi Software,

---

what is sql injection in sql server?

2 Answers   TATA,

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---