CSV file format tab delimiter

Text --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- CREATE PROCEDURE venkattext @FILENAME varchar(200) AS DECLARE @cmd varchar(5000) DECLARE @F_Name varchar(8000) DECLARE @tempCOUNT int BEGIN CREATE TABLE ##TempFileGen2(isbn varchar(500) ,title varchar(300),authorname varchar(200),manufacturerid bigint,imageurl varchar(300),binding varchar(200),sku varchar(300),price int,name varchar(300))
Insert into ##TempFileGen2(isbn,title,authorname,manufacturerid,imageurl,binding,sku,price,name)
select top 100 P.ISBN,P.title,P.AuthorName,p.manufacturerid,P.ImageURL,p.binding,s.sku,pr.usprice as Price,m.namefrom product p join stock s on p.productid=s.productid join price pr on pr.sku=s.sku joinmanufacturer m on p.manufacturerid=m.manufacturerid and p.AmazonSync=1 and s.stockInHand>0 and pr.active=1 and s.active=1
SET @F_Name = 'E:\vengatesh\'+@FILENAME+'.txt' SET @Cmd= 'bcp "SELECT * FROM gmimagedb..[##TempFileGen2] " queryout "' -- SET @Cmd = @Cmd + @F_Name + '" -U -P -c -U sa -P @r@bm0r3' SET @Cmd = @Cmd + @F_Name + '" -c -T -S TESTSERVER\SQL2008TEST' print @cmd EXEC master..xp_cmdshell @Cmd END