After spending all day programing for .NET

I am beginning to call it DAWDLE NET!

(since it takes so long to load)

Dave Catherman

Joel,

you can use Text as a parameter type (as noted in the article), but you are limited on how you process the information in the SP.

Dave

Good article but it does not discuss the real problem with Text fields.  I have a problem passing XML data from a Text field in a table to the sp_XML_preparedocument...

I saw an example recently where they used the LIKE function to check for differences:

If T1.NTextFld LIKE T2.NTextFld

     Begin

        ...Do something

Dave C

One area that needs to be addressed is how layoffs are conducted.  I work for a good company and was very satisfied untill one day they had to lay off...

Even knowing what day it is, the fact that you and Stephen Wynkoop (SSWUG) both had the same lead story in your newsletters, raised my excitement level for...

Tom Rizzo has a new blog related to this topic http://sqljunkies.com/WebLog/tom%20rizzo/archive/2005/03/09/8704.aspx

He claims that SQL Server 2005 Management Studio allows source control, but he does not expound much on it. ...

Steve,

Have you thought of updating the article for use with .NET and Visual Studio .NET.  I find that the tools in VS.NET handle about everything I need to edit and...

Thanks for the article.  I too struggled with the options.  I even created an access project for the SQL database and continued to use Access as much as possible.  But...

Steve,  Thanks for the great article. 

One thing you did not mention (in Part 1) is the common practice of using only singular names for table names.  This has helped...

the preview screen shows the report in HTML which is not page size aware and shows the full width and height as if you has infinite page size.  When you...

Usually when you have this problem, it means that the design of your table needs to be further normalized. If you were to refactor the table to be like