SQL Studio

DECLARE
DECLARE variablename variabletype [= expression]
Supported Data Types
  • string, varchar, nvarchar
  • int
  • decimal
  • bigint
  • guid, uniqueidentifier
  • datetime
  • bit, bool, boolean
Examples
declare @variable int
declare @variable string='test'