- 2025年05月12日
- 星期一
dawei
我如何改进以下代码只使用一次“选择”？ IF EXISTS (SELECT [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_recordBEGIN DECLARE @tmp_variable SELECT @tmp_variable = [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_record
我如何改进以下代码只使用一次“选择”？ IF EXISTS (SELECT [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_recordBEGIN DECLARE @tmp_variable SELECT @tmp_variable = [NUMBER] FROM [TABLE] WHERE [ID_RECORD] = @id_record