I need to obtain an identity value from a row I just added to a table. I
would prefer to use SCOPE_IDENTITY() rather than @@IDENTITY but have found
that the only way I can get SCOPE_IDENTITY() to work is to place a SELECT
SCOPE_IDENTITY() just after the INSERT.... code of a ...

I have a simple command.ExecuteNonQuery() to insert some data into the SQL
DB. The data can be inserted, but the characters like '\n' are somehow
stripped during the process.  I want to keep it.
My code looks like below.

I'm going nuts using the currencymanager. Am I the only person using this
manager, I'm not getting any replies to my post, neither do I see anyone
posting similar problems. Maybe I'm not using it the way, it's supposed to
be, some one please help me out..

I have 3 tables related to this issue which I will present in xml-form for
best known legibility...
<root>
 <User id="1" name="User One"/>

my sql is below :
=================================================
DECLARE
TEMP_VAR1 VARCHAR2(32767);

I have a DataView and I'm changing the RowFilter several thousand times
during some processing.  Is there a way to speed that up, something like a
client-side index I can use?
Currently the process takes several hours to run, most of that time being

How does one get data provider information at run-time using ADO .NET. I
want to get such things as particularities of SQL syntax, transaction type
support, other data provider specific information but I want to do it in a
generic way and not in a hard-coded, predetermined way. I ...

what objects do I need to be sure to explicitly close calling
object.close()? datasets? datatables? connections? dataviews? datareaders?
and how should it be done? .close()? .dispose()? set=Nothing?
I am new to asp.net/ado.net/vb.net but I used to always explicitly close

Just a quick quastion. There seems to be a close relationship
between connection pools and the connection string. Given that a
Workstaion ID forms part of a connection string, does this mean that
each machine on the network that will access the server will always

I'm replacing a VB application with a .NET application written in C#.
Previously I have been using the GetRows() function of ADO recordsets
quite extensively, because in the case of the old application it would
lower data retrival time several times.

DataSet is supposed to be an in-memory database. So is it possible to fire a query on it. I want to fire a "Select" query (with alises in it) and also a "Transform" (Crosstab) query. In the current scenario I am putting things in an Access table but for performance reasons want ...

(Type your message here)
--------------------------------
From: renu
Friends,

Gurus,
Here is what I'm trying to do.
I have a table in sql server. The data for this table comes from a XML
(with matching schema) from an external system. I'm trying to read the

I am trying to do something like this, but getting a compile error:
FldOrderTxn.fldOrderRow orderRow = fot.fldOrder.NewfldOrderRow();
orderRow.FMCO_USER_ID = ds.Tables[0].Rows[0]["FMCO_User_ID"].ToString();
orderRow.SEQ = 1;

Hola!
I am trying to track inside the insert trigger, what EXE is creating the
insert using the process ID.
1) If I call from an EXE done using VB6 (lastest patch), I do an SP_WHO2, I