Latest blog tagged on "SQL Server"

Is VPS hosting a worthy decision?

A VPS server is produced through the route of virtualization. It is a server for hosting “websites (e-commerce, content, media, etc.) and/or software applications, particularly web-based ones (portals, extranet, collaborative solutions, wiki, CRM so...

 176 View(s)

WHAT ARE TRIGGERS?

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 .......

 875 View(s)

Cursor in Sql server database

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....

 1115 View(s)

User Define function in Sql Server

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....

 1202 View(s)

View in SQL

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....

 1243 View(s)

Trigger In SQL

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....

 1305 View(s)

SQL Functions

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....

 1183 View(s)

SQL Joins

In this blog, I’m explaining about joins in SQL SQL joins are used to combine rows from two  or more tables.Types of joins1 .Inner joins2. Outer join...

 2059 View(s)

Indexes in SQL

In this blog, I’m explaining about Indexes in SQL Indexes  are created on columns in tables or views. The index provides a fast way to look up data b...

 2097 View(s)

Constraints in SQL

In this blog, I’m explaining about constraints in SQL.Description: SQL constraints are used to restrict the type of data that can insert into a databa...

 2380 View(s)

Triggers in SQL

In this blog, I’m explaining about triggers in SQL Triggers are database object. Basically these are special  type of store procedure that are automa...

 1895 View(s)

Store Procedure in SQL

In this blog, I’m explaining about store procedure  in .Net A store procedure is a group of SQL statements that has been created and stored in databa...

 1538 View(s)