EXEC master..xp_cmdshell 'bcp "select d.name,a.name ,b.name ,a.length, a.isnullable from 库名..syscolumns a,库名..systypes b,库名..sysobjects d where a.xtype=b.xusertype and a.id=d.id and d.xtype='U' and d.name='表名'" queryout E:\boc\DT.txt -c -Sservername -Usa -Ppassword'
EXEC master..xp_cmdshell 'bcp "select d.name,a.name ,b.name ,a.length, a.isnullable from 库名..syscolumns a,库名..systypes b,库名..sysobjects d where a.xtype=b.xusertype and a.id=d.id and and d.name=''表名''" queryout E:\boc\DT.txt -c -Sservername -Usa -Ppassword'
你好,
在管理面板中,右击你的数据库,在弹出菜单中
选所有任务,里面有个[生成SQL脚本]就是了~
按照: i(☆) 的办法,你怎么玩都可以