• row_number in sql 2000

    how to find out the row_number in sql 2000 like using row_number() function in sql 2005

    Rl10 pointsBadges:
  • Adding files to TempDB

    Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sample RPGIV program to read and process XML file

    Hi, I am wondering if anyone has a sample program they would be willing to share that would read/extract the data from an XML file that is on the IFS of the AS400 and write it to an AS400 file/member.  I'm using V5R3 of the OS so can't use the latest XML opcodes that came in for V5R4. ...

    Lehanb30 pointsBadges:
  • How to left or right justifying a text file

    Hello programmers. I am using sql to create a table from stored procedures and then streamwriter in vb.net to create a text file based on the sql table. Where and how do I control the right or left justification of the records in the text file? Thx.   ip

    Ilfoprog50 pointsBadges:
  • Using Visual Basic and Access – having problems with other programs sharing memory

    Hi folks I have written a Point of Sale program which uses an access database. The program runs beautifully at sites where the the computers are dedicated specifically to running the software, but I am having nightmares at sites where the clients allow their staff to play games, download all sorts...

    JulianF25 pointsBadges:
  • ASP.NET

    i have four textboxes abd a database whicjh is already created. what i want to do is if i enter the value in the four textboxes and press button it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • ASP.NET

    i want to insert the data into the existing database

    5555544425 pointsBadges:
  • VB.NET project setup.

    how to prepare exe file of a vb.net project

    Boxterjo5 pointsBadges:
  • Can VB 6.0 be installed after installing VB 2008 ?

    I installed the Visual Studio 2008 version of Visual Basic on my new Windows 7 machine.  I would now like to add Visual Basic 6.0.   Can this be done without first uninstalling Visual Studio 2008?  

    Rlemek5 pointsBadges:
  • finding webmail access site

    Hello, Is there any way one can find out the webmail access site using only the email address? Actually my friend was out of town and wanted to check her email using webmail but she had forgotten the webmail access site provided by her hosting service provider. She told me find this out but I could...

    BinooDas123410 pointsBadges:
  • dasd vs asp?

    is the relation between DASD and ASP?

    0 pointsBadges:
  • The most-watched IT questions this week: March 9, 2010

    1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor...

    Michael Morisy8,323 pointsBadges:
  • Assign default values to SQL VIEW columns

    I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.

    Tgee60 pointsBadges:
  • Explain SQA and QC roles and Responsibilities in each and every phase of SDLC

    Explain SQA  and QC roles and responsibility  in each and every phase of SDLC material for SQA

    Madhurig5 pointsBadges:
  • C++ (String Input)

    Hi ,   How can we input a string without specifying its length before ? As in , the program should understand that the string has ended when the return key has ended. The input string can be a line , word , blog , novel[It can be that big I mean to say] Apart from that how to count the number of...

    Bornwinner35 pointsBadges:
  • IE 8 Crashing Problem

    Hello Everyone, Here's the situation: two iSeries boxes - Dev and Prod both V5R4M0 We're using AJAX to dynamically load content using a tabbed based navigation using this code: http://www.dynamicdrive.com/dynamicindex17/ajaxtabscontent/index.htm We have no issues loading information on our Dev...

    Dcantwell470 pointsBadges:
  • web service consuming COM dll not able to publish to IIS

    I have a COM dll with one class exported. I have developed a web service in Microsoft Visual studio 2005. I have registered COM dl using regsvr32 command and added the reference of this dll to my web service application. Web service is having one web method inside which I am creating an instance...

    0x800101055 pointsBadges:
  • How should I make the SQL in iBatis having Parameter of ListMap?

    How should I make the SQL in iBatis having Parameter of List<Map>? When I search primery key at a table having two primery key, I have plural parameters as a parameter. This parameter is List<Map>. It is an example of Parameter as follows EX) 1. parameter List<Map> paramList = new...

    Jhyukchoi5 pointsBadges:
  • How to use PL/I command LIKE with DB2

    I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns....

    Sccsofti5 pointsBadges:
  • iseries stored procedure : read character string containing single apostrophe …. ex: Let’s

    I am working on a stored procedure that requires a literal string to be input into a VARCHAR(1024) variable. My stored procedure has no problem reading the word........... Let''s However, if I try to read the word............Let's, I get a code violation. Do I need to read the string as a datatype...

    Dsthornton5 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