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.
In this article, we want to discuss a nice function to Search String Value in all Columns of a Table in SQL Server. Before we get started, if you want to know about random number generators, please go through the […]
Continue reading Search string value in all columns of a table in SQL Server
In this article, we want to discuss a nice function to random number generator script in SQL Server. Before we get started, if you want to know about split with any delimited string, please go through the following article: Update […]
PL/SQL is a procedural language designed particularly to embrace SQL statements inside its syntax. PL/SQL program models are compiled by the Oracle Database server and saved contained in the database. And at run-time, each PL/SQL and SQL run inside a […]
In this post, we want to share the SQL Server license key of all versions. Before we get started, if you face a problem activating Microsoft Visual Studio for Product Key, please go through the following article: Visual Studio Product […]
Continue reading How to Activate Microsoft SQL Server with License Key for Any Version
In this post, we want to discuss the efficient way to convert DateTime format in SQL Server. Before we get started, if you want to know about split with any delimited string, please go through the following article: How to […]
Continue reading SQL Server DateTime Formatting: Convert, Format, and Display Dates – Complete Guide
There are many advantages of Stored Procedures. I was once asked what do I think is the most important feature of Stored Procedure? I have to pick Only ONE. It is tough to question. I answered: Execution Plan Retention and […]
Continue reading What is the best advantages of Stored Procedure
In this post, we discuss best practices for split comma delimited string SQL Server. Many a time we come across a scenario where we pass a comma or any other character delimited string to stored procedure and in a stored […]
Continue reading How to Split comma delimited string into a Table in SQL Server
This is a new feature intorduced in Sql Server 2008. Table-Valued Parameters provides option for the Client Applications to pass multiple rows of Data to Stored Procedure.
Prior to this, if we were needed to pass multiple rows of Data from client application to Sql Server, then we use to model the input data as xml and pass it to the stored procedure and in Stored Procedure convert this xml to a table variable/temporary table.
Continue reading Understanding Table-Valued Parameters in SQL Server for Better Performance
In this post, we want to discuss an efficient techniques to learn or use Rowversion in SQL Server. Before we get started if you want to know about string case conversion to Title or Proper Case, please go through the […]
Continue reading SQL Server: Use ROWVERSION for Concurrency Control and Change Tracking
In this tutorial post, we want to discuss How to Create Job in SQL Server step by step. Before we get started, if you want to know about the Activation Serial key of SQL Server (all versions), please go through […]
Continue reading How to Set Up SQL Server Agent Jobs for Automation and Maintenance
