Introduction:
Here
I will explain how to check if string contains specific word in SQL
Server using CHARINDEX function or SQL
Server check if string contains specific substring with CHARINDEX
function.
To
check if string contains specific word in SQL
Server we can use CHARINDEX function.
Introduction:
Here I will explain how to upload files to database in asp.net and download files from database in asp.net or save or insert word document in SQL
Server
database using asp.net in C#, VB.NET.
Introduction
Here
I will explain how to kill or close all active database connections in SQL
Server.
Description
Introduction
Here
I will explain how to get or find number of active connections to database in SQL Server.
Description
Introduction:
Here
I will explain how to write a query to read xml
data file or read xml data type with simple example using SQL
Server.
Description:
Introduction:
Description:
Introduction:
Here I will explain how to write query to get latest or recent records
but unique records in SQL
Server.
Description:
Introduction
In this SQL
Server article I will explain how to write query to get monthly (month wise) data or
year wise data from database.
Description
Introduction:
In this SQL Server article I will explain how to write query to get records Exclude weekends data or without weekends
data in SQL
Server.
Description:
Introduction
In this SQL
Server article I will explain how to insert single quote or apostrophe data
in database.
Description
Introduction
Here I will explain how to use nested while loops in SQL
Server with example.
Description
Introduction
Here I will explain how to exit from while loop in SQL
Server or how to break from while loop in SQL
Server with example.
Description
Introduction
Here I will explain how to use while loop in SQL
Server stored procedure with example.
Description
Introduction:
Here I will explain how to write query to get or find first and last
day of current month or previous month in SQL
server.
Description:
Introduction:
In
this article I will explain how to use DATEADD function to add or subtract
specified time interval from dates in SQL
Server.
Description:
Introduction:
In this article I will explain how to find or get last modified date
and created date of stored procedure or table in SQL
server.
Description:
Introduction:
In
this article I will explain how to retrieve data from multiple tables in sql
server.
Description:
Introduction:
Here I will explain the difference between stored
procedure and function in SQL
Server.
Description:
Introduction:
In
this article I will explain how to pass table as parameter to stored procedure in
SQL Server 2008.
Description:
Introduction:
Here
I will explain what is the difference between cross join and full outer join in
SQL
Server.
Description:
