Answer Posted / umesh roy

Above code spelling are wrong on save Transaction
correct code are below which is executeable

begin transaction
save transaction t
delete from tablename where id=2
select * from tablename
------------------------------------------------------
the value id=2 will be deleted in the tablename
-------------------------------------------------------
rollback transaction t
select * from tablename

Explain for xml explicit mode?

970

---

Can you explain what is indexed view? How to create it?

893

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2742

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1007

---

What are the differences between DDL, DML and DCL in SQL?

1224

---

Name some of the open source software that you can use in alternative to SSR?

159

---

What are the different types of indexes?

1109

---

Can we add an identity column to decimal datatype?

993

---

How to connect php with different port numbers?

1075

---

How sql server executes a statement with nested subqueries?

1024

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1072

---

What is the difference between a stored procedure and a user defined function?

1016

---

How do you know if sql server is running on your local system?

1036

---

What command do we use to rename a db, a table and a column?

923

---

What is correlated subquery in sql server?

1062

---