Answer / Sarvesh Kumar

A new table can be created using the SELECT INTO statement. For example: SELECT column1, column2 INTO new_table FROM old_table;

Which is better statement or preparedstatement?

1 Answers  

---

Can you explain the disadvantages/limitation of the cursor?

1 Answers  

---

Explain steps of normalization?

1 Answers  

---

How many databases Microsoft SQL server provides?

1 Answers   Abacus,

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

What is precedence constraint?

1 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

Explain an automatic checkpoint

1 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---