Hi!

For this purpose, I usually create temporary table with only one record - one field here match to one variable like you mentioned. Query to it is pretty quick.

Anyway, for inserting large number of records, I would also follow BCP solution, that is the quickest approach for data transfer (after copying the entire SQL database file as is, of course).



>HI
>
>I uses DECLARE @var on Batch command.
>
>I can DECLARE @Table ( Batch Variable Table ).
>I can CREATE #Table ( Connection Temporary Table ).
>I can CREATE ##Table ( Global Temporary Table ).
>
>I need DECLARE @var DATATYPE STATIC ( Connection Static Variable ).
>
>Exists this possibility?
>
>Fabio