how can we convert prepare satament of mysql into mssql

akbarmahrat

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;

ck9663

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

-- CK

akbarmahrat

Quote:

Originally Posted by ck9663

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.

how can we convert prepare satament of mysql into mssql

re: how can we convert prepare satament of mysql into mssql

re: how can we convert prepare satament of mysql into mssql

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about