adding columns

Results 1 to 2 of 2

Thread: adding columns

  1. #1
    Join Date
    Dec 1969

    Default adding columns

    Hi, <BR><BR>I know how to add new columns to a database via asp code, but i don&#039;t know the names of the types of columns except TEXT<BR><BR>what else is there, and specifically what is the name for a true/false field?<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: adding columns

    binary Bigint bit Char datetime <BR>decimal Float image Int Money <BR>nchar Ntext nvarchar Numeric Real <BR>smalldatetime smallint smallmoney sql_variant sysname <BR>text timestamp tinyint varbinary varchar <BR>uniqueidentifier <BR><BR>Tinyint is my favourite for this type of thing, using a 0 or 1.<BR>I guess binary is an option, but I&#039;ve never really got on with it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts