Error in SQL Server 2005 with passing a variable
In T-SQL code on SQL Server 2005, the variable :t_id is being passed from other pages and works in other statements, but it is not parsing within this statement: define(“TF_T_INFO_INSERET”, ” insert into TFT (WG_ID,task_id,tf_id) SELECT (select WGID from LU_T where TID= :t_id ), :t_id , (select max(TF_ID) from LU_TF); “); If I replace :t_id [...]

Answer Question   |  December 12, 2008  4:23 PM
SQL Server 2005, SQL Server errors, SQL Server Variables, T-SQL

insert into with select and passing variables
This is driving me NUTZ —- SQL Server 2005 and PHP the variable :t_id is being passed from other pages and works in other statements, but is not parsing within this statement. If I replace :t_id with say 30, it works just fine. I tried declaring a new variable and passing it to the statement, [...]

Answer Question   |  December 11, 2008  2:21 PM
PHP, SQL Server 2005, SQL Server errors, SQL Server Variables