Posts Tagged: Sql server

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.