OpendataSource

Question

(select @@servername from OPENDATASOURCE('SQLNCLI', 'Data Source=Servername ;Integrated Security=SSPI') .DBNAME.dbo.BSC )

For the above query i need to parameterised the 'Data Source=Servername .

How it can be done .

Answer 1

0

You can use dynamic sql for that

DECLARE @ServerName NVARCHAR(500)

SET @ServerName = N'ServerName'

EXEC ('select TOP 1 @@servername from OPENDATASOURCE(''SQLNCLI'', ''Data Source='+ @ServerName + ' ;Integrated Security=SSPI'').master.dbo.spt_values')

answered May 17 '12 at 09:07 AM

robbin
1.6k ● 1 ● 3 ● 5

(comments are locked)

OpendataSource

Follow this question

Related Questions