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

Transact-SQL (T-SQL)

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

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

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) 4 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

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

Hash Code Encryption with HASHBYTES in SQL Server

Aug 18, 2018Feb 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
Post navigation
Newer posts
← Previous 1 … 4 5

Article Categories

  • Android (2)
  • Apple (16)
    • macOS (16)
  • Internet & Web Dev. (127)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • Python (65)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (2)
  • Microsoft (265)
    • .Net (59)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (183)
    • Windows (22)
  • Networks And Distributed Systems (2)
  • Oracle (4)
    • Oracle Database (4)
  • Others (4)
  • Reviews (10)

Recent Articles

  • How to loop through table rows without cursor in SQL Server? Mar 26, 2021
  • Script To Backup All The Databases In SQL Server Mar 10, 2021
  • Finding triggers on table or schema in SQL Server DB Feb 26, 2021
  • Escaping square brackets in LIKE clause in SQL Server Feb 17, 2021
  • FOR LOOP in SQL Server? Feb 7, 2021
  • Search the whole database for a string in SQL Server Jan 29, 2021
  • How to avoid the error “string or binary data would be truncated” and insert string with truncation in SQL Server? Jan 18, 2021
  • How to execute SQL Server stored procedure from Python? Dec 18, 2020
  • Error: ‘SqlConnection’ could not be found in the namespace (Solved) Dec 11, 2020
  • How to execute an SQL Server stored procedure from a C# program? Dec 11, 2020

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
  • Where is SQL Server Configuration Manager?
  • How To Add Bootstrap In ASP.NET (MVC & Web Forms)
  • How To Get Day Of Week In SQL Server?
  • 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 - 2021 My Tec Bits. All Rights Reserved.
Scroll back to top