Answer Posted / samba shiva reddy . m

SELECT
GETDATE() AS UnconvertedDateTime,
CAST(GETDATE() AS nvarchar(30)) AS UsingCast,
CONVERT(nvarchar(30), GETDATE(), 126) AS UsingConvertTo_ISO8601 ;
GO
this will work for u try it out.

Explain a checkpoint?

975

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1909

---

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

910

---

What is server-level principal?

120

---

Write query to return all rows sql?

1004

---

How to transfer an existing table from one schema to another schema in ms sql server?

925

---

Explain system views?

1021

---

What is a database in ms sql server?

992

---

What Are the Main Features of SQL Azure?

115

---

What is the purpose of the master database?

1052

---

What is a fan-out query in SQL Azure?

121

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1032

---

Can you get second highest salary from the table?

911

---

Explain the different types of backups available in sql server? : sql server database administration

863

---

Which is better statement or preparedstatement?

869

---