Category Archives: SQL Concepts

Triggers are the database objects which fire on some event on table or view to perform some specific task. Triggers are used of three types in terms of language statements and these are DDL, DML and LOGON triggers. DDL – … Continue reading →

As per the definition given by the various books and sites UDF are the database objects which user can create for computation or to get some specific result set on the basis of input parameters. Just like stored procedure udf … Continue reading →

Stored procedure is the batch of SQL statements which used to perform some specific business task. In Stored procedures the tasks are written as a bunch of SQL Statements which performs some specific task and combined perform business logic. Different … Continue reading →

Cursors are used for data to fetch the data from database and then performing row base operation. Cursors fetches data with select statement and then performs operation on each row while loop. This operation can also be performed by using … Continue reading →

What are Joins in SQL Server   Joins is the functionality introduced in SQL server 2005. Joins are used to map two relative tables with relational key between them. What are the different types of joins in SQL Server? 1.              Inner … Continue reading →

Sql Server 2005 is the database server having:Database EngineReporting ServiceIntegration ServiceAnalysis ServiceIt is a full pacakge where it be used for database engine and can be used as the Business intelligence solutions.