Browse through various articles and courses for Free at DeveloperPublish.com

    Get Started
    HomePosts tagged “SQL Server 101”

    SQL Server 101

    Showing 1 - 13 of 13 results

    IS NOT NULL in SQL

    In this post, you’ll learn how to use IS NOT NULL conditional statement in SQL with some examples. IS NOT...
    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 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 – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit All

    Have you noticed the Context Menu , when you right click on the table in the SQL Server Management Studio...
    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