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.

Can a rule be bound to any column of any data type?

963

---

how to take backup bcp out for a column in table in sql server?

2105

---

What is dimension table? : sql server analysis services, ssas

1020

---

Do you know how to send email from database?

1005

---

What is view in sql?

906

---

Which is better statement or preparedstatement?

929

---

What is database black box testing?

1034

---

Explain where clause?

989

---

Why use “pivot” in sql server?

1119

---

What are clustered and non-clustered index?

1009

---

Tell me what is difference between clustered and non clustered index?

944

---

Is null vs coalesce?

885

---

How to change the ownership of a schema in ms sql server?

1194

---

Can we call stored procedure in trigger?

950

---

How to list all schemas in a database?

1061

---