Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    HomeSQL ServerPage 702

    SQL Server

    Showing 14021 - 14040 of 14077 results

    SQL Server Error Msg 110 – There are fewer columns in the INSERT statement than values specified in the VALUES clause

    SQL Server Error Message Msg 110, Level 15, State 1, Line 1There are fewer columns in the INSERT statement than...
    Read more

    SQL Server Error Msg 109 – There are more columns in the INSERT statement than values specified in the VALUES clause.

    SQL Server Error Message Msg 109, Level 15, State 1, Line 1There are more columns in the INSERT statement than...
    Read more

    SQL Server Error Msg 108 – The ORDER BY position number 4 is out of range of the number of items in the select list

    SQL Server Error Message Msg 108, Level 16, State 1, Line 3The ORDER BY position number 4 is out of...
    Read more

    SQL Server Error Msg 53 – An error has occurred while establishing a connection to the server

    SQL Server Error Message Msg 53An error has occurred while establishing a connection to the server. When connecting to SQL...
    Read more

    SQL Server Error Msg 107 – The column prefix does not match with a table name or alias name used in the query

    SQL Server Error Message Msg 107, Level 15, State 1, Line 1The column prefix ‘STD’ does not match with a...
    Read more

    SQL Server 101 – How to Find Currently Running Query ?

    If you want to find currently running SQL Query in SQL Server, you can use the Dynamic Management View dm_exec_requests...
    Read more

    SQL Server 101 – How to Round Up or Round Down a Number ?

    In SQL Server, you may want to round up or round down a number to find the ceiling or floor...
    Read more

    SQL Server Error Msg 104 – ORDER BY items must appear in the select list if the statement contains a UNION

    SQL Server Error Message Msg 104, Level 16, State 1, Line 6ORDER BY items must appear in the select list...
    Read more

    SQL Server 101 – GROUP BY datetime and ignore time

    Assume that you have a Order table and you want to query the table to retreive the total orders made...
    Read more
    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 – Get the Date part from DateTime

    You can use the convert function in SQL Server to retrieve only the date part from the date time. How...
    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

    Fix – Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80004005. SQLSTATE: 08001, Native Error: 17

    Are you facing the below error in SQL Server and looking for a fix ? Sqllib error: OLEDB Error encountered...
    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

    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