SQL Temp Table: Temporary Table In Detail 2020

Sql Server By Sagar Jaybhay

In this article, you will able to understand Temporary table in detail in SQL, with how many different types of Temporary table present in SQL server. What is the difference between these Temporary tables. Temporary Tables In Detail Temporary tables are similar to permanent tables. When you create a permanent table they will create the database you specify and remain in that database permanently until you delete it. Temporary tables get created in tempdb automatically and deleted automatically when no longer used them. There are 2 different types of temporary…

Read More

User Defined Function In SQL Server-2020

Sql Server By Sagar Jaybhay

In this article, we will understand User Defined Function in sql server with different types of function in sql server a) Scalar function b) Inline table-valued functions c) Multi-statement table-valued functions User-defined Functions In SQL Server User-defined functions also called UDF. In SQL server there are 3 different types of User-Defined functions Scalar function. Inline table-valued functions. Multi-statement table-valued functions. You can find these functions folder in SQL Server Management studio see below image Scalar Functions The scalar function is a function that may or may not have parameters but…

Read More

Case and Convert Function In SQL Server 2020

Sql Server By Sagar Jaybhay

In this article we will understand case and convert function in sql server in detail and what is the difference between case and convert function in sql server. Previous SQL Articles :- https://sagarjaybhay.com/category/sql-server/ When we want to convert from one data-type to another data-type we have Case and Convert function In SQL server. Cast function in SQL Server This Cast function can convert an expression to the provided datatype. In short, it is used to convert one data type to another data-type. General syntax: In the above  function, we will…

Read More