What is the largest component inside a field?

0 Answers  

---

How to create function without parameter in sql server?

0 Answers  

---

What are user defined functions in ms sql server?

0 Answers  

---

Define magic tables in sql server?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

what is a deadlock? : Sql server database administration

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 purpose of a table?

0 Answers  

---

Explain index in sql server?

0 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

How to use values from other tables in update statements in ms sql server?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---