SELECT DATEDIFF(DD,HIREDATE,GETDATE())

How to get number of days in a given year?

Question Posted / sandhya

Answer Posted / sandhya

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1888

What are the limitations/drawbacks or ssrs 2008 r2?

139

What is BLOCK statements in SQL?

1263

how to avoid cursors? : Sql server database administration

969

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

986

What is the difference between composite index and covering index?

952

Explain about the command-line tool SQLCMD?

1088

Explain the functionalities that views support?

1114

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

985

Define outer join?

998

What is a transaction and why is it important?

1091

Are null values the same as that of zero or a blank space?

1040

Describe and explain about SQL native client?

1108

What is a trigger what are the advantages of trigger?

1000

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030