Best of Talk (06/04/04)

 
Jun 02, 2004

by Dina Hess

Title: Datebase Question!
Date: 06/04/04      (6 Posts)
Summary: In SQL Server, how do you retrieve the primary key of a record that was just inserted?
Insert into table (fields)
Values (values)
Select scope_identity() as myID
Note that scope_identity is a better choice than @@identity because, in the event the insert table invokes an insert trigger, scope_identity is specific to the current scope.
 
Title: Output Formatting
Date: 06/04/04      (11 Posts)
Summary: Can a captioned image be aligned to the right while keeping text aligned to the left? Check out Jochem van Dieten's code solution, which includes the corresponding styles.
Related: Output Formatting Question
 
Title: Secure FTP?
Date: 06/04/04      (14 Posts)
Summary: What's the most secure way to transfer sensitive files? In this excellent thread, you'll get the facts about the secure file transfer standards: SCP, SFTP, and Secure FTP. Several client GUIs are also recommended.
 

Add a Comment
(If you subscribe, any new posts to this thread will be sent to your email address.)
  
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting