DotNetShoutout - Why we should not use cast, convert and Year() function on datetime column in where clause?

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

10
Shouts

Shout it

Why we should not use cast, convert and Year() function on datetime column in where clause?

published 1013 days, 6 hours, 42 minutes ago posted by

dhara 1016 days, 15 hours, 9 minutes ago

This post is inspired by a discussion at MSDN forums, which is about the Performance effect of Cast,Convert and Year() functions on Datetime columns in where clause.

category: Data | clicked: 0 | | source: beyondrelational.com | show counter code

tags: SQL Server, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout