Query to Find Department Wise MAX Salary of Employee
comment
Add Comment
Introduction In this article, I am going to explain how to write a query to find the department-wise max salary of employees where the salar...
Split Alphabets from Alphanumeric String In SQL Server
comment
Add Comment
Introduction This article gives an explanation about how to split alphabets from the alphanumeric string in an SQL server. Here I'll al...
Split Numbers From Alphanumeric String In SQL Server
comment
Add Comment
Introduction This article gives an explanation about how to split numbers from the alphanumeric string in an SQL server. Here I'll also ...
How to Create Dynamic PIVOT Query in SQL Server
comment
Add Comment
Introduction In this article, I am going to explain how to create a dynamic pivot query in an SQL server. I'll also explain how to creat...
Concatenate value from multiple rows to a single string in SQL Server
comment
Add Comment
This article gives an explanation about an efficient way to concatenate value from multiple rows to a single string in the SQL server. The...
How to Find Values Within a Given Range in SQL server
comment
Add Comment
Introduction This article gives an explanation about how to find the particular records from the range in the SQL server as well as sh...
How to Find the Last Date of Any Month in SQL Server
comment
Add Comment
Introduction This article provides an explanation about to find the last day of any month based on the given date in the SQL server as...
Split Comma Separated String Using STRING_SPLIT in SQL Server
comment
Add Comment
Introduction This article gives an explanation about how to split comma separated string using STRING_SPLIT function and shows you how...
![[Fixed] Error 26: Error Locating Server/Instance Specified in SQL Server 2008](https://1.bp.blogspot.com/-R15OtszxkxY/XQXNTJbuApI/AAAAAAAAAhc/pHjvRu5oVF4l_diIOOxmpZKqh8L-DeHqACLcBGAs/s72-c/a-network-related-or-instance-specified-error-sql-server.png "[Fixed] Error 26: Error Locating Server/Instance Specified in SQL Server 2008")
[Fixed] Error 26: Error Locating Server/Instance Specified in SQL Server 2008
comment
1 Comment
Introduction This article gives an explanation about how to fix an error 26 a network-related or instance-specific error occurred whil...
The MERGE Statement in SQL Server
comment
Add Comment
Introduction This article gives an explanation about the MERGE statement in SQL server. Basically, the MERGE statement in SQL server j...
PIVOT and UNPIVOT in SQL Server with Example
comment
Add Comment
Introduction This article gives an explanation about the pivot and unpivots operators in SQL server with example. The process of con...