Answer Posted / sararh

where clause uesd for the fiend out particulater records and
where clause u write after select statement.

Having clause used for combination of group by functions
with out group by function u can nit write the having caluse.

How to modify existing triggers using "alter trigger"?

939

---

How do I clean up sql server transaction log?

995

---

How do you migrate data from mssql server to azure?

165

---

What is optimization and its types?

915

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1991

---

Who developed sql server?

877

---

How to sort query output in descending order in ms sql server?

903

---

whats new about truncate in sql server 2008?

2442

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

996

---

How do I view a script in sql server?

981

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

959

---

Explain how dts is used to extract, transform and consolidate data?

940

---

Does the order of columns in update statements matter?

860

---

Can a synonym name of a table be used instead of a table name in a select statement?

976

---

What’s the distinction between dropping a info and taking a info offline?

993

---