Dynamic Stored Procedure

• ns22boss

  Mr or Mrs. 500

  Points: 563

  More actions

  December 26, 2011 at 4:54 am

  #146276

  Hi all,

  How to create "Dynamic" stored procedure in SQL Server Management studio express??

  pls help me on this

  thanks

  sathish

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 26, 2011 at 7:36 am

  #1425494

  Using sp_executesql

  http://msdn.microsoft.com/en-us/library/ms175170.aspx

  sp_executesql (Transact-SQL)

  http://msdn.microsoft.com/en-us/library/ms188001.aspx