Messages

1

General Board / SQL Server 2005 table, nvarchar(max) columnType

« on: June 10, 2009, 02:08:15 am »

Hello,
I would like to ask you how to set column type to nvarchar(max)? When I am creating new column in table of sql server 2005 type there is only nvarchar type for selection. Lenght must be specified (from 0 to 4000) and I did not found any way how to set length to "max". I am using EA 7.1.833 which should supported this feature (according to Release Notes for EA 7.1).

I was looking at google, help, forum but without success.

Thanks for help

2

General Board / Re: Unique constrains on multiple columns

« on: May 19, 2009, 04:25:13 am »

Thank you very much for your help. It works precisely as I needed.

3

General Board / Unique constrains on multiple columns

« on: May 18, 2009, 05:41:34 am »

Hello,
Can you please give me an example how to create unique constrains on multiple columns in DB table? I was looking in EA on many places but still I can create unique only single column, not multiple columns. It would be very nice in case this constrains would affect generated SQL file too.

Thanks for help,
Jakub