Hi,  I have reciently made a table in SQL Server 2005 that has a ''[Created] DateTime column NOT NULL'' where the default value = ''getdate()'' function. I was assuming that when i ran your SQL Stored Procedure template, it would reconize the DateTime column and the default value and appropriately set the getdate() function in the ...

I haven't been able to find a way to generate code that includes Sql Server 2005 functions. For example: if I create a function using this code: Code:ALTER FUNCTION TestFunction (@Date datetime) RETURNS int -- return value data type AS BEGIN -- begin body definition RETURN DATEPART ...