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 [...]
Following line gives you the short date from long date time field. ie. From a date time field of Sql server field if you need to extract only date use the the following method. Replace GetDate() with your date field name. Cast(Floor(Cast(Getdate() as float)) as datetime
