34,588
社区成员
发帖
与我相关
我的任务
分享
USE tempdb
GO
IF OBJECT_ID('TEST') IS NOT NULL DROP TABLE TEST
GO
CREATE TABLE TEST(
id INT IDENTITY(1,1) PRIMARY KEY,
A INT
)
GO
INSERT INTO TEST(A) VALUES (13)
INSERT INTO TEST(A) VALUES (25)
GO
--添加计算列
ALTER TABLE TEST ADD A_mod_10 AS A%10 PERSISTED
--添加计算列索引
CREATE INDEX ix_TEST_A_mod_10 ON TEST(A_mod_10)
GO
--查询时直接用计算列
SELECT * FROM TEST WHERE A_mod_10=3
/*
id A A_mod_10
1 13 3
*/