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 2008 R2

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

Azure Data Studio: A Cross-Platform SQL Server Tool

Mar 14, 2019Nov 18, 2017 by Beaulin Twinkle
SQL Operations Studio

What is Azure Data Studio (SQL Operations Studio)? What are the salient features of SQL Ops Studio? Advantages and disadvantages of SQLOPS over SSMS.

Categories SQL Server Tags Azure SQL Database, DevOps, SQL, SQL Operations Studio (SQLOPS), SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, Transact-SQL (T-SQL) Leave a comment

Simulating Deadlocks And Blocks In SQL Server

Jul 31, 2019May 28, 2017 by Beaulin Twinkle
Simulating Deadlocks And Blocks In SQL Server

Easy way to simulating deadlocks and blocks In SQL Server. You may need to simulate blocked processes and deadlocks for testing purpose.

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

SQL Server: Concatenate Multiple Rows Into Single String

Sep 10, 2020Jan 6, 2017 by Beaulin Twinkle
SQL Server Concatenate Multiple Rows into String 01

Combine multiple rows into one string in SQL Server. Simple query in SQL Server to concatenate multiple rows Into single string.

Categories SQL Server Tags SQL, 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 25 Comments

Article Categories

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

Recent Articles

  • Accessing the index while iterating a sequence with a for loop in Python Nov 21, 2023
  • How to replace NULL with 0 in SQL Server? Nov 4, 2023
  • How to get float or decimal result while dividing integers in SQL Server? Oct 25, 2023
  • How to format a number with commas in SQL Server? Oct 18, 2023
  • How to calculate percentage in an SQL statement? Oct 15, 2023
  • How to delete a file or folder in Python? Sep 21, 2023
  • How to create a directory, and any missing parent directories in Python? Sep 20, 2023
  • How to exit from single-user mode in SQL Server database? Sep 14, 2023
  • How to group by datetime column without considering time? Aug 31, 2023
  • What Is Django Used For and Why Do We Use The Django Framework? Aug 29, 2023

Subscribe MyTecBits.com

Online Tools

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

Popular Articles

  • How To Get Day Of Week In SQL Server?
  • SQL Server: Concatenate Multiple Rows Into Single String
  • SQL Server: Search and Find Table by Name
  • How to compare contents of two files in Visual Studio Code?
  • Error: 'SqlConnection' could not be found in the namespace (Solved)
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 - 2023 My Tec Bits. All Rights Reserved.