Getting result of dynamic SQL into a variable for sql-server

by 
DECLARE @sqlCommand NVARCHAR(1000)
DECLARE @count INT
DECLARE @city VARCHAR(75)
SET @city = 'New York'

SET @sqlCommand = 'SELECT @cnt=COUNT(*) FROM customers WHERE City = @city'
EXECUTE sp_executesql @sqlCommand, N'@city nvarchar(75), @cnt int OUTPUT', @city = @city, @cnt = @count OUTPUT

SELECT @count

More Related Contents:

  1. Dynamic SQL to generate column names?
  2. Is it possible to write single query on two table which are not connected to each other?
  3. Get top 1 row of each group
  4. SQL update query using joins
  5. How to update two tables in one statement in SQL Server 2005?
  6. Referring to a Column Alias in a WHERE Clause
  7. SQL query to select dates between two dates
  8. Convert Month Number to Month Name Function in SQL
  9. Create a date from day month and year with T-SQL
  10. SET versus SELECT when assigning variables?
  11. Selecting COUNT(*) with DISTINCT
  12. Generate a resultset of incrementing dates in TSQL
  13. How to get difference between two rows for a column field?
  14. Better techniques for trimming leading zeros in SQL Server?
  15. How to print VARCHAR(MAX) using Print Statement?
  16. What’s the best way to select the minimum value from several columns?
  17. Concatenate values based on ID
  18. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  19. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  20. Splitting delimited values in a SQL column into multiple rows
  21. varbinary to string on SQL Server
  22. SQL Server 2005 ROW_NUMBER() without ORDER BY
  23. Can an INNER JOIN offer better performance than EXISTS
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. Cumulative Total in MS Sql server [duplicate]
  26. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  27. Compare dates in T-SQL, ignoring the time part
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment