Ankitware is a platform where you get NIIT dumps fully solved!!!!! NIIT Lab At Home ;
NIIT Pmr ,NIIT cycle test, Window app.
Contact:ankitware@gmail.com.
Thursday 10 October 2013
2.Display EmployeeID and HireDate of the employees from the Employee table. The month and the year need to be displayed. (Use the AdventureWorks database)
select * from HumanResources.Employee select EmployeeID, MONTH=DATENAME(MM,HireDate),YEAR=DATENAME(YY,HireDate) from HumanResources.Employee
No comments:
Post a Comment