How can we help you today? How can we help you today?
Nitin1904
Activity overview Badges (0) Posts (0) Comments (1)

Comments

Sort by recent activity
Getting an error while using the AT TIME ZONE function, the SQL change Automation not supporting this function and i have to convert the query in dynamic one to make it workable.  Here is the version detail i am using. SQL Change Automation Version : 4.3.20211.21565 Visual Studio : 2019 SQL Server : 2017 Error : SQL80001 Incorrect syntex near 'AT TIME ZONE' sample statement  : SELECT [TimeStamp] AT TIME ZONE 'UTC' AS UTC_Time FROM TableA / comments
  1. Community
  2. SQL Source Control
  3. Invalid Sql error - SQL Server "AT TIME ZONE" function
Getting an error while using the AT TIME ZONE function, the SQL change Automation not supporting this function and i have to convert the query in dynamic one to make it workable. Here is the versio...
0 votes
Total activity
2
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1