by Sumi » Wed, 05 Mar 2003 03:29:18
Thx.
Sumit
by Jacco Schalkwij » Wed, 05 Mar 2003 06:22:11
BEGIN
END
Quote:> Hi All,
> I have "N" tables with NVARCHAR column datatype.
> I need to find all the CHAR(0) to CHAR(31) characters in
> each column and delete the data.
> One way to find this is to use WHERE clause with
> LIKE '%CHAR(0)%' option. But this will be VERY slow and I
> have to make check of 32 such characters. Is their any
> other faster way to do the same.
> Thx.
> Sumit
This is a multi-part message in MIME format.
------=_NextPart_000_0075_01C1AB1F.93556E70
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello all,
Does anybody knows why table and field names are limited to 31 characters?
Is there any way of changing this?
Thank you in advance,
Kind regards,
Oscar.
------=_NextPart_000_0075_01C1AB1F.93556E70
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello all,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Does anybody knows why table and fiel=
d names=20
are limited to 31 characters?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Is there any way of changing this?</FONT><=
/DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thank you in advance,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Kind regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><BR>Oscar.</FONT></DIV></BODY></HTML>
------=_NextPart_000_0075_01C1AB1F.93556E70--
___________________________________________________________________________
mensaje enviado desde http://www.iespana.es
emails (pop)-paginas web (espacio ilimitado)-agenda-favoritos (bookmarks)-foros -Chat
2. Load Flex Datagrid from recordset filled by query??
3. Altering a CHAR(4) column CHAR(5) changing
4. (WIN 5.0) - Baffled Beyond Belief!
5. Altering a CHAR(4) column CHAR(5) changing pg_attribute
6. MSDE 2k SP3 Install Problem on Win 98
7. Can't insert char into CHAR column
9. Storing non-printable chars in CHAR columns
10. Problems joining a numeric(31,0) column with a varchar(31) column
11. data types nchar/nvarchar versus char and varchar
12. When to use nvarchar/nchar, varchar/char, text/ntext
13. CHAR/VARCHAR vs. NCHAR/NVARCHAR performance