Posts Tagged: Sql server

Count word in sql server

In this blog i am going to write a function which returns word count in sql server. Sql server does not provide inbuilt function for calculating word count. So we have to write a custom function in sql. CREATE FUNCTION… Continue Reading →

Toggle in sql server

update NewTable set status= case status when 1 then 0 when 0 then 1 end

How to Write a Stored Procedure in SQL Server

In this article we learn what a Stored Procedure is and how to make a Stored Procedure in SQL Server.

Joins in SQL Server

In this article we learn about joins in SQL Server. A join is used to combined data from two or more tables in SQL.