1
  • I want to load XML to a table in SQL Server 2005

    i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

    Mitha10 pointsBadges:
  • Import CSV file to SQL Server 2012

    I'm looking to import roughly 10,000 rows (this is from a CVS file) into an existing SQL Server 2012 table. I only have 1 column to import but there's another table in my column titled "TypeID". For this column, I need to set a static value like this: 99E05902-1F68-4B1A-BC66-A143BFF19E37INSERT INTO...

    ITKE350,300 pointsBadges:
  • Exporting SQL Server 2005 database to SQL Server 2008

    This is more a basic question but is it possible to import (or migrate) SQL Server 2005 databases to SQL Server 2008? Or can I have 2005 and 2008 running on the same machine (without any complications)?

    ITKE350,300 pointsBadges:
  • Error when translating execute immediate from Oracle to SQL

    SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(...) statement,...

    Ariel5 pointsBadges:
  • DBFs into SQL Server 2008

    Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the "import into Access, then import the Access files into SQL server-method")? I don't work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once a...

    ITKE350,300 pointsBadges:
  • Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

    hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue. when...

    Sagar20005 pointsBadges:
  • Transferring SQL 7 DB to SQL 2005 DB

    Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me thru this pls. Thanks, Bert

    Bertski40 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

    VBNET5 pointsBadges:
  • How to upload data from Excel into SQL Server 2005

    hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

    Ambrish 82310 pointsBadges:
  • Updating Microsoft SQL Server tables from Oracle generates error

    i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

    Balecha10 pointsBadges:
  • Is it possible to copy system DBs to another server?

    Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

    Db23290 pointsBadges:
  • Creating XML file using SQL Server 2005

    How to create a xml file using sql server 2005? what are all the steps to do for this?

    Sunithashree5 pointsBadges:
  • For Save .doc file in Sql Server 2000

    I want to Save Word File in SQl Server, how it is possible

    Karankhandelwal5 pointsBadges:
  • Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format

    i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

    Mitha10 pointsBadges:
  • Saving Query results into Excel format

    How can I save query results into .xls format directly from Microsoft SQL server Management studio?

    Preetg5 pointsBadges:
  • Oracle to SQL Server Migration – User Defined data types

    Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

    Kumar937825 pointsBadges:
  • Oracle to SQL Server Migration – CURSOR type conversion

    When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

    Kumar937825 pointsBadges:
  • SQL 2005 to .XML

    How do I automate 2 sql servers to replicate .xml files

    Camofa5 pointsBadges:
  • xml create form sql database

    i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file

    111111222225 pointsBadges:
1

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