Checklist for SQL Server Database Migration & Its Best Practices

SQL Server database migration is considered as a process that helps to move the previous implementation to a newer version of SQL Server, and require different locations with a strategic decision. Therefore, in this blog, we are going to discuss most important aspects that need to be examined before and after migrating to the SQL Server. This article is intended to provide guidance that can help to create the migration plan. Continue reading “Checklist for SQL Server Database Migration & Its Best Practices”

Advertisements

Insert into table with default values only

In this article you will find how to insert a row without any specified values in SQL Server table, if the columns have default values.

I recently had this issue. I had a table with only two columns one of which was auto-increment and the other had a GETDATE() default value. I needed to insert a record¬†programmatically with default value. I didn’t knew how to insert a record without specifying any values. First I tried to insert it with GETDATE(), but since that column had it by default I wanted more elegant solution.

After some searching I found the best way to do it is this:

 INSERT INTO Your_Table DEFAULT VALUES

I hope it helps!

Blog at WordPress.com.

Up ↑