Skip to content

Instantly share code, notes, and snippets.

@mvillegascuellar

mvillegascuellar/set_select_multivalor.sql Secret

Created August 7, 2018 19:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mvillegascuellar/d44570b8e394488099c9ee0a5e57e763 to your computer and use it in GitHub Desktop.
Save mvillegascuellar/d44570b8e394488099c9ee0a5e57e763 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
set_select_multivalor.sql
DECLARE @v int
SET @v = (SELECT database_id FROM sys.databases ORDER BY database_id DESC) -- dara error
PRINT @v
GO
DECLARE @v int
SELECT @v = database_id FROM sys.databases ORDER BY database_id -- asignara el maximo database_id
PRINT @v
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment