i want to convet mysql code into the MS sql server.since there is no prepare keywordin mssql so plz help me to code equivalent code to this follwing code..

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



SET @myCREATE := strSTMTDEFINATION;
PREPARE stmt FROM @myCREATE;
EXECUTE stmt;

here @myCREATE is global variable.i do not found any prepare keyword.
so plz help me to convert this code for mssql.

---

Akbar Mahrat

You'll find that the sp_executeSQL procedure has both input and output variables, and will do what you want.
http://msdn.microsoft.com/en-us/library/ms188001.aspx