Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddy_vam
Starting Member
43 Posts |
 Posted - 2008-12-18 : 14:57:11
|
| Hi,I am using the below query in my stored procedure, but i am getting error message while executing that, saying Incorrect syntax near '@server'Below is my select statementselect NEXTVAL from openquery(@server,'select Table1_SEQ.NEXTVAL from dual')Please let me know if any one have idea on it.Thanks,Reddy |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-12-19 : 08:55:08
|
| Shouldn't you have the name of the linked_server inplace of the variable (@server) over there ?? Or else, use dynamic sql. |
 |
|
|
|
|
|
Pass paramenters in Open Query