How to create account in script in SQL server 2008 r2?

See more:

SQL

SQL-Server-2008R2

I need to create username and password,I don't think below works.

CREATE LOGIN sample
WITH PASSWORD='samplex'

thee database is about shopping app that lets you create account and shop with your cart. you also are needed to logged in, how can I do that? and how can I know who's logged in?


My other problem is how can I put many product into my cart?

INSERT INTO tbl_cart (items,itemcount)
VALUES (apple,5)

What if I bought banana,grapes,oranges together with apple. how can I retrieve what items are in the cart together with the apple.

What I have tried:

CREATE LOGIN sample
WITH PASSWORD='samplex'

INSERT INTO tbl_cart (items,itemcount)
VALUES (apple,5)