category
home / developersection / category
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