• Execute SQL Server Procedure from the iSeries

    I have an internal web address for a SQL Server application, where they want to run an iSeries stored procedure to connect to the SQL Server, call a SQL Server Stored Procedure, and receive resulting values back to the iSeries. Is this possible?

    sonorato15 pointsBadges:
  • Compound keys, anyone?

    In many cases, you have to join individually non unique keys that together, are unique and can be used as primary keys.

    amissor55 pointsBadges:
  • How to use LDF file

    What is the purpose and how can we see transactions made database using this file?

    steel10105 pointsBadges:
  • Unable to connect to voyager SQL Server instance

    I am installing Voyager2017patch10 but I'm getting this error: Unable to connect to voyager SQL server instance, while the server is running. So ,what is probably causing this error and what possible solution.

    EMMY485 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • Delete duplicate records in MySQL database

    One of our clients asked us to delete duplicate records in a SQL Server database and a MySQL database. We did it in SQL but MySQL is giving us issues. It says the format of the query is not correct. Does anyone know of a way to do this? Thank you so much!D

    ITKE1,127,730 pointsBadges:
  • Cannot export database from Microsoft Access to SQL Server

    I have to export a database from Microsoft Access to SQL Server. Here's the issue: When there's attached files, I can't export it because SQL does not recognize it. Any other ideas on how to export this?

    ITKE1,127,730 pointsBadges:
  • SQL database page level corruption

    Hello Experts, We are facing page level corruption in SQL database. The database size is 650 GB. What should we do?

    DBAPriya30 pointsBadges:
  • Starting a career as SQL database developer

    I recently have finished my btech 3rd yr via cse. I am quite interested in SQL so I want to be a SQL database developer. So please guide me in what other languages I should learn and what other skills I should learn too.

    Rajiv62535 pointsBadges:
  • How to restore a SQL Server 2000 database using a backup

    Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software (.NET application) and SQL Server 2000 back end. We run the backup before any major change to the database.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Can any one post IKM online test questions (SQL Server 2008) please?

    IKM online test questions SQL Server 2008.

    IKMsql1235 pointsBadges:
  • Code for bulk insert and upload data of EMD File in SQL Server

    Can someone please provide me the stored procedure for bulk insert EMD File in SQL Server?

    HIREKHAN5 pointsBadges:
  • Cannot connect from Access 2016 to SQL Server

    Hello, I'm trying connect from Microsoft Access 2016 to SQL Server though ODBC connection. But I keep getting this error message: The SSPI context can not be generated. What does that mean? How can I fix it? Thanks so much.

    ITKE1,127,730 pointsBadges:
  • SQL function value is null

    We needed a change recently as more shipments going international. I needed to make changes to our function to return the new motor prefixes. The old worked fine as if it was not US or CA we used XX to show international. We had just the three country values. Now each country has it's own code and...

    ITKE1,127,730 pointsBadges:
  • Overnight performance metrics

    Should the overnight performance roll into the whole day's results?  We staff overnight for customer satisfaction.  The inbound calls are low/sporadic, and sometimes impacts the day's results.  Overnight is not a priority right now.  It is my belief that we should report the overnight results...

    adbrown35 pointsBadges:
  • T-SQL: Find the first and last date (+1) for each price change

    I have a table of price and date like: Price Date 3.20000000 2018-01-14 3.20000000 2018-01-18 3.20000000 2018-01-19 4.00000000 2018-02-10 4.00000000 2018-02-11 4.00000000 2018-02-12 5.10000000 2018-02-16 3.20000000 2018-03-11 4.00000000 2018-03-15   I wish to get the first date for every time the...

    modan20185 pointsBadges:
  • SQL Server Store Procedure

    How I get the list of data while I add a stored procedure for the database table. While I'm writing a stored procedure I'm writing a two table is writing in the single stored procedure using their ID, but I don't know how to take the another table data in a list type.

    Meiyalaghan5 pointsBadges:
  • Notrix and ODBC

    Getting 'server not found' error trying to connect to SQL Server 2012 using MS ODBC Driver, version 10 using Notrix SQL API, Version 7.0. Never had a problem like this before

    rblanford5 pointsBadges:
  • How to run this SQL

    Display Product Id (obtained by replacing ‘PR’ into ‘Product ’ of ProductId), Product Name (obtained from product name in uppercase format), MaterialName, and Average Product Purchased (obtained from average quantity of product purchased) for product which price is more than 20000 and...

    agung31095 pointsBadges:
  • Could You Prevent SQL Injection In 1 second?

    Does everybody now how to prevent SQL injection in 1 second or auto disable SQL injection to improve security? Thank you!

    akuadauntukmu25 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