| Operation | T-SQL | PL/SQL |
|---|---|---|
| Scope of variables | Variables visible only within batch or procedure. Batch is separated with keyword GO | |
| Declare variables | /* Variables get assigned default value of NULL. Must have @ as the first character. */ DECLARE @local varchar(30) DECLARE @another_local int = 10 | |
| Setting variables | SET @local = 'Test' SELECT @another_local = 5 SELECT @local = ID from [dbo].[Test] | |
| Display variable | SELECT @local PRINT @local |