OLAP

Posted by imomins on March 30, 2011 at 12:56 AM Comments comments (0)

OLAP

Online analytical processing (OLAP) allows the user to access aggregated and organized data from business data sources, such as data warehouses, in a multidimensional structure called a cube. Microsoft provides tools and features for OLAP that user can use to design, deploy, and maintain cubes and other supporting objects.

Cubes in a data warehouse are stored in three different modes. A relational storage model is called Relational Online Analytical Processing mode or ROLAP, ...

Read Full Post »

What are the differences between stored procedure and functions in SQL Server 2000?

Posted by imomins on March 30, 2011 at 12:53 AM Comments comments (0)

1) functions are used for computations where as procedures

can be used for performing business logic

 


2) functions MUST return a value, procedures need not be.

 


4) function parameters are always IN, no OUT is possible

2. EXEC command can't be used inside a Function where it

can be used inside an sproc.



a. A FUNCTION is always returns a value using the return

statement. A PROCE...

Read Full Post »

Database Existence Checking

Posted by imomins on March 29, 2011 at 12:43 AM Comments comments (0)

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using net.ERP.Constants;

using System.Data;

using System.Data.Sql;

using System.Data.SqlClient;

using System.Windows.Forms;

 

namespace net.ERP.DatabaseSchema.DBExistanceChecking

{

    class DatabaseExistanceChecking:CommonConstants

    {

        public boo...

Read Full Post »

Blank Database Creation

Posted by imomins on March 29, 2011 at 12:41 AM Comments comments (0)

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.Sql;

using System.Data.SqlClient;

using System.Windows.Forms;

using net.ERP.Constants;

 

namespace net.ERP.DatabaseSchema.DatabaseCreationForServer

{

    class BlankDatabaseCreation:CommonConstants

    {

        public v...

Read Full Post »

Database Connector

Posted by imomins on March 29, 2011 at 12:39 AM Comments comments (0)

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using net.ERP.Constants;

using System.Windows.Forms;

using System.Data.SqlClient;

 

namespace net.ERP.Utility

{

    class DatabaseConnector:CommonConstants

    {

        private string mpristrDBConnectionString = null;

        p...

Read Full Post »