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

SQL Server 2019

Finding the stored procedures created or modified in a given date range in SQL Server

Jun 26, 2020 by Beaulin Twinkle
Finding the stored procedures created or modified during a given date range in SQL Server

Here we will see about finding the stored procedures which are modified or created during a given date range.

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

Get the list of all indexes and index columns in a database

Jun 19, 2020 by Beaulin Twinkle
Get the list of all indexes and index columns in a Database

Here I have given you a simple script to get the list of all indexes and index columns in a SQL Server database.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) 1 Comment

Getting the list of all stored procedures in SQL Server DB

Jun 13, 2020 by Beaulin Twinkle
List of all stored procedures using ROUTINES

Here are couple of simple methods to get the list of all stored procedures created by the developers from a specific database in SQL Server.

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

Solution for Msg 8134 Divide by zero error encountered

May 21, 2020 by Beaulin Twinkle
Msg 8134 Divide by zero error encountered

Solution for the error message “Msg 8134, Level 16, State 1, Line 7 Divide by zero error encountered” when performing division operation in SQL Server.

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

Getting MAX of multiple columns in SQL Server

May 20, 2020 by Beaulin Twinkle
Getting MAX of multiple columns in SQL Server

Here is simple method to find the MAX of multiple columns in SQL Server. Getting smallest or highest values from multiple columns.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) 1 Comment

Using condition inside COUNT() in SQL Server

May 8, 2020 by Beaulin Twinkle
Using condition inside COUNT() in SQL Server

Using condition inside COUNT() in SQL Server is simple and comes in handy when you cannot use WHERE clause in the select statement.

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

How to get sizes of all databases on SQL Server?

May 1, 2020 by Beaulin Twinkle
get sizes of all databases on SQL Server

Here is a simple method which I use to get the sizes of all databases on SQL Server in a single list.

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

Get the list of user created databases in SQL Server

Apr 29, 2020 by Beaulin Twinkle
Get the list of user created databases in SQL Server

Here is a simple tip to get the list of user created databases in an SQL Server.

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

How to insert results from Stored Procedure to a temp table in SQL Server?

Apr 16, 2020 by Beaulin Twinkle
insert results from Stored Procedure to a temp table

As a database programmer, you may need to get result in table format from a stored procedure and store it to a temp table. Here we will see how to insert results from Stored Procedure to a temp table.

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

Altering existing tables with data to system-versioned temporal table

Apr 2, 2020 by Beaulin Twinkle
Altering existing tables to system-versioned temporal table with data

Here are the simple steps with example for altering existing version tables with data to system-versioned temporal table.

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

Get the list of temporal tables in SQL Server DB

Mar 25, 2020 by Beaulin Twinkle
list of temporal tables in SQL Server DB

Using simple sql technique, here we will see how to get the list of temporal tables in a database.

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

Check and drop system-versioned temporal table if exists

Mar 19, 2020 by Beaulin Twinkle
Check and drop system versioned temporal table if exists

How to check and drop a system-versioned temporal table if it exists in the database as temporal tables are different from regular tables?

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 find the history table of a temporal table?

Mar 18, 2020 by Beaulin Twinkle
find the history table of a temporal table

Here a simple trick to find the name of the history table of a system versioned temporal table using SQL select statement.

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

Find if system versioned temporal table exists

Mar 18, 2020Mar 18, 2020 by Beaulin Twinkle
Find if temporal table exists

Let us see how to check if a specific table is system versioned temporal or not using SQL script. SQL tips to check if temporal table exists.

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

Creating and using temporal table (system-versioned table) in SQL Server.

Mar 18, 2020Mar 13, 2020 by Beaulin Twinkle
How to create temporal table (system-versioned table) in SQL Server?

Temporal table otherwise called as system-versioned table helps you to maintain the version history of the data in the table in a automated way.

Categories SQL Server Tags ANSI SQL, SQL, SQL Server 2016, SQL Server 2017, SQL Server 2019 Leave a comment

Find Indexes On A Table In SQL Server

Mar 11, 2020Jan 24, 2017 by Beaulin Twinkle
SQL Server Find Indexes On A Table 03

Finding Indexes On A Table In SQL Server: There are several ways to list the indexes on a table. We’ll see few easy methods to find indexes on a table

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019 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 22 Comments
Post navigation
Newer posts
← Previous Page1 Page2 Page3

Article Categories

  • Android (2)
  • Apple (19)
    • macOS (19)
  • Internet & Web Dev. (132)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (2)
    • Python (68)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (2)
  • Microsoft (284)
    • .Net (59)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (201)
    • Windows (23)
  • Networks And Distributed Systems (2)
  • Oracle (6)
    • Java (2)
    • Oracle Database (4)
  • Others (4)
  • Reviews (10)

Recent Articles

  • How to calculate mean in SQL Server Jun 9, 2022
  • How to get execution time in milliseconds in SSMS? May 28, 2022
  • How to find whether the string contains a substring in Python? May 13, 2022
  • Reading XML file with PHP May 5, 2022
  • How to launch a PHP website on macOS? May 5, 2022
  • How to import a JSON file to a variable in Python? Apr 21, 2022
  • How to import a CSV file to a variable in Python? Apr 8, 2022
  • VirtualBox error NS_ERROR_FAILURE (0x80004005) on macOS Mar 24, 2022
  • How to perform an IF…THEN operation in SQL SELECT statement? Mar 18, 2022
  • How to update if row exists else insert in SQL Server Mar 13, 2022

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time 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?
  • SQL Server: Search and Find Table by Name
  • Find Indexes On A Table In SQL Server
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 - 2022 My Tec Bits. All Rights Reserved.