uniqueidentifier

[surenr]

Hi,
I have different attributes with the data types as follows:

EmpID uniqueidentifier
EmpName Char
EmpSal Int

I am not sure how the uniqueidentifier works,but I had checked in the SQL
forums and it is said that the EmpID will be assigned an automatically
generated number, so in the insert statement we can give:

INSERT INTO Emp_Info(EmpName,EmpSal)
VALUES ('David',5400)

I tried this same stuff but it throws an error:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert the value
NULL into column 'EmpID', table 'BIOL1114.dbo.page_data'; column does not allow
nulls. INSERT fails.

Any ideas and suggestions will be of help.
thnx

[SQLMenace]

make a default on the table or use
INSERT INTO Emp_Info(EmpID ,EmpName,EmpSal)
VALUES (newid(),'David',5400)