Skip to Content
0
Former Member
Apr 14, 2014 at 03:07 AM

Is this code considered a Stored Procedure? If not why did it freeze my Business One Client?

32 Views

Hi Everyone,

When I ran the query below my Business One (32 bit) Client froze up (I then needed to exit the program using Task Manager).

declare @query as nvarchar(max)
set @query = 'select * from OITW'
execute (@query)


Is the above code considered to be a Stored Procedure? Alternatively if it isn't a Stored Procedure should it run in Business One, and finally why didn't it run fine for me?

Any input will be greatly appreciated.

Kind Regards,

David