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 the difference between DATETIME2 and DATETIME?

1080

What is clustered primary key?

1028

What do you understand by triggers?

922

What the difference between UNION and UNIONALL?

1040

Explain about link server in sql server?

1061

What is key set driven?

958

Can group functions be mixed with non-group selection fields in ms sql server?

944

Explain how to integrate the ssrs reports in application?

1017

How can we get count of the number of records in a table?

954

Why use “in” clause in sql server?

1071

Can you always create a cache of a report?

172

What is a self join in sql server?

1136

What are character string data types in ms sql server?

1253

What is the purpose of optimization?

998

What is logshipping and its purpose?

990