How to return the date part only from a sql server datetime datatype?

Question Posted / nishi jain

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

More SQL Server Interview Questions

Why we use functions in sql server?

How to select some specific columns from a table in a query in ms sql server?

What is coalesce in sql server?

Do you know what is difference between index seek vs. Index scan?

Can we create nonclustered index in a table without creating a clustered index

Why should one not prefix user stored procedures with ‘sp_’?

What is the purpose of object explorer and its features? : sql server management studio

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

Describe triggers features and limitations?

What is the difference between primary key and unique constraints?

What is sql server english query?

Do you know the cursor types?

For more SQL Server Interview Questions Click Here