8 lines
332 B
SQL
8 lines
332 B
SQL
USE ybdevicev2_test
|
|
SELECT COUNT(*) FROM dbo.YB_Device WHERE TenantId=285311419052101
|
|
|
|
SELECT * FROM ybdevicev2.dbo.YB_Device a WHERE EXISTS(SELECT 1 FROM YB_Device WHERE a.FacCode=a.FacCode) AND TenantId=285311419052101
|
|
|
|
SELECT * FROM ybdevicev2.dbo.YB_Business WHERE id='08DA3165-4193-4118-81C9-F05F5243F17E' --蓉城原来的客户id
|
|
|