Latest blog tagged on "SQL Server"

  • Oracle Data Integrator University Training

    You get many benefits by Investing in Oracle Training. Millions of professionals around the world take online Training by Oracle University. That is every course is Designed for maximizing your thinking....

 52 View(s)
  • 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...

 79 View(s)
 175 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 .......

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

 1023 View(s)
 2417 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....

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

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

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

 1080 View(s)
 4603 View(s)
 29346 View(s)
 5770 View(s)
  • In this blog, I’m explaining about joins in SQL...

 1932 View(s)
  • In this blog, I’m explaining about Indexes in SQL...

 1988 View(s)
 2242 View(s)
 1789 View(s)
 1449 View(s)