Re: maximum characters per column

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 13:57:09 -0400

"Rob" <anonymous@discussions.microsoft.com> wrote in message
news:1cbf601c452fe$cd4e7b60$a101280a@phx.gbl...
> How do you set the maximum characters per column in SQL
> Server 6.5? Also, how do you specify this using T-SQL in
> 7.0 and 2000? Thanks.

You can use the CREATE TABLE or ALTER TABLE statement to define the maximum
characters stored per column. If you are talking about limiting the maximum
character length to something less than the column width... In SQL Server
6.5 you could use a trigger, in SQL Server 7/2000 you could use a trigger or
a constraint.

Steve

Relevant Pages

  • Re: DTC Fehler
    ... Auf dem Windows Server ist SQL Server 2000 SP3a und ... wird der Barcode im SQL ... Server abgespeichert und der Trigger ausgelöst (After ... Access Express ODBC to a R510 or later OS/400 system. ...
    (microsoft.public.de.sqlserver)
  • on delete set null
    ... daß der SQL ... Server ON DELETE SET bei einem FOREIGN KEY nicht unterstützt. ... Nun versuche ich das ganze mit einem Trigger zu simulieren (auf SProcs ... ID UNIQUEIDENTIFIER PRIMARY KEY); ...
    (microsoft.public.de.sqlserver)
  • SQL 7 vs. 2000 issue -trigger and nulls
    ... We're trying to dump our remaining v7 SQL server and update to 2000. ... We're having trouble with a trigger updating some tables. ... @SiteID = SiteID ...
    (microsoft.public.sqlserver.mseq)
  • =?iso-8859-1?q?Re:_Frage_zu_nem_Insert-Statement_und_Zeichenfolgen_w=FCrden_abgeschnitte
    ... irgendeinen Trigger INSTEAD OF INSERT, UPDATE habe, sollte der nicht ... nenn' das einfach mal Bug im SQL Server...oder doch besser Feature ... Hat mich halt trotzdem etwas gewundert, dass der SQL Server sowas trotz ...
    (microsoft.public.de.sqlserver)
  • Re: Running C# (.NET Framework 2.0) Application from long path (>127) crashes!
    ... a connection to the server. ... failure may be caused by the fact that under the default settings SQL ... If i run *any C# application* from a path that exeeds 127 characters ... the connection string is perfectly ok. ...
    (microsoft.public.dotnet.general)