Recent content by rq

I need guidance on resolving this issue. I'm trying to execute the Textcopy utility within the command prompt. I followed the syntax defined for Textcopy and encountered "SQL Server Message 18456: Login failed for user 'username'" and "DB-Library Error 10003: Login incorrect." messages. As...

I have a SQL table that is used to store ID pictures. Field (called FldA) is an image data type that will store these pictures. I want to store bitmap files onto this table wherein each file represent an ID picture. Since I have the file names to these bitmaps and am aware of the folder where...

What task do you use to raise an error so that I can check the table for data?

In the DTS package I created, there exists a Transform Data task wherein a newly created SQL table is populated with data. Whenever this task is executed, results vary for this Transform Data task -- that means this newly created table could have several records at times or none at all. An...

Our office has a SQL Server database called DbLive. We successfully backed up DbLive via Enterprise Manager. Then, accessing DbTest we wanted to restore with DbLive backup. A day later DbTest is still loading. How can I resolve this?

The query I created has several Select statements bounded by the Union operator. This query uses the For XML Explicit clause. Query looks like the following... select 1 as tag, null as parent, '' as [Enterprise!1], null as [Properties!2!DataSource!element], null as...

I meant XML format, not AML format.

I want to create a DTS package that will convert SQL 2000 data into an XML format. As an fyi, I figured out how to extract the data using the SELECT...For XML Explicit statement. What must I define within this DTS package, in terms of setting up a task and/or connection, so that so that the...

I created a Select statement using the For XML Explicit clause to convert SQL data into an XML format. As you are aware the XML declaration statement -- <?xml version ="1.0" encoding="UTF-8"?> must be inserted before defining the root element. How do I define the XML declaration statement with...

Yes, the value will be different for each record. Thus, the user-defined function is what I'm looking for. How do you call a user-defined function within an Update statement? Is it something like this -- Update tablename Set fieldname = functionname()

I'm aware of that approach. The issue is I need to update the field using a stored procedure. This stored procedure genrates a value. Can the SET clause (of the Update command) accept a call to a stored procedure?

What is the alternative if cursors are not the way to traverse the whole table for an update?

I am required to populate an integer field using a stored procedure. This field resides in an SQL table that contains thousands of records. Normally I would use an UPDATE statement to perform the task of filling in the value for the whole table. What is the efficient solution to this? I'm...

Normally, I would take that route. But the stored procedure that will be called keeps track of the integer numbers issued. What I didn't mention earlier is that I'm converting data from one application to another wherein the latter application uses this stored procedure to generate unique...

The number is a unique integer ID.