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
When columns are added to existing tables, what do they initially contain?
What is amo? : sql server analysis services, ssas
What is the command used to check locks in microsoft sql server?
How to create new tables with "select ... Into" statements in ms sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Write a sql query to display the current date?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What are system databases into sql server (2005/2008)?
How to create a view on an existing table in ms sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is scalar user-defined function?
What are parameterized reports?
How can you find out which stored procedures are recompiling?
Explain syntax for viewing trigger?
