Useful tips for everyday
Can one entity have multiple relationships? There can be a number of different relationships between the same two entities. For example: Employee is assigned to…
How can get column name as row in SQL Server? Tip Query to get all column names from database table in SQL… SELECT COLUMN_NAME. FROM…
Can ROLLBACK be done after commit? Until you commit a transaction: After you commit the transaction, the changes are visible to other users’ statements that…
How do I select a single record for duplicates in SQL? How to Find Duplicate Values in SQL Using the GROUP BY clause to group…
When would you use a database trigger? When to use triggers Create an audit trail of activity in the database. Implement a business rule. Derive…
Is it time consuming to do data migration? They can be complicated and time-consuming – and regardless if you are going cross-platform, cross-domain, or adding…
How to get the max value in PostgreSQL? SELECT customer_id, MAX (amount) FROM payment GROUP BY customer_id HAVING MAX (amount) > 8.99 First, create a…
What is pattern matching explain two algorithms for pattern matching? Pattern matching is a basic problem in computer science which occurs naturally as part of…
How to grant access only to a schema in SQL? Simply follow the below steps to grant SCHEMA level access. CREATE SQL USER. GRANT only…
How do I fix database not synchronizing? Availability Group Database Not Synchronizing / Recovery Pending State Ascertain that the database files are accessible. Attempt to…