SQL コマンドいろいろ¶

バルクインサート¶

BULK INSERT LossYachin
FROM 'C:\temp\Data.txt'
WITH
    (
        FIRSTROW = 2, 
        FIELDTERMINATOR  = '\t'
    )

テーブル単位の容量を知る方法¶

DECLARE @table TABLE( 
        [TableName] SYSNAME, 
        [rows] BIGINT,
        [reserved] VARCHAR(25),
        [data] VARCHAR(25),
        [index_size] VARCHAR(25),
        [unused] VARCHAR(25)
         )
INSERT INTO @table
EXEC sp_MSforeachtable @command1 = "sp_spaceused '?'" 
SELECT * FROM @table order by rows desc