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

    ITKE435,940 pointsBadges:
  • How to connect SQL Server to Microsoft Excel

    I'm looking to connect several reports from my SQL Server database so several end users can view them. Would I be able to connect SQL Server to Microsoft Excel? Thank you very much.

    ITKE435,940 pointsBadges:
  • How to export SQL Server 2012 database with data

    Can I import my SQL Server 2012 database (including the data) to a .SQL file so I can import it into my 2008 server. For some reason, I've never been able to export the data. Only the structure goes through.

    ITKE435,940 pointsBadges:
  • SQL Server memory usage

    I have a situation where a total of 13 GB RAM is being used by SQL server. Is there any way I can break down the 13 GB usage by application?  Is there any data or technique which could be used?

    Cgardel30 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE435,940 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • SSIS Server Maintenance running 2 days

    My internal.operations table in the ssis db has over 600,000 rows. Before doing enough research, I changed the retention window and allowed the maintenance job to execute. The job is deleting approximately 10 records every 20 minutes. I want to stop the job; however, I'm afraid of what will happen....

    kmccourt03195 pointsBadges:
  • How to import MySQL database dump to SQL Server

    I currently have a SQL file that's from a MySQL dump. It contains a bunch of things including: Tables, definitions and all the data. Is there a way to convert all of this to a SQL Server database?

    ITKE435,940 pointsBadges:
  • SQL database rollback query

    How do I roll back in case the database changes all data to the same information?

    twatonny015 pointsBadges:
  • Migrate MySQL database to SQL Server

    My MySQL database is already full of data but I need to migrate it all over to SQL Server 2008. Is there a particular script / code I need to do this? I don't want to download any third-party software. Thanks!

    ITKE435,940 pointsBadges:
  • SQL Server: Remove foreign key

    On my SQL Server, I have to remove the foreign key from one of my tables so I can insert different values. What SQL query should I use for this? Thank you very much for your help.

    ITKE435,940 pointsBadges:
  • Restoring SQL Server 2008 database backup over my network

    Does anyone know how I can restore a SQL Server 2008 database backup over my network? Do I have to copy the file locally to the SQL Server? Thanks for the help.

    ITKE435,940 pointsBadges:
  • Compare two table schemas in SQL Server database

    Throughout my week, I have to do random checks between a SQL Server development and release database. Usually - this is a manual process but it's quite slow now. Would I be able to compare my different table schemas automatically? Thank you very much.

    ITKE435,940 pointsBadges:
  • Backup SQL Server 2008 database using C#

    How can I backup my SQL Server database (2008 edition) using C#? Is there a specific code I have to write? Can I use SQLConnection? Appreciate the help.

    ITKE435,940 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