sql create tables

Hi, I am just trying to set a sql database. I have this to create a table. I need to know two things.
1. I want the table to allow null. Anyone could tell me how I modify the null part. Is it just
AS NULL.
2. the other is as I am moving from an access database where I changed some fields from text to memo.
Is the [nvarchar] (25) part of that, and instead of declaring type of field you just declare its size, ie. (25) or (225) ?

Thanks for any help.
Richard

re: sql create tables

Hi Richard,

If you want a column to allow null, don't do anything. If you don't want to accept null, use Not Null.

Nvarchar is a char with a maximum length of 255 characters. You use it as you said, use the parentheses to state the number of characters you want to use. If you want to use more than 255 character, you can use ntext.

Steven

re: sql create tables

Thank Stephen, really helpful.

I do have a doubt though I have
,

This null isnt, not null, but does it mean the same thing?
and the other thing I have read that [nvarchar] (max)
allows as much data as you want?
Thanks
Richard