• Is it possible to randomly select rows in a SQL Server database?

    I've been using SQL Server 2005 and in my database, I have a table labeled "customerNames" which has two different columns (ID and name). It has around 1,000 results. I've been trying to create a function that allows me the capability to select five different customers randomly every time. Would...

    ITKE352,395 pointsBadges:
  • Pulling a list of triggers in a SQL Server database

    I'm trying to get a list of triggers in a SQL Server database with the table name and the table's schema. Here's what I have so far: SELECT trigger_name = name, trigger_owner = USER_NAME(uid),table_schema = , table_name = OBJECT_NAME(parent_obj), isupdate = OBJECTPROPERTY( id,...

    ITKE352,395 pointsBadges:
  • How to create a database table from XSD files

    I have a bunch of XSD files (from which I get data access classes, stored procedures, among other things). But now I need to generate a database table from these and I don't know how. Anyone know of a tool than can generate DDL statements? I would appreciate some help.

    ITKE352,395 pointsBadges:
  • odbc as/400 connect to mysql

    I am trying to figure out how to get data from the as/400 into mysql

    Sunnyday25 pointsBadges:
  • Export flat file data as .txt

    I have data in a flat file that I want to send to an external server in text file format. How can I do this within a RPGLE or CL program?

    LarryL707830 pointsBadges:
  • Access Forms

    Can information appear on a form based on information on a table? I have information on a table that I want to appear on a form, but I want the info to change on the form based on a change made in the table. EG I have a person down on a rota as doing an overnight, the name will change each night,...

    quinny5 pointsBadges:
  • Indexes and abstracts in SQL Server

    In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error 2282 in Microsoft Access

    Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

    Pmallick5 pointsBadges:
  • Is it possible to replace a string in a SQL Server table?

    We have a SQL Server table which references different paths (UNC or otherwise) but we've just found out that the path is going to change. In our path column, we have many records and we need to change a portion of the path (not the entire thing). We also have to change the string to the new one as...

    ITKE352,395 pointsBadges:
  • auto send e-mail

    How does one auto send e-mail from access

    Mabaxter5 pointsBadges:
  • Storing GPS coordinates in a MySQL database

    We have a MySQL database that carries both longitude and latitude (GPS data). Here's how it's stored: column type ------------------------ geolat decimal(10,6) geolng decimal(10,6) Here's our question: Do we really need a data type that's large as "decimal(10.6)" to properly store the data?

    ITKE352,395 pointsBadges:
  • How to connect and query C# records to a database

    I have a set of records in C# and I need a way to connect and query them to a database. How can this be done? Thanks!

    ITKE352,395 pointsBadges:
  • How can I my MySQL database file working?

    I was recently given a MySQL database file and now I need to restore it as a database on Windows Server 2008. I've been trying to use MySQL Administrator but I keep getting this error: The selected file was generated by mysqldump and cannot be restored by this application. What should I do to get...

    ITKE352,395 pointsBadges:
  • Can we have multiple primary keys in a single table on a SQL Server database?

    For our database, is it possible for us to have multiple keys in a single table? We're using an SQL Server database.

    ITKE352,395 pointsBadges:
  • Visual Basic 2012 time format for label link to database

    I am new to programming and i was trying to figure out how to display a label i have as 12 hour format from the current 24 hour format. currently the label pulls the data from a Mysql database but display as 24 hour format since that's how Mysql stores it. all i want to do is have the label display...

    jafranklin775 pointsBadges:
  • Clustering in SQL Server 2005

    What's the steps to use (Clustering ) in any SQL Server 2005 System??

    ScorpionSQL10 pointsBadges:
  • I want to parse data from one field into two based upon criteria.

    I have lots of data with disparate information in one field and I need to take all information to the right of any * that might appear into a separate field? There will be an * about 10% of the time. Examples of the field in question. Example 1: CKD Stage I ****250.40/585.1 Example 2: /Prosthesis...

    JohnSouthFlorida5 pointsBadges:
  • Access 2007 setting up repetitive entry form

    I'm doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

    Net201015 pointsBadges:
  • How to search for a local file programmatically using C/C++

    HOW, I develop a c/c++/java program for searching a file on my Personal computer

    Vivekagar65 pointsBadges:
  • Add to Excel spreadsheet from System i

    I want to add data from a DB2 file to an Excel template that has a header row and totals certain columns without overwriting the header row or the totals.

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following