SQL Tips How to remane a Table in Sql Server? How to change the database collation? How to find duplicate values in a table? How to make database offline or online? Renaming a column in Sql Server? Share this:FacebookTwitterLinkedInRedditWhatsAppSkypePrintTumblrTelegramPinterestPocketLike this:Like Loading...
3 thoughts on “SQL Tips”
Nice Post 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.
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.