Thanks Kenneth.

I hope there is no other way to set the default and not null together in one command.

Deepa

Hi,

Unfortunately it does not help a lot.

In my case, the number of students, number of courses they are subscribed to and the number of subjects in the search string are...

Thanks a Lot

Aaron,

If I need to extract this way then I'll have to create a procedure. Is it not possible through a single SELECT?

Deepa

Thanks a ton,

Regards

Deepa

Deepa

I have to convert an Oracle 8.0 database to SQL Server 2000. The Oracle Database has many stored procedures (linked in packages) for business logic implementation. Is there a...