Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    Home2016August

    August 2016

    Showing 1 - 13 of 13 results

    Kill all the current active connection in SQL Server database

    There are times when you want to kill all the current active connections of your SQL Server database and you...
    Read more

    How to replace NULL values with alternate values in SQL Server ?

    Assume a scenario where you are trying to get the records from the table where some of the records contains...
    Read more

    WAITFOR TIME in SQL Server

    If you want to pause the execution of the code block until a specific time is reached , you can...
    Read more

    WAITFOR DELAY in SQL Server

    If you want to pause the execution of the code block for a specific amount of time , you can...
    Read more

    How to check if the table exists in a database in SQL Server ?

    To check if the table exists in a database in SQL Server , you can use the INFORMATION_SCHEMA view. How...
    Read more

    Using Expressions for SORT Order in SQL Server

    You might want to sort the results of an query in a different order from the traditional sort (Ascending/Descending) order....
    Read more

    Wildcard Search in SQL Query

    There are times when you don’t have a specific value to find but you might have to use the general...
    Read more

    Change the look and feel of Microsoft Excel 2016

    Microsoft Excel 2016 comes with 3 office themes by default. These are light gray , dark gray and colorful theme....
    Read more

    Other ways of specifying the alias name for a column in SQL Server

    When we work on SQL Server query , we use the AS keyword to specify the alias name for a...
    Read more

    Column Alias and Square brackets in SQL Query.

    When we want to specify a alias for a column in SQL Query , we tend to use the double...
    Read more

    How to find the Windows OS Build version from Command Line in Windows 10 ?

    There are multiple options to find the Windows OS Build version from command line in Windows 10. How to find...
    Read more

    How to find the Computer Name from Command line in Windows 10 ?

    You can find the computer name of the Windows 10 machine machine using the hostname command. The hostname command prints...
    Read more

    How to add prefix or suffix to range of cells in Microsoft Excel 2016 ?

    This blog post will explain in how to add prefix or suffix to a range of cells in Microsoft Excel...
    Read more

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8