I have been migrating MySQL SP to SQL Server. 
MySQL has [prepare statement](http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html), Which supports assigning comples SQL query as string and executing it later.

```
SET @msquery="select * from tblEmployee" <<More complex queries here>>
    PREPARE stmt3 FROM @msquery;
          EXECUTE stmt3;
          DEALLOCATE PREPARE stmt3;

```

Do we have an equivalent in SQL server?