• 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,087,360 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,087,360 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,087,360 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,087,360 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:
  • Cannot connect to SSMS 2017 database

    I'm trying to connect to SSMS 2017 database from my Windows 10 machine but I can't at all. I've uninstalled / reinstalled SSMS but that didn't help. Nothing changed in my security settings (antivirus). Here's the error message I'm getting: A network-related or instance-specific error occurred while...

    ITKE1,087,360 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 pointsBadges:
  • How to disable auto audentity of a DB2/400 table

    Hello, For a migration data project (from SQL/Server to DB2/400), we need to disable the auto identifiers of a DB2/400 table. On SQL Server, the equivalent command is "set identity_insert MyTable off". Thank you in advance JC Cherid

    TheWorldAsGarp5 pointsBadges:
  • Execution plan cost checking in SQL Server 2012

    How can I analyze SQL Server Execution plan in that cost percentage (need more clarification for physical operation, logical operation, CPU cost)?

    kowshi5 pointsBadges:
  • SQL Server 2008 Setup has stopped working

    Why has my SQL Server 2008 Setup has stopped working?

    SahilPasha35 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