Reply to Re: SUBSTRING in User Defined Function - Invalid column

Your name:

Reply:


Posted by jknaty on 05/25/07 13:42

On May 24, 5:39 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Just change:
>
> >> DECLARE #CourseTableTemp TABLE (
>
> To
>
> >> DECLARE @CourseTableTemp TABLE (
>
> And use @CourseTableTemp throughout the function.

Sure enough, that worked! Thanks again for everyone's help this is
just what I needed. I do have a SP problem but I'll create a new post
for that.

>
> Logically, temp tables and table variables are very similar, but there
> is some fine-print which can be really confusing.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

This is good to know, thanks!

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация