If you are doing date operations in c# with SQL Server then validate as follows. There are different ways also but this is one case which worked even if i give date as 10/02/0212 or 01/01/0001 instead of 10/02/2012 Continue reading
Category Archives: Quotes
Bulk Update using from and join keywords
Imagine you have two tables, table1 and table2 and you want to update table1 by using corresponding data from table2.This will do bulk updation and this can be done using from keyword while updating. This update all corresponding matching rows. Continue reading
Search All Tables In Database of SQL Server
If you are looking for a solution how to search a value in all tables of a database, then here is solution for you which will search in all tables of database. see stored procedure and its usage Continue reading