Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    HomePosts tagged “database”

    database

    Showing 1 - 10 of 10 results

    Dealing with the column names that looks like SQL Keywords in SQL Server

    There are times when you might have a column names in your SQL Server database table that might looks like...
    Read more

    SQL Server’s ISNULL() equivalent in PostgreSQL

    SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to...
    Read more

    How to get day of a week in SQL Server ?

    Assume that you have a date “01/09/2016” and you would like to find out what day of the week it...
    Read more

    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

    How to Get the Number of Tables from SQL Server Database ?

    Below is a sample SQL query that demonstrates how to count the number of tables in a SQL Server database...
    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