Useful tips for everyday
How to insert trigger in MySQL after insert trigger? We inserted two rows into the members table. However, only the first row that has a…
Which is query slows down due to the index? Now the query which slows down due to the index (the query is meaningless since it…
Can a column have multiple constraints? Table constraints allow you to specify more than one column in a PRIMARY KEY, UNIQUE, CHECK, or FOREIGN KEY…
How do you refresh SSIS? To refresh the source in this case, replace the select statement with select a = 1. Then, after the metadata…
How do I connect to SQL Server without a password? Steps to Access SQL Server Database without Password Step 1: Download and install iSunshare SQL…
Is ORACLE_SID case sensitive? DB_NAME and ORACLE_SID are case sensitive under Linux and Unix, just like commands and file system usage. What is SID in…
How do I insert data from one column to another table? The SQL INSERT INTO SELECT Statement The INSERT INTO SELECT statement copies data from…
Which query is faster better to use? Because efficient queries = faster retreival. Regular SQL queries, when optimized for better and faster performance, save time…
How do I make multiple values in one column in SQL? Description FROM #table1 AS one LEFT OUTER JOIN #table2 AS two ON one. ErrorID…
What does Postgres do when there is a lock? Postgres will recognise this situation after a second or so and will cancel one of the…