Hello readers, Here we will see how to Call SQL Server Stored Procedure in C#. How to Call SQL Server Stored Procedure in C#: A stored procedure is a pre-defined, reusable routine that is stored in a database. SQL Server compiles stored procedures, which makes them more efficient to use. Therefore, rather than dynamically building […]
Category: SQL Server
How to show only Odd or Even Rows in SQL Server?
How to Select Odd or Even Rows in SQL Server? In this tutorial, I am going to show you how to select Odd Or Even Rows in SQL Server. Here is the steps for the same. Create Table: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Employee]( [ID] [bigint] […]
Creating Comma Seperated Values from Table in SQL Server
In this tutorial, I am going to show you how can we build a Comma Separated Values from the Table in SQL Server. Introduction: In some situation, we need to create a comma separated value from the table in SQL Server. Here I am going to show you how can I build a Comma Separated […]
Difference between @@IDENTITY, IDENT_CURRENT and SCOPE_IDENTITY
Hello friends, In this tutorial, we are going to see the IDENTITY column in SQL Server. what is the difference between @@IDENTITY, IDENT_CURRENT, and SCOPE_IDENTITY? […]
User Defined Function to Convert Number into Word
Hello readers, In this tutorial, I am going to create a User Defined Function to convert Number into Word. User Defined Function to Convert Number into Word: Suppose you have a requirement where you have to show Amount of some kind into both Number and Word. I am creating a User Defined Function that will […]
Row Number Function in SQL Server
In this tutorial, I am going to explain you about Row Number Function in SQL Server. This is built-in Ranking Function provided by SQL Server for assigning a sequence number to records in a result set. Row Number in SQL Server: ROW_NUMBER is a built-in SQL Server function that is used to show sequence number […]
Like Operator in SQL Server
Hello Friends, In this tutorial we are going to Learn Operator in SQL Server. Like Operator is used to perform a pattern matching search in a Query. Like Operator in SQL Server: Like Operator is used to perform a pattern matching search in a Query. Like Operator is used in the where clause of select, […]
Check Constraint in SQL Server to allow only Alphabates in Column
Hello readers, Here are going to create a Check Constraint in SQL Server to allow only Alphabets in Column. Check Constraint in SQL Server to in the column: Sometimes you face a situation to allow alphabets in columns. This is the real-world scenario. Here I am going to create a Check Constraint that will prevent any […]
Dynamic Query in SQL Server
Hello Friends, In this blog, we will see how we can execute Dynamic Query in SQL Server. Sometimes you need to generate dynamic SQL queries that built on fly and execute. Here we are going to see how we can execute dynamic queries in SQL Server. Introduction to Dynamic Query: There are two approaches to execute […]
Case Sensitive Search in SQL Server
In this tutorial, we are going to learn Case Sensitive Search in SQL Server. Many applications need the functional requirement that they need to make a Case Sensitive Search for example UserName and password. Introduction: The default collation for SQL Server is not case sensitive however it is possible to collation of any column of […]