Hello reader!if you wish to add, delete or modify columns in an existing table you can do this with the help of alter command.the syntax to change or we can say to modify a column in an existing table ...

Change data type of Primary key column in SQL Server I used this approach to migrate our business-critical database from SQL Server 2008 to SQL Server 2016 while changing the data type of primary key ...

Sometimes we need to change the data type of a column in a table. we can do this by using modify keyword with alter command.syntax:to change the data type of a column in a table, use the following ...

If you connect to this table and set the data type on this column to be Whole Number using the dropdown in the column header (they normal way to change the data type of a column), something like the M ...

In SQL Server Change Data Capture, change activities in a table such as delete, insert, and update are easily available in a relational format. All the required inputs necessary to track changes made ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...