10/17/2023 0 Comments Alter table add column sql server![]() The only drawback of this method is that if there is any existing row in your table it will be automatically have the current date time when the column is created. In following example we will first create a sample table and later we will add a column which will be defaulted to the current date time when any new record is inserted. One has to just create table with default value as a current datetime. There is indeed a simple solution to achieve this goal. ![]() One of the questions which I often receive is how do one can add the column to existing table which will be auto-populated with the current datetime when the original row is inserted. The event is a grand success and I am having a great time at this event. While I write this blog post, I am presenting at Great Indian Developer Summit in India. Presenting a technical session is a greatest experience one can have and I enjoy doing the same.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |