-
How to: Manage Transactions in the Entity Framework
How to: Manage Transactions in the Entity Framework Managing Connections and Transactions
-
How to find column in Database
Select * From INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like ‘%Phone%’
-
How to cast MSSQL Datetime in MYSQL
If any one mograte MSSQl data to MYSQl then there will be issue related to datetime column. SQL management studio generate script export the datetime value to hex value and MYSQL doesn’t recognized it. To solve this issue just create a function and called it where required. create function sp_ConvertSQLServerDate(dttm binary(16)) returns datetime return CAST( […]