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 2012

Escape Single Quote In String In SQL Server

Jul 31, 2019Jul 6, 2017 by Beaulin Twinkle
Escape Single Quote

How to escape single quote in SQL Server? There are several ways to escape single quote. Here are few of the methods to escape quote in a string.

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Move Database To Emergency Mode In SQL Server

Aug 18, 2018Jun 14, 2017 by Dahlia Sam
SQL Move Database To Emergency Mode

How to move database to emergency mode in SQL Server. For repair and troubleshooting purpose you may need to set the status of database to emergency.

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

Offline Vs Detach Vs Emergency Database In SQL Server

Aug 18, 2018Jun 10, 2017 by Dahlia Sam
SQL Offline vs Detach vs Emergency

Differences between taking database offline, detaching it and moving it to emergency mode in SQL Server? Offline Vs Detach Vs Emergency in table format.

Categories SQL Server Tags Database, SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Detach And Attach Database In SQL Server

Jul 31, 2019Jun 8, 2017 by Dahlia Sam
SQL Detach And Attach Database 05

Simple method to detach and attach database in SQL Server. T-SQL method and SSMS method to detach an database and attach it back.

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

Bringing Database Online In SQL Server

Jul 31, 2019Jun 2, 2017 by Dahlia Sam
SQL Server Bringing Database Online 02

How to bring back an SQL Server database online? Simple methods for bringing database online state using transact-SQL or SSMS.

Categories SQL Server Tags Database, SQL, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Taking Database Offline In SQL Server

Jul 31, 2019Jun 2, 2017 by Dahlia Sam
Taking Database Offline in SQL Server 02

How to take an SQL Server database offline? Simple methods to bring a MSSQL database to offline state using transact-SQL or management studio.

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

How To Split Delimited Strings in SQL Server?

Jul 31, 2019May 31, 2017 by Beaulin Twinkle
SQL Server: Split Delimited Strings SP

Simple method to split delimited strings in newer and older versions of SQL Server. Using STRING_SPLIT() in SQL Server 2016 and higher and Few lines of code to create a function which splits the strings with delimiters on older versions.

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Tips, Transact-SQL (T-SQL) 6 Comments

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

How To Find Last Few Executed Queries in SQL Server?

Aug 18, 2018Apr 15, 2017 by Beaulin Twinkle
SQL Server Find Last Few Executed Queries

How to Find Last Few Executed Queries in SQL Server? Simple methods to find the recently executed sql statements using DMVs (Dynamic Management Views).

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Get Row Count Of All Tables In SQL Server Database

Jul 31, 2019Apr 13, 2017 by Beaulin Twinkle
SQL Get Row Count Of All Tables

How to get the row count of all tables In SQL Server database? Simple method to get the list of all tables in a database along with the number of rows.

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Find User Defined Function Containing Text or Table or Column Name in SQL Server

Jul 31, 2019Apr 5, 2017 by Beaulin Twinkle
SQL Find User Defined Function Containing Text

Find the user defined function containing text or specific table name or specific column name? Here is the simple transact SQL statements to find the UDF

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Search And Find User Defined Function (UDF) By Name In SQL Server

Jul 31, 2019Mar 29, 2017 by Beaulin Twinkle
SQL Server Search And Find All User Defined Functions UDF 05

How to search and find user defined function (UDF) by it’s name or partial name, or even with some text in the function’s source code.

Categories SQL Server Tags SQL, SQL Server 2012, SQL Server 2014, SQL Server 2016 1 Comment

Search And Find All User Defined Functions / UDF In SQL Server

Jul 31, 2019Mar 10, 2017 by Beaulin Twinkle
SQL Server Search And Find All User Defined Functions UDF 01

How to search and find all user defined functions or UDF In SQL Server? Several methods to find all the user defined functions in a database.

Categories SQL Server Tags SQL, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Temp Table vs Table Variable vs CTE in SQL Server

Aug 18, 2018Mar 2, 2017 by Dahlia Sam
SQL Server Temp Table vs Table Variable vs CTE

Difference between Temp Table, Table Variable and CTE in SQL Server. Temp Table vs Table Variable vs CTE and their usage.

Categories SQL Server Tags SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, Transact-SQL (T-SQL) 5 Comments

Function vs Stored Procedure in SQL Server

Mar 28, 2020Feb 11, 2017 by Dahlia Sam
Function vs Stored Procedure in SQL Server

Difference between function and stored procedure in SQL Server. Here you have a comparison table on Function vs Stored Procedure.

Categories SQL Server Tags SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Hash Code Encryption with HASHBYTES in SQL Server

Aug 12, 2021Feb 1, 2017 by Beaulin Twinkle
Hash Code Encryption with HASHBYTES in SQL Server

Encrypting a string using hash code algorithm in sql server using the HASHBYPES function. Hash Code Encryption using MD2, MD4, MD5, SHA, SHA1, SHA 256 & 512

Categories SQL Server Tags SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, Transact-SQL (T-SQL) 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

Find Size Of Tables In Database – SQL Server

Aug 18, 2018Jan 18, 2017 by Beaulin Twinkle
SQL Server Find Size Of Tables 01

Easy method to find the size of tables in an SQL Server database. Get the size of all the tables in a database using SSMS standard report and queries.

Categories SQL Server Tags SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 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

Shrink Transaction Log File In SQL Server

Aug 18, 2018Oct 19, 2016 by Beaulin Twinkle
SQL Server shrink transaction log file

Shrink transaction log file In SQL Server database without altering the database files . I.e. shrinking the ldf file without affecting the mdf file.

Categories SQL Server Tags Database, SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 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

  • Joining Tables from Databases on Different SQL Servers
  • Where is SQL Server Configuration Manager?
  • How to exit from single-user mode in SQL Server database?
  • Auto Generate INSERT Statements for a Table in SQL Server
  • VirtualBox error NS_ERROR_FAILURE (0x80004005) 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.