SQL Apprentice Question
I need to alter a temp table to add column, and then access that column
in next line.As it cant be possible in a same batch , I need to put a
GO between the lines.But the problem is, these are the lines of a
stored proc,and as soos as query analyzer(sqlserver2000) finds a GO,it
takes it as a last line of the stored proc.
Can't I add column and access the same in a same sp?Is it technically
possible?
Should you have any comments or any other work around , pls share with
me.
Apologies for any inconvenience in understnding the above points.
thanks,
Celko Answers
>> Should you have any comments or any other work around , pls share with me. <<
Do not program this way at all. This is like wanting to modify an
automobile in the middle of a race. You should start the race with a
complete car and not create it on the fly. Temp tables are also a
symptom of a procedural approach to a problem rather than a relational
approach.
Until we have actual specs (i.e. What you want to do) instead of a
kludge request (I.e. how you have decided to do it already), we cannot
help you.
Thursday, October 05, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment