How to create stored procedures with parameters in ms sql server?

0 Answers  

---

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

---

select top 5 * from emp order by newid() my question is , how this query get executed?

5 Answers  

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

What is an active database?

0 Answers   HCL,

---

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,

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---