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 process of normalising?

1042

What is trigger and different types of Triggers?

1196

What is a non equi join?

1018

What are the security related catalog views? : sql server security

988

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1121

Explain activity monitors

1127

How can a database be repaired?

1030

what are user defined datatypes and when you should go for them? : Sql server database administration

1059

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

158

What are the advantages of user defined function?

1038

In which tcp/ip port does sql server run? Can it be changed?

1033

What is Federation and Federation Member?

Do you know how to implement service broker?

965

How much is a sql server license?

1004

What is a View ? Can we insert, Update and delete a view?

1053