What is user defined stored procedures?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

How to check status of stored procedure in sql server?

0 Answers  

---

What are the transaction properties?

0 Answers  

---

Is there any difference between the primary key and unique key?

0 Answers  

---

---

How to connect PK and FK?

2 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

---

How to round a numeric value to a specific precision?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---