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 Tips

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 calculate statistical mode in SQL Server?

Jul 8, 2022 by Beaulin Twinkle
Get old the modes

Let us see with example on how to calculate the mathematical statistical mode in SQL Server.

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

How to calculate mean in SQL Server?

Jul 20, 2022Jun 9, 2022 by Beaulin Twinkle
calculate mean in SQL Server

Here you will see with a simple example on using an existing TSQL function to calculate the mean in SQL Server.

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

How to get execution time in milliseconds in SSMS?

May 28, 2022May 28, 2022 by Beaulin Twinkle
How to get execution time in milliseconds in SQL Server Management Studio?

One another simple method to get the execution time in milliseconds in SQL Server Management Studio (SSMS)

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

How to perform an IF…THEN operation in SQL SELECT statement?

Mar 18, 2022 by Beaulin Twinkle
IF…THEN Operation In SELECT Statement

Here we will see couple of methods to perform an IF…THEN Operation in SQL Server SELECT statement.

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

How to update if row exists else insert in SQL Server

Mar 13, 2022 by Beaulin Twinkle
Update If Row Exists Else Insert In SQL Server

Developing an application with database, frequently you will need to provide option to update if a row exists else insert a row.

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

How to list all the triggers with table name and schema In SQL Server DB?

Dec 23, 2021 by Beaulin Twinkle
List All The Triggers With Table Name And Schema

Here is a simple and quick query to list all the triggers with its associated table and schema names in an SQL Server database.

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

Get the list of all tables in a database using TSQL in SQL Server

Oct 13, 2021 by Beaulin Twinkle
List Of All Tables In A Database using SYS.TABLES

Today we will see a simple tip on how to get the list of all tables in a SQL Server database using TSQL metadata catalogs.

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

Getting accurate execution time in SQL Server SSMS

May 29, 2022Oct 8, 2021 by Beaulin Twinkle
Getting Accurate Execution Time using Client Statistics option

Status bar of SSMS won’t show the execution time in milliseconds. To get the accurate execution time in milliseconds, use the different options explained in this article.

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

How to loop through table rows without cursor in SQL Server?

Mar 26, 2021 by Beaulin Twinkle
Loop Through Table Rows Without Cursor

Row-By-Row Processing Without Cursor: Here is a simple tip on how to loop through table rows without cursor in SQL Server.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) 2 Comments

Script To Backup All The Databases In SQL Server

Mar 10, 2021 by Beaulin Twinkle
Script To Backup All The Databases

Here is a simple Transact SQL script to backup all the databases In an SQL Server

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

Finding triggers on table or schema in SQL Server DB

Feb 26, 2021 by Beaulin Twinkle
Finding Triggers For Tables

Simple tips for finding triggers in an SQL Server database based on the partial table name or all the tables under a schema.

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

Escaping square brackets in LIKE clause in SQL Server

Feb 24, 2021Feb 17, 2021 by Beaulin Twinkle
SQL escape square brackets in like clause - Problem

When trying to filter the results using LIKE clause with string having square bracket, it won’t work. So, how to escape square brackets in LIKE clause?

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

FOR LOOP in SQL Server?

Feb 7, 2021 by Beaulin Twinkle
FOR LOOP In SQL Server?

Is there FOR LOOP in SQL Server? If you are new to SQL Server and trying to create a stored procedure with some simple logic, you might be looking for the syntax of FOR LOOP.

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

Search the whole database for a string in SQL Server

Jan 29, 2021 by Beaulin Twinkle
Search the whole database

Here is my take to search the whole database for a string In SQL Server. A stored procedure to search all the tables and its columns for a keyword.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips Leave a comment

How to avoid the error “string or binary data would be truncated” and insert string with truncation in SQL Server?

Jan 18, 2021 by Beaulin Twinkle
String Or Binary Data Would Be Truncated

Here is a simple solution to avoid the SQL Server error “String or binary data would be truncated …” and Insert string data with truncation.

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

Moving table to another schema in SQL Server

Oct 5, 2020 by Beaulin Twinkle
Moving Table To Another Schema In SQL Server

IN SQL Server, moving table to another schema is quiet simple. Here I have given sample script to transfer one or all tables in a database to another schema.

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

Killing all the active connections of an SQL Server database

Aug 22, 2020 by Beaulin Twinkle
SQL Error On Restoring Database

Now we will see about the simplest method for killing all the active connections of an SQL Server database.

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

How to get the data and log file sizes for a specific database in SQL Server?

Aug 13, 2020 by Beaulin Twinkle
How to get the data and log file sizes for a specific database in SQL Server?

Here are the queries I’m using to fetch the data and log file sizes separately for a specific database. These T-SQL queries return file sizes, used space and free space using DMVs.

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

T-SQL query to find deadlocks in SQL Server

Aug 9, 2020 by Beaulin Twinkle
T-SQL query to find deadlocks in SQL Server

Here is the quick query to find deadlocks which I have used for long time. This statement is based on the SYS.DM_EXEC_REQUESTS dynamic management view.

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

Article Categories

  • Android (2)
  • Apple (21)
    • macOS (21)
  • Internet & Web Dev. (144)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (7)
    • Python (75)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (2)
  • Microsoft (296)
    • .Net (64)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (209)
    • Windows (23)
  • Networks And Distributed Systems (2)
  • Oracle (7)
    • Java (2)
    • Oracle Database (5)
  • Others (5)
  • Reviews (10)

Recent Articles

  • How to find the index of an item in a list in Python? Mar 19, 2023
  • How to check if the given string is a number in python? Mar 10, 2023
  • IIF vs CHOOSE in SQL Server Mar 2, 2023
  • How to insert multiple records with a single SQL query? Feb 25, 2023
  • How to drop all the tables from a database in SQL Server? Feb 25, 2023
  • How to reset user settings in Visual Studio Code? Feb 8, 2023
  • How to launch Visual Studio Code from macOS terminal? Feb 3, 2023
  • How to use CHOOSE in SQL Server Jan 28, 2023
  • How to make SQL script to sleep? Jan 13, 2023
  • How to make a PHP script to sleep? Dec 30, 2022

Subscribe MyTecBits.com

Online Tools

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

Popular Articles

  • SQL Server: Concatenate Multiple Rows Into Single String
  • How to compare contents of two files in Visual Studio Code?
  • How To Get Day Of Week In SQL Server?
  • Getting The List Of Column Names Of A Table In SQL Server
  • 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.