• Compare three SQL Server columns

    I have 3 tables table1 has the column id1 with three values in it '1','2','3' and table2 has column id2 with three values '3','4','5' and table3 has column id3 with three values '5','6','7'. How do I join all the three tables, and I also want the null value to be displayed. Please go through the...

    harish978920 pointsBadges:
  • What are the basic parameters needed to assist an automation tool?

    My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

    VijayVardhan5 pointsBadges:
  • Benchmark a SQL Server query

    Would there be a way I can benchmark a specific SQL Server query? I don't want to 3rd party tool either. Would SQL Profiler work for this?

    ITKE413,725 pointsBadges:
  • INSERT two SQL tables into new table

    I have two SQL tables and they're both pretty large. But now I have to combine all of their column names into a new table and, for some reason, I don't have permission to click on each table and choose CREATE to SCRIPT. So how can I go about doing this? Basically, how can I use INSERT both tables...

    ITKE413,725 pointsBadges:
  • Calculate overall sum of SQL Server database sizes

    In my SQL Server, I need to find out how much space my databases are using. I tried using sys.databases but it's giving me separate results and I have to put that into Microsoft Excel and do the math there. Can I do this using T-SQL? Thanks so much.

    ITKE413,725 pointsBadges:
  • Merge two SQL Server databases

    I have two SQL Server databases and they have the same schema. But both may have issues with the primary key in some tables (so I want to get rid of the duplicate rows). How can I merge these two databases? Appreciate any help available.

    ITKE413,725 pointsBadges:
  • Close existing connections on SQL Server database

    I'm trying to close all of my existing connections to SQL Server - I have to do a complete restore for my database. Here's what I tried so far: alter database YourDb set single_user with rollback immediate But I keep getting this message: Connection was not closed. What should I do?

    ITKE413,725 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

    ITKE413,725 pointsBadges:
  • Make SQL Server primary key AUTO INCREMENT

    In SQL Server, I have a database with a table and the primary key is titled 'ID'. Is there a way I can make it AUTO INCREMENT? Thanks so much.

    ITKE413,725 pointsBadges:
  • How to check if role exists in SQL Server database

    I need to add several users, in the same role, on multiple SQL Server databases. But that role can't be present too. How would I be able to check if an actual role exists in my database?

    ITKE413,725 pointsBadges:
  • Compare SQL Server and Oracle databases

    Our department currently has an SQL Server database and Oracle database. One of the tables is labeled 'Inventory' - which has thousands of rows from both databases and it will continue to grow over time. Now, here's what we need to do: We have to compare the Oracle data to the SQL Server data so we...

    ITKE413,725 pointsBadges:
  • Create foreign key in Oracle using ON UPDATE CASCADE

    I'm working with both Oracle and SQL Server. And in SQL, I created a foreign key with the ON UPDATE CASCADE option. So basically, whenever I update the column in the primary key - all of the other foreign keys (in tables) will be updated too. But I'm not sure how to do this in Oracle. Can someone...

    ITKE413,725 pointsBadges:
  • Change data path for existing SQL Server database

    My SQL Server has between 15-20 databases running on it. Now, because I'm running out of space, I'm looking to move my data path to another drive. How can I go about doing this? What SQL command should I use?

    ITKE413,725 pointsBadges:
  • How to get number of fields in SQL Server database

    Would I be able to get the number of fields in my SQL Server database with some sort of SQL statement? I'm talking about all the entries in my database. Thank you.

    ITKE413,725 pointsBadges:
  • How to create SQL Server database programmatically

    How can I go about creating a SQL Server database programmatically? I don't want to use SQL Server Management Object API. Is there another way to do it?

    ITKE413,725 pointsBadges:
  • Compare columns in two SQL Server tables

    I just did a SQL Server migration from an old version to the newest one but I've run into a few issues. Is there a query out there that could compare columns in two different tables? I have to compare the actual columns - not the data. Can someone help me?

    ITKE413,725 pointsBadges:
  • Error message when entering data into SQL Server database

    For the past few days, I've been trying to enter my data into my SQL Server database but I keep getting this error: Invalid column name. Is there any reason why I'm getting this error?

    ITKE413,725 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE413,725 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE413,725 pointsBadges:
  • Copy and rename SQL Server 2008 database

    We currently have a SQL Server 2008 database that needs to be copied and renamed as a new database. We're not too worried about losing data - it's a new database. Basically - we want to keep the same structure as the old database / set a new name to it. What's the best way to do this?

    ITKE413,725 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