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 →
update NewTable set status= case status when 1 then 0 when 0 then 1 end
In this article we learn what a Stored Procedure is and how to make a Stored Procedure 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.