Tags » SQL
Oracle database has its ways. In my SQL talks at conferences, I love to confuse people with the following Oracle facts:
… and the answer is, of course: 931 more words
Last week I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? 190 more words
The following code can be used to create a sql view in a given, external database.
// local variables ADOConnection Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection ADOCommand Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Command ADORecSet Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset connString Text 1024 activeConnection Variant viewName Text 100 // the code // replace the server ip and the ext. 115 more words