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
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
What is a Stored Procedure? SQL query you want to reuse again and again save it as stored procedure and call this whenever you need.Read More
Union and Union all are used to combine the result from two tables. It means when you want data from 2 different tables or 2 different queries and wants to combine the result you can use Union and Union All.
In SQL the Union and Union all operators are used to combine the results set into a single result set. But both operators have some key differences.
Identity Column & Cascading referential Integrity Constraints In SQL By Sagar Jaybhay About Tables In DataBase By Sagar Jaybhay SELECT Statement in SQL The select clause can retrieve 0 or more rows from one or more tables from the database or it can retrieve rows from views also. The select statement is used to select data from a table or database. The data which is our of our select query is called a result set. The select is a commonly used statement in SQL. Means for fetching the data from…Read More
Constraints In SQL Constraints are the rules which are enforced on columns of the table in database. They specifically used to limit or restrict that data goes into a column. Constraints ensure the reliability and accuracy of data. We can apply constraints on column level or table level. In this column level constraints are applied on one column at a time but when you use table-level constraints these are applied on all columns of that table. Commonly used Column constraints are below Not Null Default Unique Primary Key Foreign key…Read More
About Tables By Sagar Jaybhay Tables are database objects which contain data in the database. The table logically organized as row and column format like spreadsheet. Row in table represents the unique record and column represent field in that record. How many tables are allowed in the database? It is actually how many objects are allowed In the database and value is 2,147,483,647. How many columns does the table contain? A user-defined table may contain 1024 columns. How many rows does the table contain? There is no limitation on rows…Read More
Database By Sagar Jaybhay It is an organized collection of structured information or data, typically stored electronically in a computer system. It is usually controlled by DBMS. In general data and DBMS along with the application which is associated with them is referred to as a database system. DBMS- database management system is an interface between the database and the end-user. SSMS(SQL Server Management Studio) it is only a client tool that connects the database. It is not server a just software that connects to a database server by using…Read More