How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

---

What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

What is self contained multi valued query?

0 Answers  

---

What is stored procedure in SQL..??

2 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

List all types of constraints in sql server?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Describe how to use linked server?

0 Answers  

---

Can you name some of the dml commands in sql?

0 Answers  

---