FROM sysobjects o, sp_datatype_info d, systypes t, syscolumns c --- FROM sysobjects o, (select * from OPENROWSET('SQLOLEDB','SERVER=.;UID=sa;PWD=','exec dbname.dbo.sp_datatype_info')) as d, systypes t, syscolumns c 注意 修改: 'SQLOLEDB','SERVER=.;UID=sa;PWD=','exec dbname.dbo.sp_datatype_info')) 中的server= . 及dbname.
exec sp_datatype_infoselect * from #t以后用#t代替 exec sp_datatype_info
sysobjects o,
sp_datatype_info d,
systypes t,
syscolumns c
---
FROM
sysobjects o,
(select *
from OPENROWSET('SQLOLEDB','SERVER=.;UID=sa;PWD=','exec dbname.dbo.sp_datatype_info')) as d,
systypes t,
syscolumns c 注意 修改:
'SQLOLEDB','SERVER=.;UID=sa;PWD=','exec dbname.dbo.sp_datatype_info')) 中的server= . 及dbname.