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 the use of keyword with encryption. Create a store procedure with encryption?

1008

---

What language is sql server written in?

1081

---

what are user defined datatypes? : Sql server database administration

1015

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1005

---

What are sparse columns?

1066

---

How do you delete duplicate records in sql server?

1127

---

What is lock escalation? : sql server database administration

1198

---

Explain primary key?

1006

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1089

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2061

---

What is the maximum number of index per table?

1120

---

Explain Geometry datatype in sql server 2008 with example

1049

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2053

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1141

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1059

---