• 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:
  • 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 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:
  • 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:
  • 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,079,435 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:
  • Test “SQL Injection” in mobile app for login the app using mobile number and password

    Is this any possible to test "SQL Injection" in mobile app for login the app using mobile number and password?

    Parkavi5 pointsBadges:
  • Cannot create audit in SQL Server 2012

    I'm currently a DB_owner user in our SQL Server 2012. I need to create an audit but I keep getting this error message: User does not have permission to perform this action What should I do? Thank you.

    ITKE1,079,435 pointsBadges:
  • Change column from VARCHAR to NVARCHAR in SQL Server

    Would it be possible for me to change a SQL Server column from VARCHAR to a NVARCHAR? Is there a specific SQL command to do this?

    ITKE1,079,435 pointsBadges:
  • How to run SSMS on MacOS

    So from what I've heard from colleagues, SQL Server 2016 can run on a MacOS. But I need to make sure that I can use SQL Server Management Studio too. Can I run that on a MacOS? Thank you.

    ITKE1,079,435 pointsBadges:
  • DB2 hex values in SQL causing problem

    Ok here's one I cannot figure out. Here are the PO#s that show in our green screen software and they look fine     5-824101 S1079682 33­-548504­-D RMA 001904          REASON CODE 11  8075-089          1V 76139-6200        88   But if I write a SQL to extract them the PO#...

    ToddN2000105,495 pointsBadges:
  • Track data from SQL Server 2005 in Visual Studio

    How can I track data from SQL Server 2005 in Visual Studio?

    friska9075 pointsBadges:
  • Set DataTable name in returned data set

    I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset.  The stored procedure is being called from C#/.NET code.  The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,...  when the dataset is...

    LordPerrin15 pointsBadges:
  • Error message in Reporting Services on SQL Server

    I am trying to post a report on Reporting Services on SQL Server, but I keep receiving this error message (“salesexpo1” is the name of the table): An error has occurred during report processing. Query execution failed for data set 'rSellingEP_AV'. Invalid object name 'Saleexpo1'. What might...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Cannot create local SQL Server

    I'm trying to create a local SQL Server using the SQL Configuration Manager. But I keep getting this error message: Cannot connect to to WMI provider. You do not have permission or the server is unreachable. Any thoughts what I should do here?

    ITKE1,079,435 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