No subject
Fri May 2 19:13:14 EDT 2003
sp_server_info
--------------
Returns a list of attribute names and matching values for Microsoft=AE =
SQL
Server(tm), the database gateway, or the underlying data source.
Syntax:
sp_server_info [[@attribute_id =3D] 'attribute_id']
ATTRIBUTE_ID: 16
ATTRIBUTE_NAME: IDENTIFIER_CASE
Description: Specifies the user-defined names (table names, column =
names,
stored procedure names) in the database (the case of the objects in the
system catalogs).
ATTRIBUTE_VALUE: MIXED or SENSITIVE, depending upon whether SQL Server =
is
set to case-sensitive or case-insensitive.
=20
Default value is MIXED
David
> -----Original Message-----
> From: Thompson, Bill D (London) [mailto:ThompBil at exchange.uk.ml.com]
> Sent: Wednesday, 28 August 2002 7:45 AM
> To: TDS Development Group
> Subject: [freetds] RE: ODBC and column names
>=20
>=20
> Man - I should get my facts straight before I open my big mouth!=20
> :-O
>=20
> At the risk of prolonging this debate further than it=20
> deserves, I believe
> the default behaviour of SQL 2000 is case insensitive.
>=20
> BilL
>=20
>=20
> > -----Original Message-----
> > From: Lowden, James K [SMTP:LowdenJK at bernstein.com]
> > Sent: Tuesday, August 27, 2002 10:06 PM
> > To: TDS Development Group
> > Subject: [freetds] RE: ODBC and column names
> >=20
> > > From: Thompson, Bill D (London)=20
> [mailto:ThompBil at exchange.uk.ml.com]
> > > Sent: August 27, 2002 4:47 PM
> > >
> > > column names (although SQL 7/2000 are case insensitive).=20
> >=20
> > Huh?
> >=20
> > 1> select * from b select * from B
> > 2> go
> > b
> > -----------
> > 1
> >=20
> > (1 row affected)
> > Msg 208, Level 16, State 1, Server NTS0214, Line 1
> > Invalid object name 'B'.
> >=20
> > 1> select B from b
> > 2> go
> > Msg 207, Level 16, State 3, Server NTS0214, Line 1
> > Invalid column name 'B'.
> >=20
> > 1> select cast(@@version as varchar(50))
> > 2> go
> >=20
> > --------------------------------------------------
> > Microsoft SQL Server 7.00 - 7.00.859 (Intel X86)
> >=20
> > (1 row affected)
> >=20
> > Who you calling insensitive? =20
> >=20
> > --jkl
More information about the FreeTDS
mailing list