Useful tips for everyday
Which is the best way to start a PostgreSQL server? The bare-bones way to start the server manually is just to invoke postgres directly, specifying…
How can a data table be in improved? This can be done through sparing use of color or by outlining a specific cell or column…
How does cross apply work? CROSS APPLY returns only rows from the outer table that produce a result set from the table-valued function. It other…
How to get rid of an index in PostgreSQL? The name (optionally schema-qualified) of an index to remove. Automatically drop objects that depend on the…
How do I select the last row in SQL Server? In this way, we will get the output as the last row of the table.…
How does PG dumpall work in PostgreSQL 9.1? The script file contains SQL commands that can be used as input to psql to restore the…
How to troubleshoot SSIs package job failed? You can check SQL Server Agent’s activity logs, Windows Event logs and SSIS logs to get more clues.…
How do you insert data into an identity column? Insert Value to Identity field SET IDENTITY_INSERT Customer ON. INSERT INTO Customer(ID, Name, Address) VALUES(3,’Prabhu’,’Pune’) INSERT…
How do you solve complex queries? Identify all the tables you’ll need in the query. Join tables containing the data you need to display or…
How do you find a value in all column of all table in Oracle? SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE ‘%DTN%’; But…