Posted by Erland Sommarskog on 11/21/07 22:11

Madhivanan (madhivanan2001@gmail.com) writes:
> IMO, it should throw error saying "Length is not specified"
> Sometimes it becomes tedius to debug if you forget to specify column
> width

Yes, the default of 1 is silly.

While not explicitly mentioned, this is typically something that should
be flagged when SET STRICT_CHECKS ON is in effect, a SET option which I
have suggested in
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=260762.

Votes are welcome!



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Finding the user who do update in Query Analyser?
• Prev in forum: Re: Launch storedquery for each record
• Thread view: Re: how to copy files using xp_cmdshell

[Reply to this message]