开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜