Explain what are the restrictions while creating batches in sql server?

0 Answers  

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

How to use the inserted and deleted pseudo tables?

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,

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

Define normalisation?

0 Answers  

---

How to create an inline table-valued function?

0 Answers  

---

Can you explain different types of locks in sql server?

0 Answers  

---

What is the security model used in sql server 2005?

0 Answers  

---

Are resultset updatable?

0 Answers  

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---