FAQ Database Discussion Community


Sql Server TVP Merge with Where/Case Statement

sql,sql-server,sql-server-2008,tvp
What I am doing is pretty straight forward dug around at a few posts and couldn't figure out how to express it properly TVP Declaration CREATE TYPE [dbo].[CustomSeoDic] as table ( [RecordID] [int] NULL, [Name] [nvarchar](125) NULL) GO Attempt 1 BEGIN MERGE INTO Listings L USING @CustomSeo AS Tvp ON...