One would assume that renaming a default constraint should work the same way as renaming a primary key. For some unknown reason that was not the case as I had to fix the (dynamically generated) names of default constraints. The format that worked at last was this one:
|
1 |
exec sp_rename N'SCHEMA.NAME_OLD', N'NAME_NEW' , N'OBJECT'; |
Without the N in front of …
DbUp is a great tool to manage changes to our database schemas. While its strength is with changing tables, we can use DbUp to insert seed data as well. It even works with binary data, if we use the right settings and find the correct method of SqlCommand. Accept code for migrations While it …
I needed to find all columns with an underscore (_) in their name and came up with this query:
|
1 2 3 4 5 6 7 |
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like '%_%' ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME |
But instead of showing me columns with a _ in their name, I got every column back that exists in my database. When I replace _ with anything else, I got the expected result. What …
If you frequently export the same but updated data from SQL Server to a CSV file, you can automate that task with sqlcmd. The sqlcmd tool is part of SQL Server and offers us various options to customise the export to our needs. If sqlcmd is not already on your system, you can install it …
While solving the annoying problem with the *.bacpac files, I was not sure what edition of SQL Server I have installed on my machine. The simplest way to figure out what edition you run is to start SQL Server Management Studio, connect to your SQL Server and right click on the Server node. In the …
SQL Server Management Studio may not include all important parts of your table when you let it write the CREATE TABLE script. For instance, the full-text index for a table is omitted by default. If you use the full-text search feature, you should make sure that SQL Server Management Studio includes them in the create …
For many years we could use this post to restore the Azure *.bacpac file with the backup of our user group web site. As I tried it today, I ended up with a long wait time (nearly 20 minutes) and multiple errors: The error message of the first failed step showed the problem: Could not …
I had an interesting problem to solve: How long did a task take to complete? The challenge was that our task history table contains one row for the start and another one for the end of a task: Id TaskId Action Timestamp 1 100 Start 2022-08-01 08:00:00.000 2 101 Start 2022-08-02 07:30:00.000 3 100 Stop …
After I wrote last year about 3 Database Viewers for SQLite, one of the maintainers of Beekeeper Studio pointed me to their database manager. I was interested, but unfortunately there where too many bugs that made it impossible to work with my demo database. I liked what I saw, but it needed more time to …
Of all the (programming) languages you can learn, I think SQL is the one that will help you the most throughout your career as a software developer. If you know the basics of SQL, you can solve set based problems directly in your database without writing a ton of code to do the same in …