Jan 20
YouTube Converter
This class provides a fast and universal method for accessing SQL Server database.
Create Instance
At first you create an instance of SqlDatabase class.
Dim sqldb As New SqlDatabase("Data Source=(local); Initial Catalog= ; UId = ; Pwd = ;")
For more information about connection strings, visit ConnectionStrings.com.
ExecuteNonQuery Method
Executes a Transact-SQL...
Jan 19
YouTube ConverterThis class is for simplifying and accelerating working with SQL,
using this class is very simple; there is a sample below for this class,
which I hope is useful. You can report bugs, opinions and suggestions to me.
<<DONWLOAD>> << dataAccess.vb >>
Imports System
Imports System.IO
Imports System.Text
Imports System.Data
Imports...
Jan 18
YouTube ConverterWITH set [Male] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “M”)’
set [Female] AS ‘Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties(“GENDER”)= “F”)’
member Customer.AggMale as ‘Aggregate([Male])
member...
Jan 06
YouTube ConverterRecently, we’ve jumped into the world of multi-dimensional OLAP. We’re currently using SQL Server Analysis Services which has been great to create the data cubes and Microsoft Sharepoint with Business Scorecard Manager to render the cubes. The database and cube work wonderfully. We have had issues with Scorecard Manager 2005 though (namingly, it...
Feb 01
YouTube ConverterThe CODE
This article is based on SQL Server 2008 CTP 3. Some of the information may change by the time the product is finally released.
Before we create a Function or Stored Procedure that accepts a TABLE variable, we need to define a User Defined TABLE Type. SQL Server 2008 introduced a new User defined TABLE type. A TABLE type represents the structure of a table...
Dec 11
YouTube ConverterEnterprise Project Management (EPM), dalam hal luas, adalah bidang pengembangan organisasi yang mendukung organisasi dalam mengelola dan integrally beradaptasi sendiri untuk perubahan dari transformasi.
Dalam beberapa tahun terakhir, dengan adopsi umum (TI) praktek pemerintahan, Enterprise Manajemen Proyek telah menjadi lebih spesifik: sedangkan di tahun 1990-an...