Posts Tagged: Sql server

Count word in sql server

June 18, 2017 by in Interview Question, SQL

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

January 12, 2015 by in Interview Question, SQL

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

How to Write a Stored Procedure in SQL Server

October 10, 2014 by in SQL

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

Joins in SQL Server

October 9, 2014 by in SQL

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