Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming microsoft is required, the following 79 results were found.

  1. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    FETCH NEXT FROM MyCursor INTO @SqlToExecute END CLOSE MyCursor DEALLOCATE MyCursor T-SQL Source: http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58 - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP...

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

  2. Search a database with SOUNDEXhttps://www.joellipman.com/articles/else/database/search-a-database-with-soundex.html

    ** ** Correct the value for EthnicCode and re-run the code. ** ** ** ** Link to other SQL Server collations: http://msdn.microsoft.com/en-us/library/ms180175.aspx ** ** **...

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

  3. Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/else/database/restore-mssql-error-database-is-in-use.html

    is a doddle and doesn't warrant its own article but for those of us who merely use SQL Server Management Studio (SSMS) and Microsoft's SQL Server 2008 R2 for development purposes, the once-in-a-blue-moon restore from backup process is quickly forgotten....

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

  4. Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/else/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    the number of times this value was found in this column. ** ** ** ** Link to other SQL Server collations: http://msdn.microsoft.com/en-us/library/ms180175.aspx ** ** **...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  5. T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    plus signs and thinks it's super clever when it tries to add a number and a string together; then remembers it's a Microsoft by-product and realises it can't. Solved by checking the datatypes for each field in the concatenation string:...

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

  6. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and more. Similar systems have popped out that support some form of time recording and...

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

  7. Difference between two dates - the midnight hourhttps://www.joellipman.com/articles/cms/website-development/difference-between-two-dates-the-midnight-hour.html

    that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for those that it's obvious to... Compare the two timestamps, if the "To date" is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *

  8. SITS: Export field code and namehttps://www.joellipman.com/articles/cms/website-development/xml/sits-export-field-code-and-name.html

    to: Microsoft Windows 7 Enterprise SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment....

    • Type: Article
    • Author: Joel Lipman
    • Category: Extensible Markup Language
    • Language: *

  9. Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

    back into "Report Filter" Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so...

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

  10. Stop Excel Row Height Self-Adjust on Refreshhttps://www.joellipman.com/component/content/article/stop-excel-row-height-self-adjust-on-refresh.html?catid=110&Itemid=165

    Situation I have a Microsoft Excel 2007 file that connects to a SQL Server 2008 R2 database. The Excel file pulls data using lookup tables and displays the data in an Excel Spreadsheet. The Problem We can select all cells and set row height to be 30 for...

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

  11. Checklist for the local computer repairshttps://www.joellipman.com/component/content/article/checklist-for-the-local-computer-repairs.html?catid=116&Itemid=165

    RAM (eg. x Accessories > System Tools > Disk drive cleanup tool. Check Windows Eventviewer for all errors. Versions of Microsoft Office installed? Printing: Can you print any other documents? Have you tried printing to another printer? Can you print...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *

  12. SSRS Templates in BIDS 2008https://www.joellipman.com/component/content/article/ssrs-templates-in-bids-2008.html?catid=75&Itemid=165

    and leave elements for all reports. File > Save selected item as... For SSRS 2008: Save in the folder: "C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject" Done!

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

  13. UNC Paths in Sharepoint 2007 linkshttps://www.joellipman.com/component/content/article/unc-paths-in-sharepoint-2007-links.html?catid=77&Itemid=165

    to Microsoft Office Sharepoint 2007 What? I've been tasked with adding links to files located on some network shares. I want to use UNC paths such as \\myServer\myShare\myFile.doc. I could map the UNC path to a drive letter and then link to it (eg....

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

  14. Increase Recent Documents Number in Windows XPhttps://www.joellipman.com/component/content/article/increase-recent-documents-number.html?catid=80&Itemid=165

    what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs" Double-click on the new DWORD Set...

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

  15. VBScript to retrieve Windows Product Keyhttps://www.joellipman.com/component/content/article/vbscript-to-retrieve-windows-product-key.html?catid=80&Itemid=165

    code to the file: Set wshShell = CreateObject("Wscript.Shell") MsgBox ConvertToKey(WshShell.RegRead("HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\DigitalProductId")) Function ConvertToKey(Key) Const KeyOffset = 52 i = 28 Chars =...

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

  16. MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

    is just the best Unfortunately I make a living using Microsoft and Oracle products. I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article...

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

  17. Modifying columns in a tablehttps://www.joellipman.com/articles/else/database/modifying-columns-in-a-table.html

    MODIFY COLUMN misplacedColumn AFTER otherColumn; MySQL and Oracle PL/SQL ALTER TABLE myTable MODIFY myColumn myDataType Microsoft Transact SQL (T-SQL) ALTER TABLE myTable ALTER COLUMN myColumn myDataType

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

  18. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    '(.)', '\1 ') -- -- REGEXP_INSTR(email, '\w+@\w+(\.\w+)+') > 0 -- -- REGEXP_SUBSTR('oracle', 'o r a c l e', 1, 1, 'x') Microsoft T-SQL Note the circumflex/hat to negate the expression in the first example, and then the use of NOT LIKE in the second...

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

  19. List last modified files using FTP Command-linehttps://www.joellipman.com/articles/cms/website-development/ftp/list-last-modified-files-using-ftp-command-line.html

    out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK)...

    • Type: Article
    • Author: Joel Lipman
    • Category: File Transfer Protocol
    • Language: *
Results 61 - 79 of 79