Is it possible to reference a table variable's columns directly in an sproc? My code:
DECLARE @OldData TABLE
(ind_title VARCHAR(255) NOT NULL,
ind_bps_hms_id_other VARCHAR(50) NOT NULL,
ind_title_alternate TEXT NOT NULL,
ind_rationale TEXT NOT NULL,
ind_primary_reference TEXT NOT NULL)
-- Get old values currently in DB:
INSERT INTO @OldData
SELECT
ind_title,
ind_bps_hms_id_other,
ind_title_alternate,
ind_rationale,
ind_primary_reference
FROM Indicators
WHERE ind_pkey = @ind_pkey
-- It seems logical to be able to now reference the columns as @OldData.< some column >
-- but that doesn't seem to work.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
