What is difference between Datepart() and Datename() in SqlServer?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Write a SQL query to delete a table?

0 Answers   Amdocs,


What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,


Magic Tables ?

2 Answers   Thomson Reuters,


What is the difference between having clause and where clause in sql server?

0 Answers  


i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  






What is difference between temp table and cte?

0 Answers  


What are views in ms sql server?

0 Answers  


What is a join and their types?

2 Answers   Challenger Financial,


Why the trigger fires multiple times in single login?

0 Answers  


Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  


What factors you will consider calculating the storage requirement for that view?

0 Answers  


What do you understand by triggers?

0 Answers  


Categories