SQL Tips

3 Responses to SQL Tips

  1. Nice Post sir,,,,,,,,

  2. vikas sharma says:

    Hi sir,
    Can you tell me the query to select only the rows in which all the column value will be unique and there should not be any row with duplicate column value.
    If so, then in result, the row with duplicate value and the row whose duplicate comes should not be in output.
    Only the rows with unique column value should come.


  3. Anonymous says:

    Hi sir ,
    Can you please suggest which is the efficient way of querying for the building a query dynamically whether i can go with stored procedure or Dynamic Linq because am developing an asp .net mvc which requires multiple filtering . The user can apply 1 column filter or 2 or more i will know only at the compile time .Can you please suggest the right way with some explanation

Comments are closed.