Your Technical Consultant
Storing and retrieving data as requested by other software applications, either on the same computer or a remote machine, utilizing the client-server model.
There’s loads of confusion concerning the distinction between a DBMS and an RDBMS. I’ve even seen “RDBMS vs RDBMS” discussion board posts, the place the accepted reply outlines the variations between DBMS and RDBMSs as if they had been two […]
Continue reading Difference Between DBMS and RDBMS – Easy Explanation for Students
Like other programming language, Microosft SQL Server also has an error handling model to handle exceptions and errors that occurs in T-SQL statements. We have TRY..CATCH blocks to handle exception/error in Sql Server. We put T-SQL statements in TRY block […]
Continue reading SQL Server: Best Practices for Error Handling and Exception Management
The SQL Server MERGE command combines the INSERT, UPDATE, and DELETE commands into a single statement. Here is how to get started with the use of MERGE in SQL Server: Start by identifying the target table that will be used […]
Continue reading SQL Server MERGE Statement Explained – Insert, Update, and Delete in One Query
Stored procedures give us many advantages over using SQL scripts and SQL statements that are dynamically created by our windows or web applications. Compilation and storing of the query execution plan: When SQL Server runs a query it calculates the most […]
Continue reading Benefits of Using Stored Procedures in SQL – Performance, Security & More
In this post, we want to discuss a nice function to convert text to title case (Proper Case) in SQL Server. With this function, you can easily convert your desire test to a title case. Before we get started, if […]
Continue reading Function to Convert Text String to Title Case – Proper Case
This is a simple stored procedure in which you can search through all the data (table wise rows and size) in the SQL Server database. You can see all information like column name, schema name, row count & row size […]
Continue reading Best Ways to Find Table-Wise Row Count and Size in SQL Server
In this article will present how we can write a Dynamic PIVOT query with an example, where we don’t need to mention the PIVOT columns each unique value, and no need to worry if the PIVOT column gets extra unique […]
In this post, we want to discuss search underscore in columns in SQL Server. Before we get started, if you want to know about Merge Into command in SQL Server, please go through the following article: Using Merge Into in […]
Continue reading Tips for Searching Special Characters ( _ ) in SQL Server Columns
The SQL Server Cheat Sheet provides you with the syntax of all basic data types, type casting, and functions, shows you how to create tables, views, and data related to different conditions, and has examples. So, let’s start SQL Server Cheat […]
Continue reading SQL Server Cheat Sheet for Programmers & Engineers – Essential Commands & Queries
In this article, we discuss How to add Linked Server to SQL Server. There are two ways to add another linked server in SQL Server. Using the first method (sp_addlinkedserver), you need to specify the actual server name as the […]
