Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    HomePosts tagged “SQL Server”

    SQL Server

    Showing 1 - 20 of 42 results
    white smartphone

    SQL Server 101 – Extract Domain Name from Email Address

    This was one of the quick task that I was required to work where i need to get the domain...
    Read more

    SQL Server 101 – Get the identity of inserted row

    If you are looking at a way to find the identity of the inserted row in SQL Server , you...
    Read more

    SQL Server 101 – Search tables for a specific column name

    You might want to search all the tables in your database for a specific column name in order to rename...
    Read more

    SQL Server 101 – Get the size of all tables in database

    You might have a scenario where you want to find out how much space that each of the tables in...
    Read more

    SQL Server 101 – Return the Current DateTime

    If you want to return the current date time in SQL Server , the easiest way to do it is...
    Read more

    SQL Server 101 – Check if a column exists in a table

    If you need to check if a column exists in a table or not in SQL Server , below is...
    Read more

    SQL Server 101 – How to add a column with a default value to existing table ?

    There are times when you want to add an column with a default value to the existing table in SQL...
    Read more

    SQL Server 101 – How to Delete Top N records ?

    Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top...
    Read more

    SQL Server – Shortcut to display the Stored procedure Code

    Are you looking at displaying the stored procedure code quickly with-in your SQL Server Management Studio ?. Here’s how you...
    Read more

    SQL Function to make all TEXT to propercase in SQL Server

    There are times when you want to change the text from the table to a proper case in SQL Server...
    Read more

    How many databases does a SQL Server Instance support?

    Here’s a common question on what is the maximum number of databases that I can run on a single SQL...
    Read more

    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

    How to return the column names from a table in SQL Server ?

    You can easily return all the column names of a table in SQL Server 2008 using the sp_columns stored procedure....
    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

    Quick way to search within a procedure in SQL Server

    There are times when you want to to list out all the stored procedure names that contains certain keyword or...
    Read more

    How to view the code of a stored procedure using a Query in SQL Server ?

    Here’s a quick tips on viewing the code of a stored procedure in SQL Management Studio. One of the quickest...
    Read more

    Print a text N number of times in SQL Management Studio

    When working with SQL Management studio , you might need to display a string N number of times , in...
    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

    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