Using the DATEDIFF function to select rows
I keep seeing people using CONVERT to convert a date to a varchar in order to do comparison or search queries. I haven't seen a situation yet where DATEDIFF can't be used.
2002-08-29
1,191 reads
Blogs
Daily Coping 10 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 9 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Refreshing a Power BI Dataset in Azure Data Factory
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Forums
Controlling Intelligent Query Processing Features
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features,...
To use the same function to pass table name as a parameter
I have this function, but I wanted to pass a table so as to...
Create SQL Login to View only one database on server
Hi All, I have one task to create a login, and user need to...
Ask SSC