Error in updating the Views through ASP.Net App.
I am trying to update the view below
SELECT TOP 100 PERCENT *
FROM dbo.BEA6_USA
WHERE (siccode LIKE '%7331%') OR
(siccode LIKE '%7311%') OR
(siccode LIKE '%7319%')
ORDER BY companynname,SL_NO
I am getting the error as follows
4427--The view or function is not updatable because the definition contains the TOP clause.
please help me in solving the error.
|
