SELECT * FROM data WHERE technology = 'database'; INSERT INTO knowledge VALUES ('SQL', 'Azure', 'Oracle'); UPDATE skills SET level = 'expert' WHERE topic = 'DBA';

Tab

Blocking in SQL Server

SELECT * FROM dbo.sysprocessesWHERE blocked <> 0;

SELECT * FROM dbo.sysprocesses WHERE spid IN (SELECT blocked FROM dbo.sysprocesses where blocked <> 0);

No comments:

Post a Comment

Popular Posts