468,316 Members | 2,062 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

how can we convert prepare satament of mysql into mssql

i want to convert this mysql code into mssql.

SET strSTMTDEFINATION = Concat(SUBSTRING(strSTMTDEFINATION,1,LENGTH(strSTM TDEFINATION) -1),");");



SET @myCREATE := strSTMTDEFINATION;
PREPARE stmt FROM @myCREATE;
EXECUTE stmt;
Nov 19 '08 #1
2 2442
ck9663
2,878 Expert 2GB
Just use EXEC (@statement_variable) directly. You don't need to prepare the statement, but you have to build the dynamic query string.


-- CK
Nov 19 '08 #2
Just use EXEC (@statement_variable) directly. You don't need to prepare the statement, but you have to build the dynamic query string.


-- CK
its working fine . thanks for ur guideline.
Nov 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Randy Rodent | last post: by
3 posts views Thread by howachen | last post: by
5 posts views Thread by M. Savas Zorlu | last post: by
reply views Thread by exclaim | last post: by
reply views Thread by Gosth in the shell | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.