Useful tips for everyday
What data types are supported by SQLite? SQLite only has four primitive data types: INTEGER, REAL, TEXT, and BLOB. APIs that return database values as…
How do I use cursor to fetch multiple records? Procedure Specify the cursor using a DECLARE CURSOR statement. Perform the query and build the result…
How do I find SQL Server configuration settings? Take the following steps to access the SQL Server Configuration Manager: Click Start. Select All Programs. Select…
How to install Oracle 11g on Ubuntu 18. 04? Step 2: Instructions before install Oracle Copy the downloaded file and paste it in home directory.…
How many connections can ProxySQL handle? Question 1 : Connection pooling in ProxySQL So ProxySQL can open total 1000 backend connection for that specific host.…
How do I change database to single-user mode? To set a database to single-user mode In Object Explorer, connect to an instance of the SQL…
How do you change the Nextval of a sequence? To reset a specific sequence in Oracle: Get the next value for the sequence: Alter the…
Can a full text index be created in MySQL? A full-text index in MySQL is an index of type FULLTEXT . Full-text indexes can be…
How do I check if a value is in multiple columns in SQL? Now, I want to check if ANY of col1, col2, col3, col4…
How do I delete a linked server in SQL Server? To remove all remote and linked server logins for a server when you remove the…