Useful tips for everyday
When to use upsert or update in PostgreSQL? The idea is that when you insert a new row into the table, PostgreSQL will update the…
How do I set the default schema in PostgreSQL? ALTER DATABASE SET search_path TO schema1,schema2; Or at the user or role level: ALTER ROLE SET…
What is the difference between a table constraint and an assertion? The difference between the two is that CHECK CONSTRAINTS are, in a sense, much…
How to import and export data from SQL Server? Start the SQL Server Import and Export Wizard from SQL Server Management Studio (SSMS) 1 In…
How do I grant access to a database in SQL Server 2012? Expand Security, right-click on Logins and select New Login. Enter a descriptive Login…
What is incrementing a variable? To increment a variable means to increase it by the same amount at each change. For example, your coder may…
What is serialized inventory? What is serialized inventory? Serialized items are assigned serial numbers in order to identify more expensive items like computers, electronics, automobiles,…
What is bulk delete in Oracle? the rule to decide when to use a bulk delete: “use it when you cannot do the delete in…
How do I export large SQL results to Excel? One more thing can be done is to use the DTS Wizard. Right click on Database…
How do you check is MongoDB connected or not? Testing the network connection to the MongoDB Rest Service server Start a terminal in the server…