Programmers and Webmasters’s Routine CSV Databases
My goal with this page is to make sure that these routines databases are always available all the time . I still see a lot of websites out there who are trying to sell a … Read more
Category : Databases
Mysl, MSSQL, Oracle, SQLITE, POSTGRES
Cannot find either column “dbo”…or the name is ambiguous
“Cannot find either column “dbo” or the user-defined function or aggregate “dbo.fnycsoftware”, or the name is ambiguous.” If you are absolutely sure that you do not have have another function with that name and the … Read more
Minutes Difference Same Day (T-SQL)
// Get a time in the format : 8:00 AM // Returns the minute difference in integer using the current time // (only works for the same day but you can modify to work for … Read more
Add a Mysql as a Linked Server
The other day I got a request to migrate some data from Mssql to Mysql. I am like ok fine, I will just use SSIS and it will take me a second. This second led … Read more
T-SQL Transaction Timeout Error (SQL Server Management Studio)
In SQL Server Management Studio, if you are unable to modify a large database schema due to timeout error, you might need to increase the “transaction timeout” flag. Go to tools -> Options -> Designer and modify … Read more