开发者

Can master.dbo.sysprocesses.login_time have the same values?

开发者 https://www.devze.com 2023-03-02 14:28 出处:网络
is it theoretically possible that two users will login at the same time to the MS SQL server, so they will have absolutely same values in master.dbo.sysprocesses.开发者_高级运维login_time ?

is it theoretically possible that two users will login at the same time to the MS SQL server,

so they will have absolutely same values in master.dbo.sysprocesses.开发者_高级运维login_time ?

Thanks a lot


It's only a datetime column (not even a datetime2), so it only has ~300 distinct values possible each second. I think you could easily create multiple connections during a period where it stays the same. I'll try to produce a demo, but because it's due to connection start times, it won't be something I can write in just SQL.

0

精彩评论

暂无评论...
验证码 换一张
取 消