Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice

June 10, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL DateTime, SQL Function, SQL Scripts, SQL Server

Just a week ago, my Database Team member asked me what is the best way to only select date part from datetime. When ran following command it also provide the time along with the date.

Read More

SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.

June 10, 2007
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Computer Network, SQL Error Messages
While reviewing my my blog search engine terms I find Error 40 is the most common error searched. I have previously wrote blog about how to fix this error here : SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server. Today I…
Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version