how can we convert prepare satament of mysql into mssql

[akbarmahrat]

i want to convert this mysql code into mssql.

SET strSTMTDEFINATI ON = Concat(SUBSTRIN G(strSTMTDEFINA TION,1,LENGTH(s trSTMTDEFINATIO N) -1),");");



SET @myCREATE := strSTMTDEFINATI ON;
PREPARE stmt FROM @myCREATE;
EXECUTE stmt;

[ck9663]

Just use EXEC (@statement_var iable) directly. You don't need to prepare the statement, but you have to build the dynamic query string.


-- CK

[akbarmahrat]

Just use EXEC (@statement_var iable) 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.