一般来说,可以在数据库使用的sql都可以用在direct sql里面,但有个地方要注意一下.
就是: direct sql里面要使用当前form的值,需要加上单引号.
例如:
declare @count int
select @count = COUNT(*) - 1 from Details d where RequestNumber = '$RequestNumber$' and d.Status != 2
if(@count = 0)
begin
update Master set RequestStatus = 'Closed' where RequestNumber = '$RequestNumber$'
end