Answer Posted / rajesh ranjan

select cast(getdate() as varchar)

select convert(varchar,getdate(),101)-mm/dd/yyyy
select convert(varchar,getdate(),102)-yy.mm.dd
select convert(varchar,getdate(),106)-ddmmyy
select convert(varchar,getdate(),108)-hh:mm:ss

etc.

What is transaction server consistency?

1022

---

What is buffer cash in sql server?

1138

---

What are pages and extents? : SQL Server Architecture

1002

---

How to recompile stored procedure at run time?

1054

---

What are the limitations/drawbacks or ssrs 2008 r2?

139

---

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

999

---

If no size is defined while creating the database, what size will the database have?

968

---

How you can move data or databases between servers and databases in sql server?

1031

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

945

---

How can we check the sql server version?

1033

---

What is the difference between a clustered index and a non-clustered index?

976

---

Which language is supported by sql server?

995

---

What is a unique index?

920

---

What are sp_configure commands and set commands?

1003

---

Introduction of rollup clause using sum and group by clause?

938

---