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

Which TCP/IP port does SQL Server run on?

2 Answers  


Data table as parameter in sql server?

0 Answers  


What are the different types of triggers in SQL SERVER?

0 Answers  


what is sql injection?

2 Answers  


Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,






What is exclusive locks?

0 Answers  


What are the different normalization forms?

0 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  


Can we take the full database backup in log shipping?

0 Answers  


Can I save my report as html, excel or word? : sql server management studio

0 Answers  


what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  


Categories