When are you getting the error?  A BIGINT can't fit into an INT and would in fact be truncated.  I am just trying to understand where you are getting the error.

Yes, I want to force DDT cast my field numeric to int, so i put in BigInt and after in Int
but i getting a error cause it doesn't want truncated.

And if i run a script : Alter table [Imhotep].[dbo].[affaires] alter column [etage] [int] not null
SqlServer can truncated

Can we insert a script in DDT (tsql) ?


DDT is very useful, and maybe the other developer use it, like as add or rename column,
but may be not to change the data type.
Cause may upsizing from foxpro get a bad datatype,we use DDT to make a beautiful and good database
for my application.

I hope , i was clear in my text.

thanks
Olivier


==============================================
Asp.net C# - Strataframe - telerik
==============================================