Useful tips for everyday
How does delete cascade work? ON DELETE CASCADE constraint is used in MySQL to delete the rows from the child table automatically, when the rows…
How to return the identity value after insert? SCOPE_IDENTITY (): It returns the last identity value generated by the insert statement in the current scope…
How are relationships represented in an ER diagram? ER diagrams are created based on three basic concepts: entities, attributes and relationships. ER Diagrams contain different…
How do I dump a specific table? Dump a specific table or few rows (MySQL) The simplest case is the whole database dumping: Sometimes, there’s…
How do I filter the most recent date in Excel? AlphaFrog Select All your Data. Select from the menu: Data\Sort. Sort by ID then by…
Can multiple columns serve as a single primary key? A table can have only one PRIMARY KEY either on one column or multiple columns. When…
How are user created variables maintained in PowerShell? User-created variables: User-created variables are created and maintained by the user. By default, the variables that you…
How do I find non-numeric values in SQL? How to find row that has non-numeric value in a character column? Using one of the methods…
Which is the best multi master replication solution? BDR is a multi-master replication solution, and it has different versions. Early versions of BDR are open-source…
How do you reference a table in SQL? Procedure Right-click in the Tables pane of the SQL Query Builder, and then click Add Table on…