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,

---

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

0 Answers  

---

Which are ddl commands?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

What is difference between stored procedure and user defined function?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What are the default system databases in sql server 2000?

0 Answers  

---

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

---