Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspdotnet_website_programming thread: Scripting set-up of a database


Message #1 by "Mike Gale" <info@d...> on Fri, 6 Dec 2002 11:52:13 +1300
I'm scripting (*.sql) to create SQL Server databases, which include a
table similar to the Users table in the book.

As part of the script I populate some table with values, syntax can be
like

USE ***

SET IDENTITY_INSERT [dbo].[***] ON

INSERT INTO [dbo].[***]([ClientID], [ClientName], ...
[EncryptedPassword])
VALUES(1,'TheBoss',...
GO

I wondered if anyone had done this (using thePhile) and if so how they
handled the binary field.  (Both on export and on insert.)  (This would
save me some research.)

(I've found that an export as CSV gives me a text value for the binary
field but that this doesn't get INSERTED.)

Mike Gale, Decision Engineering (NZ) Ltd.

CAUTION - This message may contain privileged and confidential
information intended only for the use of the addressee/s.

If you are not the intended recipient of this message you are hereby
notified that any use, dissemination, distribution or reproduction of
this message is prohibited without prior written consent.  Any views
expressed in this message may not reflect the views of Decision
Engineering.


 


  Return to Index