Answer Posted / rajkumar v

select convert( varchar(20), getdate(), 103)

What happens if null values are involved in comparison operations?

970

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

983

---

What is the difference between Normalization and De-normalization?

1090

---

Where the sql logs gets stored? : sql server database administration

962

---

Can we use pragma autonomous_transaction in trigger?

962

---

What are data driven subscriptions?

112

---

What is the purpose of sql profiler in sql server? : sql server database administration

1105

---

How do I find query history in sql server?

942

---

What are the properties of the transactions?

1119

---

What happens to a statement batch if there is a compilation error?

966

---

How does normalization work?

917

---

what's the information that can be stored inside a bit column? : Sql server database administration

1033

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

974

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

978

---

What is index fragmentation in ms sql server?

1082

---