如何在asp.net网站上用sql server一次管理多个请求。
问题描述：
我想在sql server数据库表中插入记录。
表结构
Sno int，
名称varchar，>
companycode int。
i希望在网页请求的响应中通过公司代码识别sno。
如公司代码1是一个然后sno从1,2开始，3,4 ... so.same为另一个公司代码。
我的问题是当我同时请求表时，同样没有生成。
i have还尝试了存储过程但是当一次生成多个请求时它会失败。
请帮我解决这个问题。
i want to insert record in the sql server database table.
table structure
Sno int,
name varchar,
companycode int.
i want recognize sno by company code at the response on web request.
like company code 1 is one then sno start from 1,2,3,4...so on.same for another company code.
my problem is when i am requesting table at same time then same no is generated.
i had also tried stored procedure but it fails when multiple request generated at a time.
please help me to resolve this issue.
答
更改表设计。
将Sno设置为每行递增的主键 - http://technet.microsoft.com/en-us/library/ms189039.aspx [ ^ ]。
如果你不希望Sno成为主键，你仍然可以让它自动增加 - http://technet.microsoft.com/en-us/library/aa933196%28v=sql.80%29.aspx [ ^ ]。
Change the table design.
Set the Sno as a primary key that increments for every row - http://technet.microsoft.com/en-us/library/ms189039.aspx[^].
If you do not want Sno to be a primary key, you can still make it increment automatically - http://technet.microsoft.com/en-us/library/aa933196%28v=sql.80%29.aspx[^].
试试做这样的事情。
Try to do something like this.
DECLARE @MAX_sno int=null;
SELECT @MAX_sno=MAX(person_id) FROM TABLENAME WHERE companycode='Your_companycode' ;
SET @MAX_sno=@MAX_sno+1;
----In MAX_sno you will get new sno value which can be used for new record insertion