'A' 附近有语法错误 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 TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 那我要把这行数据插入到另一个表那改怎么做呢?
select'A' 附近有语法错误 SELECT TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 那我要把这行数据插入到另一个表那改怎么做呢? INSERT INTO 插入表 SELECT TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 插入表中要包含 a 、b 、c 列的
'A' 附近有语法错误 SELECT TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 那我要把这行数据插入到另一个表那改怎么做呢? INSERT INTO 插入表 SELECT TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 插入表中要包含 a 、b 、c 列的 那更新呢?
'A' 附近有语法错误 SELECT TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 那我要把这行数据插入到另一个表那改怎么做呢? INSERT INTO 插入表 SELECT TOP 1 a , b , c FROM dbo.a WHERE a = 'XX' 插入表中要包含 a 、b 、c 列的 那更新呢? 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 * from (select 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
SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
那我要把这行数据插入到另一个表那改怎么做呢?
SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
那我要把这行数据插入到另一个表那改怎么做呢?
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'
那我要把这行数据插入到另一个表那改怎么做呢?
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'
那我要把这行数据插入到另一个表那改怎么做呢?
INSERT INTO 插入表 SELECT TOP 1
a ,
b ,
c
FROM dbo.a
WHERE a = 'XX'
插入表中要包含 a 、b 、c 列的
那更新呢?
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 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