Monthly Archives: June 2015

A myth about view TIP #102

  I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer will roaming around like so Can you update record using View?  or Can you delete record using view ? I  hope everyone who is reading this article will be aware of what is …

Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101

  Let’s consider a scenario where the end user require a CSV file of all the records in a table then BCP is one of the simplest way. BCP stands for Bulk copy program. By the name you got the feeling of lots of data . Although, there are various options & parameters available with …

Find all the dates in a date range ? TIP #100

  It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really sorry for that. Now , Lets talk about the scenario sometimes we need to generate a report of total sales in particular date range but the condition is you need to show all the …