Useful tips for everyday
How to concatenate two columns during inner join? I have table A and table B with Table A having several columns including A1 and A2.…
How do I find local admins on my server? Double-click the Administrators group from the right pane. Look for the user name in the Members…
How do I protect my database from recovery catalog? Back up the recovery catalog with the same frequency that you back up the target database.…
Can I delete default Postgres database? 2 Answers. Basically – no. postgres database is here as a non-template database with reasonable guarantee that it exists…
How to pass multiple rows to PostgreSQL function? PostgreSQL doesn’t have table-valued variables (yet), so nothing’s going to be pretty. Passing arrays is inefficient but…
How do I add a database to mirroring? Expand SQL Server instance > Expand databases > Right-click on AdventureWorks2017 > Hover on Tasks > Select…
How do I start SQL Server from command line in Ubuntu? To create database mydb execute following command in terminal: mysql -u root -p -e…
Does SQL Management Studio require a reboot? A restart shouldn’t be required unless the updated binaries were in use, but you may find that next…
How to return default value when column value is null? SELECT FlatId,COALESCE ( [dbo]. [Flat]. [FlatName],’Default Value When Null Encountered’) AS FlatName, FlatDescription FROM [dbo].…
How do you sum distinct records in SQL? SQL Server SUM ALL instructs the SUM() function to return the sum of all values including duplicates.…