如何在SQL Server 2008 r2中的脚本中创建帐户？ [英] How to create account in script in SQL server 2008 r2?

问题描述

我需要创建用户名和密码，我认为以下不起作用。



创建登录样本

WITH PASSWORD =' samplex'



数据库是关于购物应用程序，可让您创建帐户和购物车购物。您还需要登录，我该怎么办？我怎么知道谁登录了？





我的另一个问题是如何将很多产品放入购物车？



INSERT INTO tbl_cart（items，itemcount）

VALUES（苹果，5）



如果我买了香蕉，葡萄，橘子和苹果一起。如何与苹果一起检索购物车中的物品。



我尝试了什么：



创建登录样本

WITH PASSWORD ='samplex'



INSERT INTO tbl_cart（items，itemcount）

VALUES（apple，5）

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)

推荐答案

请看这里的例子： Extreme UltraDev - 电子商务数据库设计第1部分 [ ^ ]

这里是一个开源项目： GitHub - simplcommerce / SimplCommerce：一个基于.NET Core构建的简单，跨平台，模块化的电子商务系统 [ ^ ]

另外一个关于GitHub：ASP.net MVC一步一步完成电子商务教程shakeel osmani [ ^ ]

See here for an example: Extreme UltraDev - E-commerce Database Design Part 1[^]
And here for an open source project: GitHub - simplcommerce/SimplCommerce: A simple, cross platform, modularized ecommerce system built on .NET Core[^]
And another one on GitHub: ASP.net MVC step by step complete E-commerce tutorial | shakeel osmani[^]

这篇关于如何在SQL Server 2008 r2中的脚本中创建帐户？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！