*real developer* lol
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-----Original Message-----
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 27, 2005 1:35 PM
To: CF-Talk
Subject: Re: SQL

heh.  I don't think anybody can claim to be a real developer until
they've forgotten the WHERE clause at least once :)

On 11/27/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Oh and don't forget the WHERE clause! :OD
>
> Ade
>
> -----Original Message-----
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: 27 November 2005 18:31
> To: CF-Talk
> Subject: RE: SQL
>
>
> INSERT INTO YourTable (
>         YourColumns,
>         ...,
>         ...
> ) SELECT
>         YourColumns,
>         ...,
>         ...
> FROM YourTable
>
> -- For SQL Server
> SELECT @@IDENTITY YourNewID
> -- Or
> SELECT SCOPE_IDENTITY() YourNewID
>
> Ade
>
> 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225335
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
  • RE: SQL Bobby Hartsfield

Reply via email to