• 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.

    ITKE440,495 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.

    ITKE440,495 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.

    ITKE440,495 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?

    ITKE440,495 pointsBadges:
  • Will streaming media work in a motorhome?

    I am new to Streaming.  A couple of questions.  How are my computers, VCR, and TV connected to the provider.  We are planning to buy a motorhome and need to know if this is a good solution to use on the road? Rex Ralston netrex@aol.com

    Rnetrex20045 pointsBadges:
  • Do Businesses still need SQL Server?

    With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

    ITKE440,495 pointsBadges:
  • Easy way to identify DB file for specific data on screen (AS/400)

    I am trying to identify where a specific line of data is coming from when I am in a session. I've tried Shift+ESC+3+14, and all I get are active DB files. Is there a way to focus the search to one specific line of data and identify the source DB?

    mssanwo15 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 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:
  • Avoid read locks on SQL database

    For my SQL database, how can I avoid read locks? Should I use a SQL statement for this? Thank you!

    ITKE440,495 pointsBadges:
  • MongoDB: Auto-incrementing primary ID

    In MySQL - I was able to add an incrementing ID. But I still can't figure out how to do it in my other database (I'm using MongoDB). What's the process to do that?

    ITKE440,495 pointsBadges:
  • Cloud-based CRM Software for customer’s database

    I need to develop a customer’s database for clients. Can anyone recommend any Cloud-based CRM software for small business (Customer Relationship Management) that improves relation with new and existing customers? I know there is something to manage newsletters, few mail accounts, social media...

    darrenhayes7815 pointsBadges:
  • Remove numeric characters from MySQL string column

    In MySQL, is there a way for me to remove all the numeric characters from the string (in a column)? Thanks so much

    ITKE440,495 pointsBadges:
  • DATABASE FoxPro 2.6

    How to recover a damaged database file in Foxpro

    Prabhakaran20095 pointsBadges:
  • Reset MySQL stop words for full text search

    For MySQL, can I reset the stop word list for full text search? WAMP Server is already installed so that phpMyAdmin allows me access to MySQL. But I can't figure out how to reset it. What's the process?

    ITKE440,495 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.

    ITKE440,495 pointsBadges:
  • Exporting PostgreSQL database schema to XML format

    How can I go about exporting my PostgreSQL database schema to an XML format? Is there a certain code I have to use or a tool? Thank you.

    ITKE440,495 pointsBadges:
  • Store binary and image files in a database

    Does anyone know the best way for me to store binary / image files in a database? Also - I'm using SQL. Thanks!

    ITKE440,495 pointsBadges:
  • Change MongoDB database name

    Does anyone know of a way to change the database name in MongoDB? I can't find how to do it anywhere. Also, I don't want to change the entire database - just the name.

    ITKE440,495 pointsBadges:
  • Store .TXT files to MySQL server

    Would I be able to store files (TXT files) to my MySQL server? Is there a code for this? I appreciate the help.

    ITKE440,495 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.