OffOn
    Register
    HomePosts tagged “SQL Server”

    SQL Server

    Showing 1 - 20 of 42 results

    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

    How to Specify port number for Server when connecting in SQL Management Studio ?

    By default , the SQL Server listens to the port number 1433 and assume that if your server name is...
    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

    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 – 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

    How to Export the Query Result to .csv file in SQL Server?

    Here’s another tip where you could export the query result to .csv file in SQL Server. How to Export the...
    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 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
    white smartphone

    Open DBDiff for SQL Server

    Last few weeks , I have been playing around with this cool tool called Open DBDiff . As the name...
    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

    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

    What are the Limitations of SQL Server Express Edition ?

    Microsoft SQL Server comes in different versions that includes SQL Server Enterprise SQL Server Business Intelligence SQL Server Standard SQL...
    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

    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

    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

    Difference between DELETE and TRUNCATE command in SQL Server

    Below are few points that differentiate the DELETE and TRUNCATE command. Sl. No. DELETE TRUNCATE 1 This removes the rows...
    Read more

    How to Create a Database Backup in SQL Server using SQL Scripts?

    You can create a Database Backup in SQL Server easily by using the SQL Scripts. Just specify the BACKUP DATABASE...
    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

    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

    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

    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