Post reply

Bulk Insert And Table Data Type

  • January 28, 2004 at 10:02 am

    #107153

    Hi !!!

    Does anybody know if SQL Server is able to use BulkInsert statement with table data type?

    BULK INSERT @TableName FROM 'c:\somefile.dat'

    WITH (FORMATFILE = 'c:\somefile.fmt')

     

     

    Thanks a lot ¡¡¡¡

  • January 28, 2004 at 11:26 am

    #492032

    Sorry, I do not know "off the top", but i know BULK INSERT #TempTB .... works. Can you use a #TempTB instead of a @Table variable?



    Once you understand the BITs, all the pieces come together

  • January 29, 2004 at 1:36 am

    #492117

    thanks a lot tomash I will use temp tables instead of table data types

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply