DECLARE @ConnStr varchar(200)
SET @ConnStr='OPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.22;User ID=sa ;password=sa')'提示 'SQLOLEDB' 附近有语法错误。
SET @ConnStr='OPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.22;User ID=sa ;password=sa')'提示 'SQLOLEDB' 附近有语法错误。
SET @ConnStr='OPENDATASOURCE(''SQLOLEDB'',''Data Source=192.168.1.22;User ID=sa ;password=sa'')'
SET @ConnStr='OPENDATASOURCE(''SQLOLEDB'',''Data Source=192.168.1.22;User ID=sa ;password=sa'')'
SET @ConnStr='OPENDATASOURCE(''SQLOLEDB'',''Data Source=192.168.1.22;User ID=sa ;password=sa'')'
print @ConnstrOPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.22;User ID=sa ;password=sa')
SET @ConnStr='OPENDATASOURCE('+char(39)+'SQLOLEDB+char(39)+','+char(39)+'Data Source=192.168.1.22;User ID=sa ;password=sa'+char(39)+')'
SET @ConnStr='OPENDATASOURCE(''SQLOLEDB'',''Data Source=192.168.1.22;User ID=sa ;password=sa'')'