What would be the SQL Server equivalent of the following code (particularly
the COUNTER attribute)?:
<cfquery datasource="#DataSourceName#">
CREATE TABLE
#Form.UserFirstName#_#Form.UserMiddleName#_#Form.UserLastName#
(
BookmarkID COUNTER NOT NULL PRIMARY KEY,
BookmarkName TEXT(255),
BookmarkCategory TEXT(255),
BookmarkURL TEXT(255),
BookmarkDescription MEMO,
BookmarkAdded DATETIME,
BookmarkVisits NUMBER,
BookmarkRating TEXT(50),
BookmarkLastVisit DATETIME
);
</cfquery>
Cheers!
Peter Tilbrook
Project Officer
Strategic Development
Australian Building Codes Board
GPO Box 9839
CANBERRA ACT 2600
Telephone: (02) 6213 6731
Facsimile: (02) 6213 7287
**********************************************************************
The information contained in this e-mail, and any attachments to it, is
intended for the use of addressee and is confidential. If you are not
the intended recipient, you must not use, disclose, read, forward, copy or
retain any of the information. If you have received this e-mail in
error, please delete it and notify the sender by return e-mail or telephone.
The Commonwealth does not warrant that any attachments are free from
viruses or any other defects. You assume all liability for any loss, damage, or
other consequences which may arise from opening or using the attachments.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com