any mssql users out there have an opinion for or against this patch?
Why is it needed?
john mcnally
On Tue, 2002-04-16 at 14:39, Skip Walker wrote:
> cvs diff drop.vm (in directory
> C:\Temp\jakarta-cvs\jakarta-turbine-torque\src\templates\sql\base\mssql\)
> Index: drop.vm
> ===================================================================
> RCS file:
> /home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/mssql/drop.vm,
> v
> retrieving revision 1.2
> diff -r1.2 drop.vm
> 7c7
> < DECLARE @reftable nvarchar(60), @constraintname nvarchar(60)
> ---
> > DECLARE @reftable_${velocityCount} nvarchar(60),
> @constraintname_${velocityCount} nvarchar(60)
> 9c9
> < select reftables.name tablename, cons.name constraitname
> ---
> > select reftables.name tablename, cons.name constraintname
> 19c19
> < FETCH NEXT from refcursor into @reftable, @constraintname
> ---
> > FETCH NEXT from refcursor into @reftable_${velocityCount},
> @constraintname_${velocityCount}
> 22,23c22,23
> < exec ('alter table '+@reftable+' drop constraint '+@constraintname)
> < FETCH NEXT from refcursor into @reftable, @constraintname
> ---
> > exec ('alter table '+@reftable_${velocityCount}+' drop constraint
> '+@constraintname_${velocityCount})
> > FETCH NEXT from refcursor into @reftable_${velocityCount},
> @constraintname_${velocityCount}
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
