Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / koppalahareesh
declare @y int;
set @y = 2016;
SELECT DATEDIFF(day,cast(@y as char(4)), cast(@y+1 as char(4))) Days
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows in ms sql server?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is spid in sql server profiler?
How to perform backup for certificates in sql server? : sql server security
What is an identity column in insert statements?
What is unique key constraint?
How would you choose between a clustered and a non-clustered index?
Differentiate between a having clause and a where clause.
What is importing utility?
What is lock escalation and what is its purpose?
What are the different types of backups avaialabe in sql server 2005?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is PROJECTION Operation?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is scalar user-defined function?
