How much space does sql server 2016 take?

0 Answers  

---

How to optimize stored procedures in sql server?

0 Answers  

---

Can we use where clause in union?

0 Answers  

---

What are the differences between stored procedure and the dynamic sql?

0 Answers  

---

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

What are ddl triggers and types of ddl trigger?

0 Answers  

---

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

---