Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> .NET技术 >> C#

问大家一个关于SQL语句的问题(在线等,立即接贴)

我想把select出来的内容作为insert的参数，请问我该怎么写这个sql语句？
[47 byte] By [yblcgw-黑马之王] at [2008-2-16]
«« 配置数据库的问题
»» 求一个JTree的简单例子
# 1
select *(or column names)
from ..
into..
yanransoft at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 2
select * from XXX into...
cdo-Everythinghasafavourableturn at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 3
Insert Into Table1 (...) Select ... From Table2
triout-笨牛 at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 4
select 'insert into tablename (ID,name,birthday) values( ' +
convert(nvarchar(20),ID) + ',"' + name + '","' + birthday + '")'

差不多是这个样子，试试吧!
buggavin-逸飞 at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 5
select 'insert into tablename (ID,name,birthday) values( ' +
convert(nvarchar(20),ID) + ',"' + name + '","' + birthday + '")'
from tablename

不好意思刚才差了半句!
buggavin-逸飞 at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 6
Insert Into Table1 (...) Select ... From Table2

luotitan-泰坦 at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 7
luotitan(泰坦) 的做法
现在能支持嵌套吗？
fischsuppe-fischsuppe at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 8
select into (不是很简单吗）
laidycn-禅意生活 at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
# 9
Insert Into Table1 (...) Select ... From Table2
777kit-型死 at 2007-10-22 > top of Msdn China Tech,.NET技术,C#...
.NET技术
C#

.NET技术 Hot Topic

.NET技术 New Topic

.NET技术

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified