Re: [SQLObject] SQL Server varchar(4000) instead of TEXT

[Oleg B. <ph...@ph...>]

On Wed, Oct 17, 2007 at 02:45:24PM +0200, Davide Alberani wrote:
> 2007/10/15, Oleg Broytmann <ph...@ph...>:
> >    How can I ask the version of the server?
> 
> See these instructions (again suggested by Steven Ovits):
>   http://support.microsoft.com/?id=321185

   Thank you. That is, if I need to test if SQL Server support MAX-types,
I have to try to issue the query

   SELECT @@VERSION

If it fails - it is SQL Server 2005. If the query returns a result - I have
a server version 5.0+, and any version of it supports MAX-types.
   Right?

> I'm more and more persuaded that the "S" of "SQL" means "Structured" and not
> "Standard". ;-)

   Could it depend on the previous letters? If the letters are 'M' and 'S'
- does it make things better or worse? ;)

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.