tag
home / developersection / tag
Checkpoint in Database
The CHECKPOINT statement saves time in a subsequent recovery by creating a point at which all modifications to data and log pages are guaranteed to ha
Job in Database
SQL Server has some functionality that can make more dependable in the long run: SQL Server jobs. A SQL Server job is a collection of steps executed
Date and Time function in SQL Server
In SQL Server, the following date and time function are used: Dateadd()It is used to add an interval to a date.Syntax:DATEADD (datepart, number, expr
Triggers in Database
A database trigger is a stored procedure that is invoked automatically when a predefined event occurs. check this article ... http://www.mindst
Indexes in SQL Server
Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quicker. Indexes are of two types. Clustered index
Subqueries in Database
A sub-query is a query embedded in another query. The subquery can be embedded in another SELECT, INSERT, UPDATE, or DELETE statement,or inside anothe
Creating and Using Stored Procedure
Using Stored ProceduresStored procedures are an important aspect in all database programs. VB.NET applications are no exceptions to this rule. Stored
Difference Between Function and Stored Procedure
1. A function is a subprogram written to perform certain computations and return a single value. 2. Functions must return a value (using the RETURN
Aggregate functions in Database
Aggregate functions are applied to agroup of data values from a column. Aggregate functions always return a singlevalue.How database supports followin