Hyperlink a value in SQL Server

Introduction In this blog post, we will see how to hyperlink a value in SQL Server. Additionally, we see how to interchange the value as normal link-text and hyperlinks. Hyperlink a value SQL Script IF OBJECT_ID('Tempdb..#Temp') IS NOT NULL DROP TABLE #Temp; GO CREATE TABLE #Temp (NORMAL_LINK VARCHAR(200),HYPERLINK XML); GO INSERT INTO #Temp SELECT 'https://arulmouzhi.wordpress.com/','https://arulmouzhi.wordpress.com/';…

Advertisement

Methods to Show Rupee Symbol in SQL Server

In this blog post, we will see some of the methods to Show Rupee Symbol in SQL Server by using On-Premises DB and Azure SQL DB in SSMS ( SQL Server Management Studio ) and Azure Data Studio. Methods to Show Rupee Symbol Using FORMAT ( ) FunctionUsing NCHAR ( ) Function SQL Script DECLARE…

Google inside SSMS

Introduction While Others Searching about SSMS in Google. In this blog post, will see how can we bring Google inside SSMS and do Google Searches. SSMS inside Google SSMS inside Google Google inside SSMS Google inside SSMS How it is Possible? Yes, It is Possible! Check the below 2 Steps. STEP 1 Copy https://www.google.com/ and…

CONCAT_NULL_YIELDS_NULL in SQL Server

Introduction In this blog post, we will see What is CONCAT_NULL_YIELDS_NULL and what's the syntax to use and what are default settings of it in both Azure SQL Db and On-Premises DB. Also we will see what are the important things to know about it and how to handle our codes irrespective of CONCAT_NULL_YIELDS_NULL setting…

Little Trick to Save Time in SSMS

Little Drops of Ink make Millions to Think! Introduction In this blog post, we are going to see a little trick that saves our valuable time in SSMS. Actually, if we need to change , include , remove or select a pattern in our SQL code or SQL scripts, most of us follow some of…

ON and OFF IntelliSense within Session in SSMS

Introduction In this blog post, we will see how to Switch ON or OFF IntelliSense within Session Level in SSMS (SQL Server Management Studio). Refresh, Enable and Disable IntelliSense Feature in SSMS (SQL Server Management Studio) works commonly for all sessions. But here, we will see how to Enable or Disable IntelliSense within Session level in…

Import CSV and TXT Files as Tables in SQL Server

Introduction In this blog post, we are going to look how can we import .csv and .txt files as tables in SQL Server and some of the possible errors to avoid in this process. Import .csv and .txt files as Tables in SQL Server .csv file ( Comma Delimited ) .csv file .txt file (…

To Copy and Sync Database Tables Across Different Server

Introduction In this blog post, we will see How to make Copy, Sync between database tables across different Server with simple steps. We can follow the below steps and can copy or sync our Database Tables across different server and same server with different databases. Scenario we need to sync one Database table named 'States'…

Show and Hide Line Numbers in SQL Server Management Studio (SSMS)

Introduction Many of us would face some challenges as a developer while debugging the SQL Codes. SQL Server would show us some error message with the particular Line Number where the error has occurred. The main aim of this post is to see, how to Show/Hide Line Numbers in SSMS. Show/Hide Line Numbers in SSMS…

Refresh, Enable, Disable IntelliSense Feature in SSMS (SQL Server Management Studio)

Introduction Microsoft IntelliSense is one of the feature that is available in the text editor of SSMS (SQL Server Management Studio).It would reduce our Typings and provide us quick access to syntax info. In this blogpost, we are going to know how to Refresh IntelliSense when it shows 'Error with red line' , and Enable…