select getdate()

How get current date in SQL server 2000

Question Posted / shyamsri83

Answer Posted / shyamsri83

select getdate()

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is sql server english query?

1105

What is factless fact table? : sql server analysis services, ssas

1092

Can you explain what are various ways to enhance the ssrs report?

1066

How to generate create table script on an existing table in ms sql server?

1189

What is the difference between DATETIME2 and DATETIME?

1124

What is NOT NULL Constraint in sql server 2012?

1043

What are the different types of subquery?

1198

Which autogrowth database setting is good?

1091

What is a functions and types in sql server?

1141

Define full outer join?

1006

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

1055

What is the difference between for auto and for nested?

1060

What is t-sql script to take database offline – take database online.

1129

Do you know what are the ways available in sql server to execute sql statements?

1079

Explain the concepts and capabilities of sql server?

1007