Your Ad Here

advanced code snippet search

Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

nublaii
jeremydouglass


csv2Table

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. CREATE TABLE TopQueries 
  2. ( 
  3.     CPUCycles BIGINT, 
  4.     ExecutionCount BIGINT, 
  5.     QueryText nvarchar(4000)
  6. )
  7.  
  8. BULK INSERT TopQueries 
  9.     FROM 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\perf.csv' 
  10.     WITH 
  11.     ( 
  12.         FIELDTERMINATOR = '\t', 
  13.         ROWTERMINATOR = ',' 
  14.     )
  15.  
  16. DROP TABLE TopQueries

Report this snippet  

You need to login to post a comment.