Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-08 : 07:38:19
|
| ron prowse writes "im trying to debug improve a current stored proc that creates tables to hold data for look up purposes, but it does it by declaring the table like this :- DECLARE @TClientTypeIds TABLE(ClientTypeId int not null primary key)what i what to know is there any advantages to doign it this way over using CREATE TABLE #XXX (.......etc)the major disadvantage is that its hell to debug..Ron" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
creatign tables as @XYZ 