Useful tips for everyday
Can you use Countif with dates? To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater…
How to get distinct rows from a LEFT OUTER JOIN stack? But since Table1 is my main table the relationship is virtually like a one…
Where are assembly files located? It is located in %windir%\assembly (for example, C:\WINDOWS\assembly) and it is a shared repository of libraries. What is reflection in…
How do you transfer data from one table to another? Use a Field in One Table to Update a Field in Another Table Create a…
How do I connect to a PDB user? Establishing a connection using user defined services involves the following steps: Create a database service with PDB…
How to back up a database using pgadmin? Back up databases using pgAdmin Select the database you want to back up: right-click the database and…
How do I see all foreign keys to a table or column? SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA…. To see all FKs in your table: USE…
Can a database have more than one filegroup? A filegroup works as a logical container for datafiles. One filegroup can have multiple data files. Now,…
How can I restore MySQL from a backup? To restore a MySQL instance from a backup to a database server: Shut down the database server.…
What should I ask a vendor? 10 Questions Every Entrepreneur Needs to Ask Suppliers What are my payment terms and are they negotiable? What will…