Internet solutions team

You can forcefully do the case sensitive comparison of data in sql serer by using COLLATE Latin1_General_CS_AS in a select query

Select * from  Table1 inner join Table2 Table2.ID=Table1.ID where

(Table2.WebsiteUrl  COLLATE Latin1_General_CS_AS)<>(Table2.websiteurl COLLATE Latin1_General_CS_AS)

How to export delimited (tab, space, comman) file from query analyzer Visual Management Studio (2005)

In the  Query menu choose Query options

1.  From Results Choose Text

2. Choose out format from drop down list

3.  Click OK.

4. In the query menu from  Result to choose Result to file

5.  Run your query it will ask you the file name  and by default it shows in save as type [Report files (*.rpt)]

6. Choose  All files (8.*) from save as type drop down.

7. Name your fiel as “myfil.csv” and click on save.