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”
By using Ms SQL Server any edition you can create a full backup to multiple disk file, which is the best solution. In a steps of one Job you can do it by using this Transact SQL, as it follows:
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!