• Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE351,865 pointsBadges:
  • Free Centralize backup solution

    Hi, anyone has idea of any freeware centralize backup solution or low cost best centralize backup solution. i have 12 lcoations with File and print servers. SQl server Database server 2 web serevrs 1 Domain controller i want to backup the files at my central IDC. locations backup has only Excel,...

    Thmohan50 pointsBadges:
  • VB.NET – Can’t insert data into database.

    I used insert command it worked successfully that your data has updated.But it is not showing in the database. Please look in the below code and tell me where I'm wrong: Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

    Shaz255 pointsBadges:
  • Convert from MS Access to SQL 2005

    SELECT Format(DTrans.DATE,'dd/mmm/yyyy') AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, 'By ' & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, '' , DTrans.AMOUNT, dtrans.craCCODE AS accode,...

    Radhikanutalapati5 pointsBadges:
  • Consolidating SQL Server databases

    How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting VB 2008 to SQL Server2005

    How to connect VB2008 with SQLServer2005 through coding. Not through OleDBAdaptar. Also Let me know the code for Add,Edit, Delete & Save in VB2008

    Ishita20095 pointsBadges:
  • Backup Performance Compare

    How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

    Michael Tidmarsh33,105 pointsBadges:
  • How to use databases made in Access or Excel in SQL

    How can I use databases made in Access or Excel in SQL? I'm trying to import readymade databases in SQL.

    Dragan1525 pointsBadges:
  • How to use INSERT or UPDATE on SQL Server

    In our SQL Server database, we have a table structure like this: MyTable(KEY, datafield1, datafield2...) Sometimes, we need to either update an existing record or just insert a new one if you doesn't exist. Basically, this is what we want to run: IF (key exists) run update command ELSE run insert...

    ITKE351,865 pointsBadges:
  • Deciding on a RAID Level for a 64-bit SQL Server 2005

    I need to install SQL Server 2005 (64-bit) on two new servers, but these servers have only four hard disks with 500GB each. From what I understand, all my operating systems, data and log files will reside on these four disks. I have two choices: to use RAID Level 1 or Level 1 +0. Which RAID level...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server: Selecting the first row in a GROUP BY group

    I'm trying to select the first row of each set of rows grouped with a "GROUP BY" in a SQL Server database. Here's what my table looks like: > SELECT * FROM purchases: id | customer | total 1 | Joe | 5 2 | Sally | 3 3 | Joe | 2 4 | Sally | 1 So, now I'm trying to query the "ID of the largest...

    ITKE351,865 pointsBadges:
  • Extracting information with a DTS package from a database in SQL Server 2000

    We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Experience applying SP4 to SQL 2005?

    Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I...

    CarlMarius15 pointsBadges:
  • SQL Database is corrupted

    Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.

    shampur5 pointsBadges:
  • How do I save pictures in database VB.NET

    I'm using SQL Express to develop application which have I pictures so I can try how a save picture inside database and loading VB picture box. Can anyone tell me please? How do I do this?

    12345678900110 pointsBadges:
  • Is it possible to randomly select rows in a SQL Server database?

    I've been using SQL Server 2005 and in my database, I have a table labeled "customerNames" which has two different columns (ID and name). It has around 1,000 results. I've been trying to create a function that allows me the capability to select five different customers randomly every time. Would...

    ITKE351,865 pointsBadges:
  • Pulling a list of triggers in a SQL Server database

    I'm trying to get a list of triggers in a SQL Server database with the table name and the table's schema. Here's what I have so far: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id,...

    ITKE351,865 pointsBadges:
  • Indexes and abstracts in SQL Server

    In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible to replace a string in a SQL Server table?

    We have a SQL Server table which references different paths (UNC or otherwise) but we've just found out that the path is going to change. In our path column, we have many records and we need to change a portion of the path (not the entire thing). We also have to change the string to the new one as...

    ITKE351,865 pointsBadges:
  • Create credential

    I need to create a credential,and a proxy for my Jr. dba to support and troubleshoot production SSIS and SQL jobs. I want to create a credential/proxy that follows best practice and can be implemented as a standard across environments. Can you give me an example of a credential that has sufficient...

    Maura d'ae0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following