34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
[/quote]
那我要把这行数据插入到另一个表那改怎么做呢?[/quote]
INSERT INTO 插入表 SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
插入表中要包含 a 、b 、c 列的[/quote]
那更新呢?[/quote]
DELETE 插入表 WHERE a='XX'
INSERT INTO 插入表 SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
或者
直接
update 插入表 set a=‘xx1’,b='XX1' where a='xx'SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
[/quote]
那我要把这行数据插入到另一个表那改怎么做呢?[/quote]
INSERT INTO 插入表 SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
插入表中要包含 a 、b 、c 列的[/quote]
那更新呢?SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
[/quote]
那我要把这行数据插入到另一个表那改怎么做呢?[/quote]
INSERT INTO 插入表 SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
插入表中要包含 a 、b 、c 列的SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
[/quote]
那我要把这行数据插入到另一个表那改怎么做呢?SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
(select top 1 a,b,c from dbo.a where a='XX' )A
SELECT * FROM (
SELECT a FROM a WHERE a = 'xxx' UNION ALL
SELECT b AS a FROM a WHERE a = 'xxx' UNION ALL
SELECT c AS a FROM a WHERE a = 'xxx' ) A