0 - 4 of 4 tags for variables
When does the value in a stored procedure variable change?

Hi -
Can someone help me understand if the values in the variable change when the values in the source changes?
 
Sample Tbl1 Data:
Fld1
1
 
Sample Tbl2 Data:
Fld1     Fld_X
1         ABC
2         XYZ
 
To explain it better, here is the sample SQL:
SELECT Fld1

By JoyC, 29 Sep 2015 | Tagged: variables stored procedure variables | 3 comments
Variables in TD?

Hi,
I am a TD newcomer and still figuring out details. 
I came across below piece of code that caught my attention.

By Nikhil_Teradata, 09 Jun 2015 | Tagged: sql variables | 2 comments
New to Teradata from T-SQL

Good Morning All,
I've just changed roles. I've got about 4 years experience with MS SQL Server (T-SQL) and my new role uses Teradata.

By bree_l, 11 Aug 2014 | Tagged: TSQL DECLARE DateDiff date REFERENCE variables | 1 comment
Global and session level parameters in SQL

The commonly known technique to pass parameters to SQL statements at the system or session level utilizes tables (permanent or global temporary tables).
In this blog post, I'll show better performing techniques for system and user level variables using views and QueryBanding.
These solutions are based on TD13, but can also be used pre-TD13, although performance might be worse.

By dnoeth, 14 Mar 2011 | Tagged: views scalar subqueries parameters variables querybanding | 44 comments