Exception handling in SQL Server
In SQL Server TRY..CATCH statement which helps us to handle the errors effectively in the back end. This handling of the exception can provide additio
Copying, Merging and/or Uniting Records In SQL Server
Some time we have a situation to copy a set of rows of a Table 'A' into the Table ‘B’, it means suppose if we have thousand of records in a table ‘A’ and I created another table ‘B’ to maintain data but records is available in table ‘A’
Aggregate function in SQL Server
SQL aggregate functions are used to sum, count, get the average, get the minimum and get the maximum values from a column or from a sub-set of column values. SQL aggregate functions return a single value, calculated from values in a column.
Conjunctions and Dis-junctions in SQL Server
Conjunctions and Disjunctions in SQL ServerThe ConjunctionsBasically the logical conjunction is used to check that two conditions are true, in logic
How to create table in SQL Server
As a user, you need to create tables to store data in database. While creating the tables in database, you have to follow specify certain rules and constraints for columns that specify the kind of data to be stored.
What is Normalization?
Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependencies make sense. Both of these are worthy goals as they reduce the amoun
Denormalization in SQL Server
What is Denormalization?The intentional introduce of redundancy in a table in order to improve performance is called“Denormalization”. Denormalizati
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.