When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

How to drop an existing table with "drop table" statements in ms sql server?

0 Answers  

---

What is executereader?

0 Answers  

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

How to round a numeric value to a specific precision?

0 Answers  

---

What is a subquery in a select query statement in ms sql server?

0 Answers  

---

How to delete a login name in ms 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,

---

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

What is the downside of using udf?

0 Answers  

---