MySQL Commands to display all columnshttp://mail.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then this, but it isn't. This is one of those rare situations...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional. Why? With the Windows 10 operating system offered as...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add an alias to the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *