Ruby跨行获取最大值
admin 发布于 2020-01-13
假如有一张表 CREATE TABLE [dbo].[test1]( [id] [int] IDENTITY(1,1) NOT NULL, [a] [int] NULL, [b] [int] NULL, [c] [int] NULL, [d] [int] NULL, [e] [i...
admin 发布于 2020-01-13
假如有一张表 CREATE TABLE [dbo].[test1]( [id] [int] IDENTITY(1,1) NOT NULL, [a] [int] NULL, [b] [int] NULL, [c] [int] NULL, [d] [int] NULL, [e] [i...
admin 发布于 2020-01-12
最近在玩ActiveRecord和Sql server,发现ActiveRecord居然支持preparedstatement了。但有些功能还是不能支持,比如NOT EXISTS和CROSS APPLY。 比如,下面这段SQL就没有办法转换成为ActiveRecord 只是有些接...