Forum Discussion
Data Warehouse - SQL Database Projects Issues + 'ALTER TABLE' are not supported in Fabric
Got it!
Related to the batch issue... Within the "SQL Database Project" I wrote some code to load data into a table... some thing like:
DECLARE dt DATETIME2(6) = getutcdate()
INSERT INTO [Code].[StatuteTitleCode] (CodeID, Description, UpdatedDate) VALUES
('AB', 'Alcoholic Breverages', dt)
GO
The previous runs as expected within its script when executed by hand, but in dacpac it states that statements must be followed by a "GO". And there is no point on putting a GO after the DECLARE since I will loose the variable. This case is a no brainer since I can just put the date directly on the values... still it will be nice that a batch could be more than just one sentence.
Your thoughts...
- Anonymous2 years agoNot applicable
Hi esobrino
Is this behavior specific to DW or is it across SQL projects? and is this script a post deployment script?