[thelist] MSsql question

[rudy]

> Is this just creating a table in the db jfy.user called
> assistance with the fields assistance_id and assistance?

yup

> What is COLLATE doing to this query?

never needed this myself (don't even know what the default sequence is)

it assigns a collating sequence to the values in the column

<quote source="Books OnLine")
Specifies the collation for the column. Collation name can be either a
Windows collation name or a SQL collation name. The collation_name is
applicable only for columns of the char, varchar, text, nchar, nvarchar, and
ntext data types. If not specified, the column is assigned either the
collation of the user-defined data type, if the column is of a user-defined
data type, or the default collation of the database.
</quote>

> And why are there brackets around everything?

because the statement was generated by a scripting utility
(e.g. enterprise manager)


rudy