• export the data from excel into a database

    Hi Is there a way to transfer the data in excel sheet into a table in any databse with the use of ODBC connection?

    Jacky160 pointsBadges:
  • Table storage settings at table creation time

    How can i set table storage settings at table creation time or any existing table

    Prashant.expert25 pointsBadges:
  • Get user input in MySQL query

    How can i get user input in any mysql query at runtime.

    Prashant.expert25 pointsBadges:
  • designing indexes

    I have a question regarding database design. Lets assume that there is a table with 10 columns. I don't have any single column which I can choose as candidate for Primary key. Though, combination of 5 columns can uniquely identify records. Here, I created an identity column as a PK and added UNIQUE...

    Sqloholic25 pointsBadges:
  • Federated Fabric cluster

    Can any one help me out on how to setup a federated fabric cluster using SQL 2005 + windows 2003

    Henrywat4885 pointsBadges:
  • A job to move database files from one server to different server

    Hi I have job which creates databases based on month in analysis services which contains cubes in the databases. I need to create a job to move the database ldf and mdf files of the previous months removing the database from the server if the month changes to next month. The database files should...

    GIG240 pointsBadges:
  • QMF for Windows

    How can I execute 10 sql at one go ?

    Jams5 pointsBadges:
  • LEFT JOIN depending on more conditions

    I'm not sure what says the ansi norm about this SELECT * FROM a LEFT JOIN b ON b.mast_id = a.id AND b.flag = 1. Is it possible (by the ansi norm) to use in "ON" condition more then one boolean expression? Like in this case condition compounded by two expressions? Of course, meaning by this that...

    Flopy5 pointsBadges:
  • Is there a way to make ODBC see SQL Server 2005 Synonyms

    I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.

    Randym1,740 pointsBadges:
  • Embedded SQL

    I need to get a grip on using the embedded SQL in an RPG ILE program using the word "CURRENT" and I need to know how this works (in laymens terms please.)

    Chinadoll04149810 pointsBadges:
  • Specific course for database administrator

    can u tell the name of the sap course for entering into database field,like database administrator or deveploer

    Raji5 pointsBadges:
  • Network Access Permission

    Network access problem description: • My network is a hybrid wired & wired mix, simple peer to peer • Purpose is shared internet access along with file & printer sharing • A single Router / modem connects to DSL • One computer connected to the router with a wired – Ethernet cable • The...

    Rgw5 pointsBadges:
  • MS Access IIF Statement

    I am pulling options from a table of "1", "2" or "3" and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below: =IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be...

    Jsweitzer15 pointsBadges:
  • SQL Server 2000 connection to multiple databases using variables

    I have a fairly simple select statement that joins three tables from two SQL Server 2000 databases. It works fine, but now I need to run the stored procedure against different servers, so my hardcoded reference to the second database (currently coded as "secondDB.tableName.columnName") needs to be...

    CO Bill120 pointsBadges:
  • Guest Access IAS policy

    I am trying to set up guest access of 802.11 wireless access points. My IAS policy puts domain computers into vlan1 and on the AP they show "Forwarding Allowed". I have set up a policy which recognises the mac address of my test guest and on the event log this is shown as a successful...

    Jrubinstein70 pointsBadges:
  • How can we startup our DB if any one redologs is corrupted totally 2 redologs

    how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode

    Kkvsaathish5 pointsBadges:
  • Analyzing Existing Indexes

    Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

    Sqloholic25 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • LSXODBC and MS-SQL Stored Procedure Parameters

    Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.

    Mzrn1x5 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 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