Sql Server & SSRS Tips

If you want to search a specific column in the whole database in sql server then you can the following query: select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like   '%yourColumnName%' in the place of yourColumnName between the Percent sign you have to write the column name which you want to search

where PropPropertySubtype.Description in ('Class A','Class B') and PropProperty.PropertyID in    (SELECT PROPERTYID FROM DBO.FN_SEARCHPROPERTYID(@SearchID,1)) 

For displaying only date and eliminating time from date in SSRS =formatdatetime(Parameters!ReportDate.Value,dateformat.shortdate) =formatdatetime(Fields!ReportDate.Value,dateformat.shortdate) use appropriate from above two formulas. " dateformat.shortdate " will show only date value and eliminate time from it. and it will be used in " formatdatetime " function.

There are three methods for retrieving data base information in sql server. EXEC sp_databases EXEC sp_helpdb SELECT *  FROM sys.sysdatabases order by name