Viewing 2 posts - 1 through 2 (of 2 total)
you can do the following
BEGIN
Declare @var1 nchar(200),
@var2 nchar(300)
set @var1 = 'table name'
set @var2 = 'Select * from ' + @var1 + "where where_cond"
EXECUTE...
July 19, 2004 at 4:22 am
#515044
If your problem is trying to delete one of two identical rows, do the following:
SET ROWCOUNT 1
DELETE FROM table_name
WHERE condition1,condtion2,....
April 8, 2004 at 1:01 am
#502083