SQL Complete (2.50.86) Working with Table Variables
Posted: Thu 07 Apr 2011 00:18
SQL Prompt does not appear to work well with table variables. For example, formaiting the folllowing:
Results in:
In addition, typing "t." after SELECT does not bring up a list of the columns in the @temp1 table.
Code: Select all
CREATE PROCEDURE dbo.Test1 ( @param1 INT
, @param2 INT )
AS
BEGIN
DECLARE @temp1 TABLE ( col1 INT
, col2 INT
, col3 INT
, col4 INT )
SELECT *
FROM @temp1 AS t
WHERE t1.col1 = @param1
AND t1.col2 = @parm2
END
GO
Code: Select all
CREATE PROCEDURE dbo.Test1(@param1 INT,
@param2 INT)
AS
BEGIN
DECLARE @temp1 TABLE(
col1 INT
,
col2 INT
,
col3 INT
,
col4 INT
)
SELECT *
FROM @temp1 AS t
WHERE t1.col1 = @param1
AND t1.col2 = @parm2
END
GO