Insert value in SQL database

Question

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,>)

Answer 1

If you are using explicit values, you can just type them in. You can also use Select INTO syntax.

INSERT INTO [Fisharoo].[dbo].[Accounts]
       ([FirstName]
       ,[LastName]
       ,[Email]
       ,[EmailVerified]
       ,[Zip]
       ,[Username]
       ,[Password]
       ,[BirthDate]
       ,[CreateDate]
       ,[LastUpdateDate]
       ,[TermID]
       ,[AgreedToTermsDate])
 VALUES
       ('Bob'
       ,'Smith'
       ,'[email protected]'
       ,0
       ,'11111'
       ,'bsmith'
       ,'mylittlepony'
       ,'1/1/1950'
       ,'4/24/2010 11:23 PM'
       ,'4/24/2010 11:23 PM'
       ,3
       ,null)

Answer 2

INSERT INTO "Fisharoo" ("FirstName", "LastName", "Email", EmailVerified, "Zip", "Username", "Password", "BirthDate", "CreateDate", "LastUpdateDate", TermID, "AgreedToTermsDate")
VALUES ('Duck', 'Dummy', '[email protected]', 1, '12345', 'Ducky', 'test123', '2010-02-01', '2010-01-01', '2010-01-01', 3, '2010-01-01');

Answer 3

I'm not sure what you're really asking here. Is it this simple?

INSERT INTO [Fisharoo].[dbo].[Accounts]
   ([FirstName]
   ,[LastName]
   ,[Email]
   ,[EmailVerified]
   ,[Zip]
   ,[Username]
   ,[Password]
   ,[BirthDate]
   ,[CreateDate]
   ,[LastUpdateDate]
   ,[TermID]
   ,[AgreedToTermsDate])
 VALUES
   ('Bob'
   ,'Dole'
   ,'[email protected]'
   ,1
   ,'75454'
   ,'bdole'
   ,'topsecret'
   ,'07-22-1923'
   ,'04-24-2010'
   ,'04-24-2010 21:31'
   ,123
   ,'04-24-2010')

Is this a real table design or just an example? Because if it's real, please don't store the password as a varchar(50).