SQL Server 2005 Allow Nulls = False
Posted on 2011-05-12
Good Day Experts
I am in a bit of a quandry here. I have a SQL Server 2005 table that has 234 fields. All of the fields have the Allow Nulls property set to false. I will only need to send data to about 20 fields at the most. Short of writing ' ' to each of the fields I am not sending data to, is there anything I can dynamically do in the query that would do that for me so I don't have to manually for 200+ fields?