渡 渡鸦 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-23 #1 如何用一行SQL语句实现,直接将sqlserver2000中表的数据导入一个新的TXT文件; 不使用BCP实用程序,谢谢!!
渡 渡鸦 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-24 #3 我不想用程序去导库,只想用一句话或一个存储过程来实现功能,谢谢!!
竹 竹寨 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-25 #7 query.open query1.fisrt; while not query.eof do s:=''; begin for i:=0 to query1.fieldcount -1 do s:=s+','+query.fields.asstring; query.next ;
query.open query1.fisrt; while not query.eof do s:=''; begin for i:=0 to query1.fieldcount -1 do s:=s+','+query.fields.asstring; query.next ;
木 木子小虫 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-25 #10 informax 数据库有unload 语句,查查sql 的帮助 看是不是有类似的语句!!
雪 雪中漫步 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-25 #13 sqlserver2000有bcp啊: Northwind 数据库内有表 Jane's Orders,该表由用户 Jane Doe 所拥有。若要使用登录 Jane Doe 和密码 go dba 将该表从 Northwind 数据库大容量复制到 Orders.txt 文件,请执行下列命令之一: bcp "Northwind.Jane Doe.Jane's Orders" out "Jane's Orders.txt" -c -q -U"Jane Doe" -P"go dba" bcp "Northwind.[Jane Doe].[Jane's Orders]" out "Jane's Orders.txt" -c -U"Jane Doe" -P"go dba"
sqlserver2000有bcp啊: Northwind 数据库内有表 Jane's Orders,该表由用户 Jane Doe 所拥有。若要使用登录 Jane Doe 和密码 go dba 将该表从 Northwind 数据库大容量复制到 Orders.txt 文件,请执行下列命令之一: bcp "Northwind.Jane Doe.Jane's Orders" out "Jane's Orders.txt" -c -q -U"Jane Doe" -P"go dba" bcp "Northwind.[Jane Doe].[Jane's Orders]" out "Jane's Orders.txt" -c -U"Jane Doe" -P"go dba"
渡 渡鸦 Unregistered / Unconfirmed GUEST, unregistred user! 2002-10-25 #14 再请教:如何用存储过程实现啊,我不想调用实用程序或dts, 更不想用程序实现,那样不便,不好意识,麻烦大家了!