how to using sql generate sql statements? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to using sql generate sql statements?

how to using sql generate sql statements?# Database - 数据库

e*e2004-04-23 07:04

1 楼

for example, i would like to generate insert and update statements for all
the tables in my db1 database. Need these scripts in other code.
Thanks.
Will do it in Toad. it's a vely basic & simple question.
any reply will be appreciated!

c*t2004-04-23 07:04

2 楼

declare @sql varchar(1000)
set @sql='select * from TBALE'
execute @sql

for example, i would like to generate insert and update statements for all
the tables in my db1 database. Need these scripts in other code.
Thanks.
Will do it in Toad. it's a vely basic & simple question.
any reply will be appreciated!

【在 e****e 的大作中提到】

: for example, i would like to generate insert and update statements for all
: the tables in my db1 database. Need these scripts in other code.
: Thanks.
: Will do it in Toad. it's a vely basic & simple question.
: any reply will be appreciated!

e*e2004-04-23 07:04

3 楼

no.....
偶的意思是：
先举个例子：
select 'select count(*) from ' || table_name ||
';' || from user_tables;
结果偶就可以得到查所有表的记录数的sql语句
偶现在想要这样的一句来得到对所有表的insert语句
包含各个表的列名最好
产生的结果偶要在其他地方用
希望这回说明白了
谢谢

【在 c**t 的大作中提到】

: declare @sql varchar(1000)
: set @sql='select * from TBALE'
: execute @sql
:
: for example, i would like to generate insert and update statements for all
: the tables in my db1 database. Need these scripts in other code.
: Thanks.
: Will do it in Toad. it's a vely basic & simple question.
: any reply will be appreciated!