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.

What is exporting and importing utility?

1056

---

What are the different subsets of sql?

1525

---

what purpose does the model database serve? : Sql server database administration

955

---

What are the indexes in sql server?

1095

---

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

1062

---

Explain what is scheduled job and how to create it?

939

---

What is ms sql server service broker?

967

---

How to create dbo table in sql server?

932

---

Explain how dts is used to extract, transform and consolidate data?

977

---

Do you know the policy based administration feature of sql server 2008?

935

---

What new data source types were added in ssrs 2014?

160

---

What is the Difference Between Primary and Foreign Key?

986

---

What is the contrast between sql and pl/sql?

1115

---

Why is sql server log file full?

1016

---

What is @@error in sql?

1044

---