SQL Server Interview Questions/Answers Part-2

Posted by imomins on April 3, 2013 at 5:45 AM Comments comments (0)

What is a View in SQL Server?

Read Full Post »

SQL Server Interview Questions/Answers Part-1

Posted by imomins on April 3, 2013 at 5:40 AM Comments comments (0)

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

Read Full Post »

Seria Key Of SQL Server

Posted by imomins on September 19, 2012 at 12:25 AM Comments comments (0)

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 ...

Read Full Post »

How do you setup a linked server to an Oracle database on SQL

Posted by imomins on July 26, 2011 at 8:05 AM Comments comments (0)

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,...

Read Full Post »

Dtabase Restore And Backup in C#

Posted by imomins on May 12, 2011 at 8:45 AM Comments comments (0)

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...

Read Full Post »

Drop Database Using C#

Posted by imomins on May 12, 2011 at 7:57 AM Comments comments (0)

 private void mprivDleteDB()

        {

 

 

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

            OperationGateway.mpubiExecuteSQLStmt(mpristrSQL);

 

        }

 


Import Data from EXCEL TO SQL

Posted by imomins on May 12, 2011 at 7:46 AM Comments comments (0)

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);

       ...

Read Full Post »

Export Excel to SQL Databse Using Csharp

Posted by imomins on May 12, 2011 at 6:32 AM Comments comments (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);

   &#...

Read Full Post »

Export Excel to SQL Databse Using Csharp

Posted by imomins on May 12, 2011 at 6:32 AM Comments comments (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);

   &#...

Read Full Post »

Inserting And Retrieve Image

Posted by imomins on April 5, 2011 at 2:17 AM Comments comments (0)

 private void mpriiInsertIntoImage()

        {

            // int liReturnValue = -1;

            try

            {

                if (DatabaseConnector.gmpubstasqlconnSQLConnection.Stat...

Read Full Post »