22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT c_nick_name AS c_account_id
FROM t_yw_customer_mng_qhcrm t WITH(NOLOCK)
LEFT JOIN t_enterprise_account a WITH(NOLOCK) ON a.c_id = t.c_account_id
WHERE 1 = 1
AND ISNULL(c_customer_id, '') = ''
AND black_state = 2
ORDER BY
c_create_time DESC OFFSET((1 -1) * 300) ROW
FETCH NEXT 300 ROWS ONLY
EXEC sys.sp_updatestats
alter VIEW [dbo].[T_ENTERPRISE_ACCOUNT]
AS
SELECT
c_id
, c_nick_name
FROM db1.dbo.T_ENTERPRISE_ACCOUNT