Useful tips for everyday
How do I connect to ODBC with SQL Server Management Studio? Click Start and select Settings > Control Panel > Administrative Tools. Double-click Data Sources…
How do I edit a PostgreSQL conf file? 1 Answer To edit the postgresql.conf file: Choose Tools > Server Configuration > postgresql.conf. To edit the…
How many types of entity relationship models are there? An entity-relationship (ER) diagram, also called an entity-relationship model, is aptly named: It shows the relationships…
How do I fetch alphanumeric values in SQL? PATINDEX(‘%[A-Z]%’, Val) > 0, it ensures that string should contain alphanumeric characters. PATINDEX(‘%[0-9]%’, Val) >, it ensures…
How do I find my SQL Plus password? To unlock and reset user account passwords using SQL*Plus: Start SQL*Plus and log in as the SYS…
Why are MySQL queries taking so long? There are plenty of reasons which require looking at different aspects of a MySQL server. In some worse-case…
How to calculate duration between timestamps in one column? If you want to just put it in a spreadsheet the way you have then you…
How to get rid of corruption in PostgreSQL database? Before doing anything else: Stop the postmaster and take a file system level copy of your…
How to grant table level permissions in MySQL? You can create a user with table level permissions in MySQL by performing the following: Connect to…
Why does MySQL round floats way more than? The emphasis here lies on approximate. If you need to store exactvalues, you should really use the…