Honestly, I'm not sure, but the @@identity won't work without it. I can't
find it in the SQL docs, but pulled it from a message on this list at one
point.
D
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
-----Original Message-----
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 12:42 PM
To: CF-Talk
Subject: RE: @@identidy in sql server 7
What does the "set nocount on" do?
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-----Original Message-----
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
set nocount on
insert into table ()
values ()
select @@identity as newID
set nocount off
HTH
D
*************
Diana Nichols
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
