tag
home / developersection / tag
Constraint in SQL Server
What is Constraint?The concept of a constraint is to enforce a rule in the database. Together, the constraints in a database maintain the integrity of
Working with Views in Database
Whenever you want to provide different types of restriction to different user such as different-2 users can see different records in same table then we can use the concept of views. Views can help in simplifying query execution when the query involve
Implementing Triggers in Sql Server
When we want to resolve concurrency issue in database we can use concept of triggers. In Sql server various kinds of triggers can be used for different types of data manipulation operations. The Sql server supports the following types of triggers.
Implementing Stored Procedure
Stored procedures are defined as precompiled object stored in a database. Here I had mentioned precompiled object that means such type of entity which is compiled and after compilation the form that we get is stored in database.
Implementing Concept of Cursor in SQL Server
A Cursor is a database object that represents a result set and is used to manipulate data row by row. When a cursor is opened, it is positioned on a row and that row is available for processing.
Triggers in SQL Server
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The t
View in SQL Server
A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables. Based on this, before creating a view, you must first decide where its columns and records
Join in SQL Server
JOIN is used whenever we have to select data from two or more tables. To be able to use JOIN to extract data from we need a relationship between certain columns in the tables.
Stored Procedure in Microsoft SQL Server
Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a com
Create Table in Microsoft SQL Server
Syntax to create table in MSSQl Server2008CREATE TABLE table [name]( Column1 Column2 Column3ExampleCustomers is the name of table.CREATE TABLE Cu