Forum Discussion
Data Warehouse - SQL Database Projects Issues + 'ALTER TABLE' are not supported in Fabric
Here are some little issues: • Selecting a Profile always revert to an “SQL Login” Authentication type … “Microsoft Entra ID – Universal with MFA support” is expected. • A batch should not only ...
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...
