Latest blog tagged on "SQL"

The demand for the SQL professionals who are also endowed with sharp analytical thinking skills which can be applied to SQL is never less....

 132 View(s)

Various differences between SQL and SQLite...

 843 View(s)

A trigger is a set of SQL statements stored in the database structure. A Trigger is a database object that is attached with the table in SQL.A SQL trigger is fired whenever an event or function associated with a table occurs .......

 677 View(s)

The Cursor is database object use for getting data and manipulating particular row at a time. It is associated with select query it processes each row returned by select query....

 973 View(s)

Delete command is used to delete all the rows from the table. If we use where clause then according to condition specific rows will be deleted....

 1090 View(s)

Primary key is a key that uniquely identifies a record in a table. It cannot accepts a null value. We cannot have multiple primary key in a table....

SQL 
 999 View(s)

Union and Union all both are use for combine the result-set of two of more select queries....

SQL 
 885 View(s)

Where clause is very important clause for filtering data .It search the records from the table according to the condition given in the where clause....

 1276 View(s)

Tempopary tables are created at runtimes and ability to perform all the operation like the normal table. These tables have limited scope. This table is stored in tempdb....

 2234 View(s)

In this blog, we are explaining about the basic of user defined function and difference between Inline table-valued function and Multi Statement Table-Valued Function....

 1141 View(s)

User Defined Functions play a major role in SQL. User Defined functions can be used to perform a complicated logic, can accept parameters and return data. Many a times we have to write complex logic which cannot be written using a single query....

 1053 View(s)

A view is a SQL statement which is stored in the database with a name. A view is actually a formation of a table in the form of a predefined Structured Query Language (SQL) query....

 1057 View(s)

Triggers are store procedure, which are automatically executed or fired when some events occur like deletion, insertion of data. Triggers are database object which is attached to a table and is executed automatically....

 1123 View(s)

Constraints are used to apply some rules for the record in a table. If any rule is violated between constraint and data, then the action is aborted by the constraint....

 1211 View(s)

In previous article we have discussed about SQL and some queries. In this part we will continue on SQL Queries:...

 953 View(s)

SQL stands for Structured Query Language. The structured query language is used to manipulate and access the databases. SQL is an ANSI (American National Standard Institute) standard....

 1040 View(s)

These functions return a single value, calculated from the values in the column.Scalar functions return a single value, based on input data. Following are the various types of scalar functions....

 1016 View(s)

In this blog, I’m explaining about cursor in SQL...

SQL 
 1709 View(s)