• How to upload CSV file into SQL Server

    I have a very large CSV files and it needs to be uploaded into SQL Server using C#. How can I do that? It has thousands of rows / roughly 20-30 columns. Thanks so much.

    ITKE828,395 pointsBadges:
  • No tables available when importing CSV file into SQL Server database

    For the past few days, I've been trying and trying to import a CSV file so I can insert data into an existing database table. This is for SQL Server. Here's the issue: When I'm trying to select source tables / views for the destination, I don't see any at all. Nothing is coming up. It's basically...

    ITKE828,395 pointsBadges:
  • How to view content damaged MS SQL Server database?

    Help! Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the...

    hanamor11005 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE828,395 pointsBadges:
  • SQL database is crashed

    Hello, Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file. Is it...

    morrisonn5 pointsBadges:
  • How I can do a row ID in SQL Server

    Hi, excuse me, I want to do some ask for you. How I can do a row ID in SQL Server because I need a row ID CE517DED-7A39-48B0-85BD-73B95018FACB. Because in Oracle I know than this is possible, but in SQL Server, I don't know. I hope you can help me please.

    LuisFer5 pointsBadges:
  • Exporting VB6 data to PDF using SQL select query from MS Access

    Hi my name is vishal. I think I have a problem in exporting VB6 data to PDF using SQL select query (join query from multiple tables). I have a form in which when user selects a GRNno from combobox and then press button with caption: Generate it should generate a PDF report regarding GRNno. Given...

    Ametuer30 pointsBadges:
  • SSRS print button not showing in Firefox

    I'm currently using SSRS and it's working great but there's one issue - The print button is not showing in Firefox. It's showing in Internet Explorer but I don't want to use that. Can anyone help me out?

    ITKE828,395 pointsBadges:
  • Sending an email alert to addresses in the database and getting a return email as notification

    Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

    ADagoseh25 pointsBadges:
  • SQL query for customer’s data

    The owner of the shop would like to see each customer's id (name the column cus_id), name (name the column cus_name) id of their latest purchase (name the column latest_purchase_id) the total quantity of all flowers purchased by the customer, in all purchases, not just the last purchase (name the...

    Shruti16095 pointsBadges:
  • SQL Server statement

    The table name is students and the column name is ID contains 1 2 3 4 5 6 7 I want to know the statement should proceeding till 5 and it should be false at 6 and go to again 1 (i.e. without do while....and go...condition). Please!

    sabariram5 pointsBadges:
  • Stored procedure to transfer data in Oracle SQL Developer

    How can I write a stored procedure to transfer data from staging table to target table in Oracle SQL Developer? stagging table (stagcoindesk) to (coindesk) target table. Was thinking about this code: CREATE PROCEDURE YourProcedure AS TRUNCATE TABLE YourTable INSERT INTO YourTable SELECT * FROM...

    dreamersai5 pointsBadges:
  • Error message when creating a stored procedure: SPxxx is created but cannot be saved or restored

    I created a stored procedure on AS/400, the message in return was 'SPxxx is created but cannot be saved or restored '. I am able to view the created stored procedure in the Library but when I call the procedure the error message was 'SPxx was not found with specified parameters". How to resolve...

    bharathtata25 pointsBadges:
  • SQL database only with LDF file

    Is it possible to restore a SQL database with the latest ldf file because the MDF file is corrupted? I was hoping that data is still there. I actually have a backup of the MDF file of last month. But the MDF file this month is damaged, and the ldf file still normal. Can I use the. MDF file backup...

    ArturKis25 pointsBadges:
  • What are the best tools for SQL monitoring and SQL diagrams?

    we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

    Persa5 pointsBadges:
  • Export SQL Server to Microsoft Excel with column headers

    In SQL Server, I have a query that has roughly 20 columns and this needs to be exported to Microsoft Excel with the column headers. What's the process to do that? Thanks so much.

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

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

Following