我正在尝试对我们的数据库进行一些升级维护。我需要将一个表的所有行中的3列数据移动到一个新表中,并将这些数据插入为新行。
INSERT INTO [dbo].[SnmpSettings]([NetworkDiscoveryId], [RoCommunities], [RwCommunities])
SELECT id, Ro_Community, RW_Communities
FROM [dbo].[Network_Discovery]
上述代码可以正常工作,但Ro_Community和RW_Communities允许NULL,而RoCommunities和RwCommunities不允许NULL。我该如何将NULL转换为空字符串,然后插入到我的新表中?
编辑:
INSERT INTO [dbo].[SnmpSettings]([NetworkDiscoveryId], [RoCommunities], [RwCommunities])
SELECT id, Ro_Community, RW_Communities
ISNULL(Ro_Community,'')
FROM [dbo].[Network_Discovery]
Msg 102, Level 15, State 1, Line 27
Incorrect syntax near 'Ro_Community'.
SELECT id, isnull(Ro_Community, ''), isnull(RW_Communities, '')
- Nikola Markovinović