-
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?
Last updated: -
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?
Last updated: -
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...
Last updated: -
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!
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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?
Last updated: -
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.
Last updated: -
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.
Last updated: -
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.
Last updated: -
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?
Last updated: -
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Last updated: -
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....
Last updated: -
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?
Last updated: -
How do I roll back in case the database changes all data to the same information?
Last updated: -
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!
Last updated: -
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.
Last updated: -
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.
Last updated: -
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.
Last updated: