insert into 和 where not exists-白红宇

insert into 和 where not exists

阅读量：5283 次

发布时间：2019-06-14

本文共 896 字，大约阅读时间需要 2 分钟。

错误的语法

INSERT INTO [dbo].[geo_asso_type]([geo_asso_type_id],[bound_asso_type],[updated_date])VALUES(11,'Province to City',GETDATE()WHERE NOT EXISTS(SELECT 1 FROM [dbo].[geo_asso_type] WHERE [geo_asso_type_id] = 11)

方案1，前置not exists

IF NOT EXISTS (SELECT 1 FROM [dbo].[geo_asso_type] WHERE [geo_asso_type_id] = 11)  BEGIN     INSERT INTO [dbo].[geo_asso_type]           ([geo_asso_type_id]          ,[bound_asso_type]          ,[updated_date])      VALUES         (11          ,'Province to City'         ,GETDATE())   END

方案2，通过select的方式插入数据

INSERT INTO [dbo].[geo_asso_type]         (     [geo_asso_type_id],        [bound_asso_type],     [updated_date]     )        SELECT         11,          'Province to City',          GETDATE()     WHERE NOT EXISTS(         SELECT 1       FROM [dbo].[geo_asso_type]       WHERE [geo_asso_type_id] = 11  )

转载于:https://www.cnblogs.com/chucklu/p/10482311.html

你可能感兴趣的文章

hdu 2807 The Shortest Path 矩阵

查看>>

熟悉项目需求，要知道产品增删修改了哪些内容，才会更快更准确的在该项目入手。...