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 2005

List All Foreign Keys Referencing A Table In SQL Server

Jul 31, 2019Jan 5, 2018 by Beaulin Twinkle
List Foreign Keys Referencing A Table

Quick methods to list all foreign keys referencing a table in SQL Server using execution of simple TSQL scripts and SSMS GUI. Ways to identify all the tables referencing a table with foreign key constraint

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

Pagination of Results in SQL Server In Efficient Way

Sep 13, 2018Dec 15, 2017 by Beaulin Twinkle
Pagination of results in SQL Server

How to do pagination of results in SQL Server In and efficient way? Best way to paginate results in SQL Server to improve performance of the application.

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

How to get Date from DateTime data type in SQL Server?

Aug 18, 2018Dec 11, 2017 by Beaulin Twinkle
Date From DateTime Datatype

How to get date part alone from DateTime and DateTime2 data types in SQL Server? Here are few of the techniques to get date from DateTime column.

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

TRIM() Function To Remove Space In SQL Server

Aug 18, 2018Sep 27, 2017 by Dahlia Sam
Trim Function In SQL Server

TRIM() Function In SQL Server 2017 and equivalent custom made TRIM UDF in 2016 and older versions ti trim the spaces at the starting and ending of a string.

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

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

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 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 23 Comments

Check If Column Exists In Table Of SQL Server

Aug 18, 2018Oct 13, 2016 by Beaulin Twinkle
Check If Column Exists In SQL Server Table 05

Tips and tricks to check if column exists in a SQL Server database table. Also find the list of all tables and stored procedures having the column name.

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

Fix for “unable to load client print control” Error

Jan 27, 2021Jun 12, 2013 by Beaulin Twinkle
My-Tec-Bits

Steps to fix the error “unable to load client print control” received during printing reports SQL Reporting Services reports.

Categories IIS, Internet Explorer, SQL Server Tags Reporting Services, SQL Server 2005, SSRS 1 Comment

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

  • How to compare contents of two files in Visual Studio Code?
  • SQL Server: Concatenate Multiple Rows Into Single String
  • How To Get Day Of Week In SQL Server?
  • Error: 'SqlConnection' could not be found in the namespace (Solved)
  • Upgrade python version in visual studio code python workspace
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.