Sql

02/19/23

How to write an efficient query to compare data in a DATETIME column with a date from a different time zone?
In a table with large number of rows, if a DATETIME column (ModifiedDate) stores data with the UTC time zone, how do I efficiently query the rows with ModifiedDate after 1/1/2023 of pacific time zone? more
Follows • 1
Expert Answers •1
Sql

02/19/23

Will COALESCE() & ISNULL() always return the same result when 2 parameters are supplied?
If @s is of type VARCHAR(2) with NULL assigned to it, will COALESCE (@s, 'there') and ISNULL (@s, 'there') return the same result?
Follows • 1
Expert Answers •1

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.