select convert(varchar,getdate(),105)

How get current date in SQL server 2000

Question Posted / rajkumar v

Answer Posted / rajkumar v

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a coalesce function?

1130

What is difference between clustered index and non clustered index?

1028

What is cursor in ms sql server?

1090

What is page in sql server?

898

Explain the cursor lock types?

982

What do you mean by authentication modes in sql server?

1028

What is clustered index

951

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

956

How to backup SQL Server Reporting Services ?

137

What is normalization and what are the advantages of it?

921

What are the types of table?

919

How to drop an existing schema in ms sql server?

1023

How to bind a view to the schema of the underlying tables?

946

Can two tables have the same primary key?

1133

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1059