Posts
Sort by recent activity
Prompt Failure w/MERGE statements
<Extract>
MERGE Wine.Producer AS CurrentData
USING
(
SELECT DISTINCT ProducerID, ProducerName
FROM Wine.Import
) AS NewData
ON CurrentData.ProducerID = NewData.ProducerID
WHEN MATCHED THEN
UPDATE
...
Suggest List Does Not Show Newly Created Tables
This is just an example:
CREATE TABLE [Wine].[WineList]
(
[WineID] INT IDENTITY(1, 1) NOT NULL ,
[WineName] NVARCHAR(128) NOT NULL,
[RegionID] INT
)
GO
CREATE UNIQUE INDEX Wine_WineList_WineName ON...