Sql-Server-Query-World

Today I will show how to write a query in order to convert the columns to rows in SQL Server 2008 without using the unpivot function:Step 1: Let's analyse the input first which is as shown below:Step 2: Now lets write

Read More

The INSERT INTO statement is used to insert new records in a table. But in SQL Server 2005 we cannot write an insert into statement & insert the whole tables or output values into a table. We have some other

Read More

Today I will show you how we can write a query in order to convert Binary to Decimal in SQL Server and vice-versa:1. Query to convert Binary to Decimal value: DECLARE @input varchar(max) = '1010' ;WITH N(V) AS (     SELECT

Read More

Code Formatting in Stored Procedure on any version of SQL Server:With the Editor you can format your code with indenting, hidden text, URLs, and so forth. You can also auto-format your code as you type by using Smart Indenting.Indenting You

Read More

Today we will go through the steps in order to write the simplest query to combine multiple rows into single row in SQL Server 2008:  Step 1: Create a table CREATE TABLE [dbo].[Students] ( [Id] [int] IDENTITY(1,1) NOT NULL, [age]

Read More

Step 1: Create a procedure in order to replace the last occurrence of a string with a specified string as shown below: CREATE PROC sp_ReplaceStringWithLastOccurence (       @Texto varchar(MAX),       @findString VARCHAR(100),       @replaceString VARCHAR(100) ) AS BEGIN     DECLARE @Pos INT=0,@startPos INT=0,@endPos INT=0,@totalStringLength

Read More

Step 1: Below is the query that we can use in order to convert the date into words: declare @date datetime = '01-10-1985'--Input DateOfBirth declare @yr smallint = datepart(year, @date); declare @month smallint= datepart(month, @date); declare @day smallint = datepart(day,

Read More