That's a great tip. I've not used that before. Interesting...
Shawn
-----Original Message-----
From: Linda Leslie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 1:00 PM
To: Fusebox
Subject: RE: OFF: Unique row id in SQL select statement
When SET NOCOUNT is ON, the count (indicating the number of rows affected by
a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the
count is returned.
The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.
SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client
for each statement in a stored procedure. When using the utilities provided
with Microsoft� SQL Server* to execute queries, the results prevent "nn rows
affected" from being displayed at the end Transact-SQL statements such as
SELECT, INSERT, UPDATE, and DELETE.
For stored procedures that contain several statements that do not return
much actual data, this can provide a significant performance boost because
network traffic is greatly reduced.
The setting of SET NOCOUNT is set at execute or run time and not at parse
time.
FYI,
The Fuesebox list has moved to topica.
Linda Leslie
Global Cloud
Database and Application Developer
>>> [EMAIL PROTECTED] 08/23/01 11:31AM >>>
What does the NOCOUNT do? Don't you just need @@IDENTITY?
Shawn
-----Original Message-----
From: Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 9:04 AM
To: Fusebox
Subject: Re: OFF: Unique row id in SQL select statement
You didn't say what db server you are running but if you are running MS
SQL Server and don't mind sacrificing portability then this type of
thing works very well:
<cfquery name="MyQuery">
SET NOCOUNT ON
INSERT INTO MyTable
(Field1, Field2)
VALUES(#myField1#, #myField2#)>
SET NOCOUNT OFF
SELECT @@IDENTITY AS ID
</cfquery>
The new ID is then available as MyQuery.ID
--- Yuri Vorontsov <[EMAIL PROTECTED]> wrote:
> One more off-topic question. Does anyone know how one can retrieve
> a unique id of a row in a SQL query? I need smth like:
>
> select ???? as this_row_uid
>
> Any ideas?
> Thanks a lot!
>
> Yuri
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
