Useful tips for everyday
How do you use null in a case statement? So in your case you want to use: SELECT st3.description. , CASE WHEN st3.description IS NULL…
What is PowerShell SMO? Some of these modules use what is called the SQL Management Object (SMO) which allows you to load some assemblies to…
In what part of a table does data are presented horizontally? The first data layout is horizontal. This is a traditional way of storing data…
How do I run an anonymous block in PL SQL? First, connect to the Oracle Database server using Oracle SQL Developer. Second, create a new…
How do I show blank if sum is zero in Excel? To display zero (0) values as blank cells, uncheck the Show a zero in…
What is extended properties in SQL Server? Extended properties are a useful feature in SQL Server which can be used for documentation and content purposes.…
What is 2 node cluster? Overview for a two-node file server cluster A failover cluster usually includes a storage unit that is physically connected to…
Why is my Excel query not working with ODBC? Cause: Excel uses an add-in Xlquery.xla, which uses dynamic data exchange (DDE) with MS Query to…
Can you install Oracle Database Xe on Kubuntu? What follows is one man’s walk through the technical steps to install the beta of Oracle Database…
What is the maximum size of database in SQL Server 2012? Microsoft SQL Server 2012 Express edition has a database size limit to 10GB. Microsoft…