Today’s Topic of discussion is Stored Procedures in SQL . DBMS components are divided into ‘5’ parts- Hardware, Data, Software,Users,procedures(set of rules).DBA works become easy after the use of Procedures in SQL server. (DBA- Database Administrator).Stored procedure are used to save a particular code ,so the code could be used over again. What is Stored …
Our today’s topic of discussion is Auto Increment in SQL. This property are mostly used by the ‘Primary Key’ in the table. As the name suggests,It allows a random/unique number to generate every-time a record is inserted in the table.Without any further delay let us jump to today’s topic , and enjoy the essence of …
Many times one need to copy data from one part to other. SQL SELECT INTO statement is also used to serve the same purpose. This statement is to copy data from one table to other table . Table 1: ————(copy @data)———>Table 2 SQL SELECT INTO statement could copy data from one table to other, and …
What is NULL ? As the name suggests, Null value represents a field with Zero/Blank Value. It is very important to learn that NULL value do not represent ‘0’ or any spaces. NULL values are different from Zero . In SQL , A field that is left blank is considered to be a NULL value. SQL …