C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Dhyanchandh.A.V       Member Level: Gold       Posted Date: 06 Apr 2005       Category: SQL Server

What is the output of following Sql query ?


 


select datepart(yy,'2/2/50'),datepart(yy,'12/31/49'),datepart(yy,getdate())

Note : Current year is assumed as 2005
Select Answer:

2050 2049 2005
2050 1949 2005
1950 1940 2005
1950 1940 1995
1950 2049 2005



      
Your Test Score: 0 / 0



Next Question: What will be the output of following sql batch: begin tran update a1 set id=3 where id=1 begin tran insert into a1(id,name) values(5,'ABC') rollback tran rollback tran
Previous Question: Which one of the following is the correct SQL command to retrieve all of the data from an Excel worksheet named Invoices?
Related Questions:
  • Change Data Capture (CDC) allows you to track which operations?


  • Which of the following languages is used to define the schema of the database?


  • How to identify Errors in SQL Server?


  • Difference B/W CHARINDEX and PATINDEX in SQL Server ?


  • datetime


    		•

    Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    Contact Us    Privacy Policy    Terms Of Use