Hi, I'm trying to create a stored procedure through myLittleAdmin but I am getting the error "Incorrect syntax near 'GO'" when using this procedure:
CREATE PROCEDURE [GetChildPages]
(@PageID int)
AS
SELECT PageID, PageTitle, PageParentID
FROM TblPages
WHERE (PageParentID = @PageID)
ORDER BY PageSortOrder
GO
But the same code works fine in Enterprize Manager.
I tried removing "GO" and it worked in the sense that I did not get an error from myLittleAdmin, but when I call the procedure from my code it does not work properly...
What am I doing wrong?