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…

SQL Question and Answer #4

Question - What is Attribute, Tuple, Domain and Degree? Thinking that it will be useful to know some of the Basic Term definitions. Inspired from this Question. Attribute Basic, Rows are Records, Columns are Attributes of a Table. Tuple Tuple is a Single row of a Table. Domain Domain is the set of possible data…

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…

Date in Our Language using SQL

Introduction In this blog post, we will see how we can use Dates in Some of our Local Languages! Date in Our Language We can achieve this by using FORMAT Function of SQL Server. Syntax FORMAT ( value, format , culture ) SQL Script DECLARE @Current_DateTime DATETIME; SELECT @Current_DateTime=SYSDATETIMEOFFSET() AT TIME ZONE 'India Standard Time';…

SQL Question and Answer #3

Question Pic - Try yourself before checking Answer below! Question pic There can be 'n' number of answers for the above question. Among those, Below we have given one. Please comment your other methods of doing it. Because Sharing is Caring! From 'Thursday, March 05 2020' To '2020-03-05' SQL Script DECLARE @date VARCHAR(50) = 'Thursday,…

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…

Which Data Types has Non Nullable Default Values

I will be Happy to Convey that I have reached Half-Century in blog posts! Many more are yet to come...!

To Identify Available SQL Data Types

Introduction In this blog post, we are going to see what are the available datatypes in SQL and how to identify it. What are Available SQL Data Types Available SQL Datatypes To Identify Available SQL Data Types We can use sys.types ( System Catalog View) to identify both System and User-Defined Datatypes. SQL Script to…