SQL Server SELECT INTO @variable?

by

If you wanted to simply assign some variables for later use, you can do them in one shot with something along these lines:

declare @var1 int,@var2 int,@var3 int;

select 
    @var1 = field1,
    @var2 = field2,
    @var3 = field3
from
    table
where
    condition

If that’s the type of thing you’re after

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. T-SQL split string
  3. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  4. Unpivot with column name
  5. How can I get column names from a table in SQL Server?
  6. Conditional WHERE clause in SQL Server
  7. How can I select the first day of a month in SQL?
  8. Split function equivalent in T-SQL?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. Multi-statement Table Valued Function vs Inline Table Valued Function
  11. Convert varchar into datetime in SQL Server
  12. Select statement to find duplicates on certain fields
  13. Check if a row exists, otherwise insert
  14. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  15. Parse comma-separated string to make IN List of strings in the Where clause
  16. SQL query to split column data into rows
  17. Compare DATETIME and DATE ignoring time portion
  18. Split function in SQL Server 2008
  19. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  20. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  21. SQL “between” not inclusive
  22. TransactSQL to run another TransactSQL script
  23. Using PIVOT in SQL Server 2008
  24. Store multiple bit values in a single table column
  25. Which SQL query is faster? Filter on Join criteria or Where clause?
  26. SQL Server equivalent to MySQL enum data type?
  27. How can I group by date time column without taking time into consideration
  28. Using IF ELSE statement based on Count to execute different Insert statements
  29. Cumulative Total in MS Sql server [duplicate]
  30. COALESCE Function in TSQL

Leave a Comment