Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators
    • Date & Time Calculators
    • Finance Calculators

SQL Server

Articles related to SQL Server, SQL Queries, Stored procedures, databases, etc..

How to calculate running total in SQL Server?

Apr 27, 2024 by Beaulin Twinkle
Calculate running total using window function

In SQL server, there are several ways available to calculate running total from within a SELECT statement. Let us see few of the common methods to calculate the running total.

Categories SQL Server Tags SQL, SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

How to import XML data into SQL Server using SELECT query?

Apr 10, 2024 by Beaulin Twinkle
Import XML data into SQL Server

There are several ways available in SQL Server to import XML data. Here we will see a simple method to import XML data into SQL Server using SELECT query.

Categories SQL Server Tags SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

Separating letters and numbers from strings in SQL Server

Mar 6, 2024 by Beaulin Twinkle
Separating letters and numbers from strings in SQL Server

Here is a simple SQL Server user defined function for separating letters and numbers from a given string.

Categories SQL Server Tags SQL, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

How to store images in SQL Server?

Jan 17, 2024 by Beaulin Twinkle
Storing image in FileTable

We can store images in SQL Server using few different data types and storage methods. Here we will see couple of common methods.

Categories SQL Server Tags SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

Error: A table that has FILESTREAM columns must have a nonnull unique column with the ROWGUIDCOL property.

Jan 8, 2024 by Beaulin Twinkle
Error: A table that has FILESTREAM columns must have a nonnull unique column with the ROWGUIDCOL property.

Solution for the error while creating a table that has FILESTREAM columns. The error was because of missing nonnull unique column with the ROWGUIDCOL property.

Categories SQL Server Tags SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

Fix for Error: “FILESTREAM feature is disabled” while adding FILESTREAM

Jan 4, 2024Jan 4, 2024 by Beaulin Twinkle
Error: FILESTREAM feature is disabled.

Here is the solution for the error “FILESTREAM feature is disabled” while adding FILESTREAM.

Categories SQL Server Tags SQL Sever Management Studio (SSMS) Leave a comment

How to enable FILESTREAM in SQL Server? 

Jan 3, 2024 by Beaulin Twinkle
Enable FILESTREAM in SQL Server

By default the FILESTREAM option is disabled in SQL Server. If you want to use it, then you have to enable it first. Follow these steps to enable FILESTREAM.

Categories SQL Server Tags SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

How to convert month number to month name in SQL Server?

Dec 26, 2023 by Beaulin Twinkle
convert month number to month name in SQL Server

In SQL Server there are several ways to convert an integer month number to a month name. Let’s see a few of the methods with examples.

Categories SQL Server Tags SQL, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to replace NULL with 0 in SQL Server?

Nov 4, 2023 by Beaulin Twinkle
Replace NULL with 0 in SQL Server using ISNULL

There are few different ways to replace NULL with 0 in SQL Server. Let us go through them with examples in this article.

Categories SQL Server Tags SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

How to get float or decimal result while dividing integers in SQL Server?

Oct 25, 2023 by Beaulin Twinkle
Dividing integers in SQL Server gives integer result.

In SQL Server when you divide and integer with another integer, the result will always be an integer. So, what to do to get float or decimal result while dividing integers in SQL Server?

Categories SQL Server Tags SQL, SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

How to format a number with commas in SQL Server?

Oct 18, 2023 by Beaulin Twinkle
Format a number with commas using FORMAT function

There are couple of different ways to format a number with commas in SQL Server. Let see them in detail.

Categories SQL Server Tags SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, SQL Server 2022, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to calculate percentage in an SQL statement?

Oct 15, 2023 by Beaulin Twinkle
Calculate percentage with a SQL statement.

To calculate the percentage in an Sql statement, we can use the basic percentage arithmetic formula along with some basic SQL Server functions

Categories SQL Server Tags SQL Server 2019, SQL Server 2022, Transact-SQL (T-SQL) Leave a comment

How to exit from single-user mode in SQL Server database?

Sep 14, 2023 by Beaulin Twinkle
exit from single-user mode

Exiting from single-user mode in SQL Server involves resetting the database to multi-user mode. Here’s how to exit single-user mode.

Categories SQL Server Tags SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

How to group by datetime column without considering time?

Aug 31, 2023 by Beaulin Twinkle
Group by datetime column without considering time

Learn how to group datetime data by date without considering the time component in SQL. Discover practical SQL queries using CAST or CONVERT functions for effective data aggregation.

Categories SQL Server Tags SQL, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

Advantages and disadvantages of cursors in SQL Server

Jul 15, 2023 by Beaulin Twinkle
Advantages and disadvantages of cursors in SQL Server

While cursors can be useful in certain scenarios, they also come with both advantages and disadvantages. Let’s explore the advantages and disadvantages of cursors.

Categories SQL Server Tags SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

In SQL Server how to backup the database to a SQL script file?

Jul 4, 2023 by Beaulin Twinkle
Backup SQL Server database to a SQL script file

To backup a SQL Server database to a SQL script file, you can use the SQL Server Management Studio (SSMS). Here is the step-by-step instructions.

Categories SQL Server Tags SQL Server 2019, SQL Sever Management Studio (SSMS) Leave a comment

IIF vs CHOOSE in SQL Server

Mar 2, 2023 by Beaulin Twinkle
IIF vs CHOOSE in SQL Server

IIF and CHOOSE are two logical functions in SQL Server used for different purposes. Here we will see the competition of IIF vs CHOOSE.

Categories SQL Server Tags SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

How to insert multiple records with a single SQL query?

Feb 25, 2023 by Beaulin Twinkle
How to insert multiple records with a single SQL query?

Here is a simple tip to insert multiple records in an SQL Server database table with a single SQL insert query.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to drop all the tables from a database in SQL Server?

Feb 25, 2023 by Beaulin Twinkle
How to drop all the tables from a database in SQL Server?

In rare situations like database level permission issues, you may need to drop all the tables from a SQL Server database and recreate them.

Categories SQL Server Tags SQL, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

How to use CHOOSE in SQL Server

Jan 28, 2023 by Beaulin Twinkle
How to use CHOOSE in SQL Server

CHOOSE is a Transact-SQL function used to return a single value form a list based on the specific index. Let’s see how to use CHOOSE function.

Categories SQL Server Tags SQL, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment
Older posts
Page1 Page2 … Page12 Next →

Article Categories

  • Android (2)
  • Apple (22)
    • macOS (22)
  • Internet & Web Dev. (152)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (7)
    • Python (83)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (4)
  • Microsoft (318)
    • .Net (69)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (225)
    • Windows (24)
  • Networks And Distributed Systems (2)
  • Oracle (7)
    • Java (2)
    • Oracle Database (5)
  • Others (6)
  • Reviews (10)

Recent Articles

  • Installing .NET SDK in Linux Mint and debugging C# code using VS Code Jun 21, 2024
  • Generating random number in C#  Jun 6, 2024
  • How to calculate running total in SQL Server? Apr 27, 2024
  • How to import XML data into SQL Server using SELECT query? Apr 10, 2024
  • How to prevent VS Code from replacing an already opened preview tab with a subsequently opened one? Mar 13, 2024
  • Separating letters and numbers from strings in SQL Server Mar 6, 2024
  • How to call or run another application from python code? Feb 15, 2024
  • How to store images in SQL Server? Jan 17, 2024
  • Error: A table that has FILESTREAM columns must have a nonnull unique column with the ROWGUIDCOL property. Jan 8, 2024
  • Fix for Error: “FILESTREAM feature is disabled” while adding FILESTREAM Jan 4, 2024

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time Calculators
  • Finance Calculators

Popular Articles

  • Where is SQL Server Configuration Manager?
  • ViewModel vs ViewData vs ViewBag vs TempData vs Session in MVC
  • Setting Up Visual Studio Code For Python On macOS
  • Joining Tables from Databases on Different SQL Servers
  • Verifying Linux Mint ISO image file on macOS
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2025 My Tec Bits. All Rights Reserved.