Answer Posted / deepak rohilla

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

Can group by be used without aggregate functions?

898

---

How we can refresh the view?

1097

---

What is a hint?

973

---

What is the difference between set and select?

1074

---

What is difference between sql and sql server?

973

---

How to modify an existing user defined function?

1082

---

User wants only to display only pdf as export option in report manager. How to achieve this?

259

---

What is extended stored procedures?

944

---

Do you know the isolation level that sql server support?

948

---

What is data mart? : sql server analysis services, ssas

1036

---

How to scale out a federation by Sql statement?

116

---

What happens if time-only values are provided as date and time literals?

994

---

How to specify the collation for a character data type in ms sql server?

1007

---

What is the purpose of forms?

936

---

How to create new databases with "create database" statements?

999

---