Case Sensitive comparison of data in Select query

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

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 [...]

How to get only date from data field SQl server t- sql

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