Insert value in SQL database

Posted by littleBrain on Stack Overflow See other posts from Stack Overflow or by littleBrain
Published on 2010-04-25T02:22:12Z Indexed on 2010/04/25 2:23 UTC
Read the original article Hit count: 211

Filed under:
|

In SQL Server 2005, I'm trying to figure out How to fill up the following fields? Any kind of help will be highly appreciated..

INSERT INTO [Fisharoo].[dbo].[Accounts]
       ([FirstName]
       ,[LastName]
       ,[Email]
       ,[EmailVerified]
       ,[Zip]
       ,[Username]
       ,[Password]
       ,[BirthDate]
       ,[CreateDate]
       ,[LastUpdateDate]
       ,[TermID]
       ,[AgreedToTermsDate])
 VALUES
       (<FirstName, varchar(30),>
       ,<LastName, varchar(30),>
       ,<Email, varchar(150),>
       ,<EmailVerified, bit,>
       ,<Zip, varchar(15),>
       ,<Username, varchar(30),>
       ,<Password, varchar(50),>
       ,<BirthDate, smalldatetime,>
       ,<CreateDate, smalldatetime,>
       ,<LastUpdateDate, smalldatetime,>
       ,<TermID, int,>
       ,<AgreedToTermsDate, smalldatetime,>)

© Stack Overflow or respective owner

Related posts about sql

Related posts about insert