Visit 'LiveWorld24.tk' for Live world..............

What is a View in SQL Server?

Explain DML, DDL, DCL and TCL statements with examples?

SQL Server 2008 Enterprise: A comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications. Unlock SQL Server 2008 Enterprise with the following key: MQWT2-9MKBY-K8PXQ-6K4BW-TY4BD.

SQL Server 2008 Standard: Complete data management and business intelligence platform, providing best-in-class ease of use and manageability for running departmental applications. Unlock SQL Server 2008 ...

setup a linked server to a remote Oracle database, which ended up being a multi-step process:

Install Oracle ODBC drivers on SQL Server.

Create System DSN to Oracle database on SQL Server.

Create linked server on SQL server using System DSN.

Step 1: Install Oracle ODBC drivers on server

a. Download the necessary Oracle Instant Client packages: Basic,...

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Text;

using System.Windows.Forms;

using Microsoft.SqlServer.Management.Smo;

using Microsoft.SqlServer.Management.Common;

using Microsoft.SqlServer.Ma...

 private void mprivDleteDB()

        {

            string mpristrSQL = string.Format("use master; drop database NET_ERP_REMS");

            OperationGateway.mpubiExecuteSQLStmt(mpristrSQL);

        }

using Excel = Microsoft.Office.Interop.Excel;

string Path = @"f:\ACC_LEDGER_TROYEE.xls";

            Excel.Application app = new Excel.Application();

            Excel.Workbook workBook = app.Workbooks.Open(Path, 0, false, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

       ...

 int row = 2;

            string Path = @"f:\ACC_LEDGER_TROYEE.xls";

            Excel.Application app = new Excel.Application();

            Excel.Workbook workBook = app.Workbooks.Open(Path, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

   &#...

 int row = 2;

            string Path = @"f:\ACC_LEDGER_TROYEE.xls";

            Excel.Application app = new Excel.Application();

            Excel.Workbook workBook = app.Workbooks.Open(Path, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

   &#...

 private void mpriiInsertIntoImage()

        {

            // int liReturnValue = -1;

            try

            {

                if (DatabaseConnector.gmpubstasqlconnSQLConnection.Stat...