T-SQL: How to use parameters in dynamic SQL?

by

You must pass in the parameters to sp_executesql. See MSDN for details.

...
 WHERE 
    CreatedBy = @p
...

EXECUTE sp_executesql @sql, N'@p UNIQUEIDENTIFIER', @p = @p_CreatedBY

More Related Contents:

  1. Getting result of dynamic SQL into a variable for sql-server
  2. Dynamic SQL to generate column names?
  3. Select distinct record from table and perform Sum of column (Pallats, Gross) of a duplicate row. And show that duplicate rows once [closed]
  4. How do I split a string so I can access item x?
  5. When should I use CROSS APPLY over INNER JOIN?
  6. get a comma delimited string from rows [duplicate]
  7. Find all tables containing column with specified name – MS SQL Server
  8. SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, =
  9. How important is the order of columns in indexes?
  10. How to split a single column values to multiple column values?
  11. Why no windowed functions in where clauses?
  12. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  13. T-SQL Cast versus Convert
  14. When no ‘Order by’ is specified, what order does a query choose for your record set?
  15. What is a stored procedure?
  16. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  17. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  18. Partition Function COUNT() OVER possible using DISTINCT
  19. How do I create a foreign key in SQL Server?
  20. How do I group on continuous ranges
  21. join comma delimited data column
  22. Need to list all triggers in SQL Server database with table name and table’s schema
  23. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  24. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  25. Alter user defined type in SQL Server
  26. Best equivalent for IsInteger in SQL Server
  27. Drop all tables whose names begin with a certain string
  28. T-SQL Skip Take Stored Procedure
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment