What are out-of-range errors with date and time literals?

0 Answers  

---

List out different types of normalizations in sql server and explain each of them?

0 Answers  

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What are different types of data sources?

0 Answers  

---

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,

---

Can two tables share the same primary key?

0 Answers  

---

How to list all login names on the ms sql server?

0 Answers  

---

How many clustered indexes there can be on table ?

0 Answers  

---

Can you pass expressions to function parameters?

0 Answers  

---