>>>Hi,
>>>
>>>What would be a syntax in SQL Server equivalent to APPEND BLANK in VFP? That is, if I want to insert a row with all empty (or default) values. TIA.
>>
>>I'm sure there is a good reason but out of curiosity, why would you want to do that?
>
>I needed to write a script to add a blank record to a bunch of tables so I was looking for a way to do it with the minimum number of keystrokes.

In SQL Server there is no concept of 'blank' record.