Useful tips for everyday
How to catch the exact error record in SQL Server? DECLARE @MyTable AS TABLE (id INT NOT NULL PRIMARY KEY CLUSTERED, name VARCHAR (10) NULL)…
Is Oracle free to download? All software downloads are free, and most come with a Developer License that allows you to use full versions of…
How can I get previous row values in SQL? In other words, by using the LAG() function, from the current row, you can access data…
How do I know if SQL Server 2014 is installed? How to view and start the Database Engine by using SQL Server Configuration Manager. Click…
How does in memory tables improve performance? Memory-optimized nonclustered indexes have better performance than disk-based indexes. Starting in SQL Server 2016, the query plan for…
What is the use of on delete set NULL in foreign key? A foreign key with “set null on delete” means that if a record…
What does the regexp _ replace function do in PostgreSQL? The regexp_replace function provides substitution of new text for substrings that match POSIX regular expression…
Are there any Unicode characters in the Oracle Database? The last character is a treble clef (a music symbol), a supplementary character. Oracle started supporting…
How are regular expressions used in the Oracle Database? Oracle Database SQL Functions for Regular Expressions. The database provides a set of SQL functions that…
How do I find out who owns a database? How to check the DB Owner access for SQL Database? * Open Database server. * Login…