Mention the differences between having and where clause.

0 Answers  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

What are the difference between primary keys and foreign keys?

0 Answers  

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

How would you use user_constraints table in DB?

0 Answers   Wipro,

---

How many cores do I need for sql server 2016?

0 Answers  

---

What is msdb database? : SQL Server Architecture

0 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---