mssql
文章平均质量分 79
kenliang18
这个作者很懒,什么都没留下…
展开
-
user without login sp_change_users_login
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-change-users-login-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7d129880-048c-4834-a72e-c31ead4897c原创 2021-11-20 09:46:28 · 906 阅读 · 0 评论 -
MSSQL deadlock
第一步,先创建两个表,并插入数据 CREATE TABLE Lock1(C1 int default(0)); CREATE TABLE Lock2(C1 int default(0)); INSERT INTO Lock1 VALUES(1); INSERT INTO Lock2 VALUES(1); 第二步:执行第一个sql Begin Tran Update Lock2 Set C1=C1+1; WaitFor Delay '00:00:10'; SELECT * FROM ...原创 2021-10-11 11:40:09 · 324 阅读 · 0 评论