Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

What is a job?

3 Answers  

---

Explain the creation and execution of a user-defined function in the sql server?

0 Answers  

---

What are the purposes and advantages stored procedure?

0 Answers  

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---

What is clustered primary key?

0 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

How to Get the last identity value used

4 Answers  

---

Does index speed up select statements?

0 Answers  

---

How many primary keys are possible in a table?

0 Answers  

---