Showing posts with the label SQL queries

MySql Commands Names

Here are listed the most commonly used MYSQL Statements and clauses , mysql commands ALTER DATAB…

MySql Commands

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements…

Populate List Data

METHOD 1: Without any datasource control Imports System.Data.OleDb Partial Class _Default …

SQL Server - Aggregate Functions

Aggregate functions will find out a calculation process on a collection of values and return a re…

Stored Procedure best practices

A stored procedure is a named and precompiled set of SQL statements and procedural logic that is …

Database Security :

Designing Instance-level Security A]. Configuring Service Account : (1) In SQL Server 2005, when…

Cache object in ASP.NET designs

An effective caching strategy is a key element of any application design. It increases performance…

That is All