Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.*
- FROM OPENROWSET('SQLNCLI11', 'SERVER=sqlserver.database.windows.net,1433;DATABASE=testDB;Uid=admin;Pwd=Fj'C(D=JJ&'XE6vx};','select * from table1 with (nolock)')a
- declare @string varchar(max)
- set @string=
- 'SELECT a.*
- FROM OPENROWSET(''SQLNCLI11'', ''SERVER=sqlserver.database.windows.net,1433;DATABASE=testDB;Uid=admin;Pwd="Fj'''+'C(D=JJ&'''+'XE6vx}";'',''select count(*) from dbo.table1 with (nolock)'')a'
- exec (@string)
- declare @string varchar(max)
- declare @pwd varchar(max)
- set @pwd = 'Fj'''+'C(D=JJ&'''+'XE6vx}'
- set @string=
- 'SELECT a.*
- FROM OPENROWSET(''SQLNCLI11'', ''SERVER=sqlserver.database.windows.net,1433;DATABASE=testDB;Uid=admin;Pwd='+@pwd+';'',''select count(*) from dbo.table1 with (nolock)'')a'
- exec (@string)
Add Comment
Please, Sign In to add comment