What is the use of Port no?

1 Answers   Wipro,

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

how many no of arguments can be passed in procedures and functions

1 Answers   ABC,

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

What are the types of 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 are the tables in sql?

0 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is normalization? Explain its different types?

0 Answers   GE, Maveric,

---