Answer Posted / anto

select getdate()

How many types of attribute relationships are there? : sql server analysis services, ssas

1020

---

How do you clear a log file?

997

---

How to find the login name linked to a given user name?

961

---

How to generate create table script on an existing table in ms sql server?

1112

---

how to determine the service pack currently installed on sql server? : Sql server database administration

930

---

What is replace and stuff function in sql server?

1014

---

What is #temp and @table variable in SQL server?

1037

---

Explain the phases a transaction has to undergo?

1005

---

How do you debug a procedure in sql server?

907

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1710

---

What are the advantages of having an index on the sql server?

885

---

What is normalization? What number of normalization shapes are there?

1065

---

Explain transaction server explicit transaction?

891

---

What is read committed?

1026

---

Which is better statement or preparedstatement?

878

---