Which stored procedure will you be running to add a linked server?

1 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

What happens if an integer is too big for int date type?

0 Answers  

---

Why do we use trigger?

0 Answers  

---

What is normalization and its forms?

4 Answers   Challenger Financial,

---

Simple example for difference between select and cursor in sql

1 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

How will you add a dimension to cube? : sql server analysis services, ssas

0 Answers  

---

What are the properties of sub-query?

0 Answers  

---