从一个表到另一个表的插入数据的SQL子查询 [英] SQL SUB QUERY FOR INSERT DATA FROM ONE TABLE TO ANOTHER

问题描述

我只是试图将数据从一个表插入到onother.但是它给我你不能插入NULL值，因为它是一个NOT NULL字段.当我添加IS NOT NULL结时，但是仍然会出现相同的错误. />

查询:

HI i just tried to insert data from one table to onother.but it gives me you cannot insert NULL values since it is a NOT NULL feild.THEN i add IS NOT NULL junction.but still gives the same error.


QUERY :

INSERT INTO [AntronERP_DB].[dbo].[tblCountry](countryCode,countryName,secCode,stdCountryCode)
(SELECT [CountryCode],[CountryName],[Sector],[CountryCode]  FROM [ANTRONMASTERDB].[dbo].[CountryMaster]
WHERE  Sector  IS NOT NULL AND CountryCode <> 'UK' OR CountryCode <> 'LK' OR CountryCode <> 'US' )

错误代码:

ERROR CODE :

Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'secCode', table 'AntronERP_DB.dbo.tblCountry'; column does not allow nulls. INSERT fails.
The statement has been terminated.

谢谢！

ANybody help me on this issue.Thanks!

推荐答案

这意味着 secCode 列具有set属性allow null = false
修改表并勾选刻度线 允许Null 选项，然后尝试...

祝您编码愉快！
:)

this means secCode column has set property allow null = false
modify table and tick mark allow Null option then try...

Happy Coding!
:)

尝试以下操作(在countrycode子句周围添加括号):

Try the following (added parenthesis around the countrycode clause):

INSERT INTO [AntronERP_DB].[dbo].[tblCountry](countryCode,countryName,secCode,stdCountryCode)
(SELECT [CountryCode],[CountryName],[Sector],[CountryCode]  FROM [ANTRONMASTERDB].[dbo].[CountryMaster]
WHERE  Sector  IS NOT NULL AND (CountryCode <> 'UK' OR CountryCode <> 'LK' OR CountryCode <> 'US') )

这篇关于从一个表到另一个表的插入数据的SQL子查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！