Platform :MS SQL Server
DatabaseName : ChallengeTest
TableName :TestData
Challenge :
Create a TSQL script to read data from SQL Table and dump all the rows onto a csv file,comma delimited.
Platform :MS SQL Server
DatabaseName : ChallengeTest
TableName :TestData
Challenge :
Create a TSQL script to read data from SQL Table and dump all the rows onto a csv file,comma delimited.
Hatukufanyii homework ngombe hii
Niko na jibu.Mimi ndio msahihishi
BEGIN
SELECT d.Csv
FROM (
SELECT convert(varchar(25),column1) +‘~’+convert(varchar(200),column2)+‘,’+convert(varchar(200),column3)+‘,’+convert(varchar(200),column4)+‘,’+convert(varchar(200),column5)+‘,’+convert(varchar(200),column6)+‘,’+convert(varchar(200),column7)+‘,’+convert(varchar(200),column8)+‘,’+convert(varchar(50),column9)+‘,’+convert(varchar,column10)+‘,’+convert(VARCHAR(20),column11)+‘,’+convert(varchar(200),column12)+‘,’+convert(varchar(200),column13)+‘,’+convert(varchar(200),chYear)+‘,’+convert(varchar(200),chStaffCode) AS Csv,2 AS SortOrder
FROM ChallengeTest.dbo.TestData AS Expr1
FROM ChallengeTest.dbo.TestData)
)d
ORDER BY d.SortOrder
END
Cough it out Using BCP Utility tool
Replying to your own thread is like …
…is like Baba kujitoa Kwa uchaguzi alafu anadai kua presidente:D
:D:D:D:D:D