Sure. A lot of times you'll have a scenario where you just want to add records - say you're a user registering for a new sql web site! If you want to use ADO recordsets, you need a way to get the table schema into the recordset so you do the add. One way is to manually load the fields collection, perhaps by querying sysobjects/syscolumns, or just by hard coding the fields you need. A shortcut is to retrieve a recordset that has 0 matching records, that way you get the schema but no data, then you can add from there. Which technique you use depends on your goal. If you want to save round trips, you should embed the fields and add manually. If you want to keep it simple, use the zero record record set idea (and the way you get that is by putting in criteria that will never match 'where 1-0'). I never use the sysobjects method (better would be infoschema view), doesnt have any advantages really.
Andy