Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,225 of 19,505    |
|    Bob Barrows to Gene Wirchenko    |
|    Re: SSE 2008: Trigger: Modifying Data to    |
|    10 Apr 11 08:54:48    |
      XPost: microsoft.public.sqlserver.programming       From: reb01501@NOSPAMyahoo.com              Gene Wirchenko wrote:       >> 2) I think that maintainability was covered by the code I borrowed       > from. My derivative has       > select * into #Inserted from Inserted       > at the beginning and then at the end, writes with       > insert into Accounts select * from #Inserted       >              You consider this to be a good idea? Despite the number of experts in the       field that advise against using selstar (select *)? I won't repeat that       advice here: it's very easily found. I will say that I have never seen an       expert recommend its use.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca