In this post I show you how to move records from sourse table to another table located into two different database. You have to copy data from source table to destination table and after You have to delete records from... Continue Reading →
This snippet query allows to select all records of a specific date, day, Month or Year For a specific date without using time: For a specific Day: For a specific Month: For a specific Year:
In this post we will show you, how to Select, Update or delete the duplicate rows you replace YourTab with Your Table Name and after “PARTITION BY” FirstColumn,SecondColumn My example Table ID FirstColumn SecondColumn ThirdColumn 1 aaa 2 a 2... Continue Reading →
ExecuteStoreQuery, executes a query directly against the data source and returns a sequence of typed results. Calling the ExecuteStoreQuery method is equivalent to calling the ExecuteReader method of the DbCommand class, only ExecuteStoreQuery returns entities and the ExecuteReader returns property... Continue Reading →
In this Brief code I show you how to move all file with a desiderate extension.