tag
home / developersection / tag
Table-Valued Functions in SQL Server
A table-valued function is a user-defined function that can be used where views or table expressions are allowed in T-SQL. A user-defined function c
Transaction in SQL Server
In SQL Server we can implement transaction to ensure data integrity. In a multiuser situation, may be multiple transaction try to accessing the same r
Trigger in SQL Server
A Trigger is a special kind of stored procedure that is invoked whenever data in the underlying table is affected by any of the Data Manipulation Language (DML) statements -INSERT, UPDATE OR DELETE or Data Definition Language (DDL).
Stored Procedure in SQL Server
A Stored Procedure is a precompiled object stored in the database. Stored procedures can invoke the Data Definition Language (DDL) and Data Manipulati
Joins in SQL Server
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between columns on table. A JOIN is a means for combining fields from two tables by using values common to each.
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