|
|
-
Raghunath Bhandari Commented 1 Years ago through Ask
Mithesh, My limitation is i can not change the setting in my remote server, I had already mentioned !...
|
-
Raghunath Bhandari Commented 1 Years ago through Ask
Hi Mithesh,
Read my previous reply, my sp return dynamic column so structure is not fixed, how can u suggest the table variable ?...
|
-
Raghunath Bhandari Commented 1 Years ago through Ask
Thanks Mithesh, for your valuable time.
In my case if I don't use SET FMTONLY OFF there will be no result, only structure return.
For your information I am calling the OPENROWSET Method because I want to store the Remote SP Result in my local Tab...
|
-
Raghunath Bhandari Question Asked 1 Years ago through ASK
Hi All,
I am trying to access my remote SQL Server with Openrowset like:
SELECT * FROM OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=192.168.0.1;UID=user;PWD=pass', 'SET FMTONLY OFF; Exec DB.dbo.Proc_TEST ''1'' ')
But the issue is "Proc_TEST" E...
|
ask
98
·
2% ·
538
|
|
-
Raghunath Bhandari Posted 1 Years ago through Ask
Hi All,
I am trying to access my remote SQL Server with Openrowset like:
SELECT * FROM OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=192.168.0.1;UID=user;PWD=pass', 'SET FMTONLY OFF; Exec DB.dbo.Proc_TEST ''1'' ')
But the issue is "Proc_TEST" Exec...
|
-
Raghunath Bhandari Question Asked 1 Years ago through ASK
Hi Jacob,
I am trying to access my remote SQL Server with Openrowset like:
SELECT *
FROM OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=192.168.0.1;UID=user;PWD=pass',
'SET FMTONLY OFF; Exec DB.dbo.Proc_TEST ''1'' ')
But the issue is "Proc_TES...
|
-
Raghunath Bhandari Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Raghunath Bhandari refreshed 1 Years ago through Blogs
People use Dynamic SQL for various purposes One of the disadvantages of it is SQL injection that can attack your database by doing the things that you didn't want to do Consider a case where usage of Dynamic SQL in unavoidable You have a table that reco...
|
-
Raghunath Bhandari Posted 1 Years ago through Blogs
Today my friend asked me that ISNUMERIC function is not working properly. I checked, the issue was with some special char, might be MSSQL will improve this functionality in coming versions. But if we change the way of calling i...
|
-
Raghunath Bhandari Posted 1 Years ago through Blogs
Today my friend asked me that ISNUMERIC function is not working properly. I checked, the issue was with some special char, might be MSSQL will improve this functionality in coming versions. For now, if we change the way of calling, it will show you the...
|