Useful tips for everyday
How to restore a SQL Server 2012 database to SQL Server 2008? I used scripts generate method to move data from SQL Server 2012 to…
What is after statement trigger? After triggers fire after all constraints have been satisfied and after the changes have been applied to the target table.…
How do I split a field into multiple fields? In the Data pane, right-click the field you want to split, and then select Transform >…
What will happen if I put my SIM card in another phone? When you move your SIM to another phone, you keep the same cell…
How do I export a MySQL diagram? To export diagram go to menu, select File, then Export, select one of the available formats and provide…
When does SQL Server management studio close after startup? Sql Server Management Studio closes in about five seconds after startup. No messages are being displayed…
How do I create an alias in PostgreSQL? Column Alias Column aliases can be used in the SELECT list of a SQL query in PostgreSQL.…
Is there a partitioning feature in SQL Server? SQL Server 2005 introduced a built-in partitioning feature to horizontally partition a table with up to 1000…
Can you manually create joins in a query? You can manually create joins in queries, even if they do not represent relationships that have already…
Is SQL Server supported on Linux? SQL Server is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is…