在SQL Server中,请考虑以下查询:
1. select * from employee where department LIKE "[^F-M]%";
2. select * from employee where department = '[^F-M]%';
选择正确的选项:( )
查询2将返回错误信息
两个查询都将返回相同的记录集
查询2完全正确
查询2返回的记录比查询1少一条
在SQL Server中,请考虑以下查询:
1. select * from employee where department LIKE "[^F-M]%";
2. select * from employee where department = '[^F-M]%';
选择正确的选项:( )
查询2将返回错误信息
两个查询都将返回相同的记录集
查询2完全正确
查询2返回的记录比查询1少一条