1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

PRINT 'GO Needed here'
GO
CREATE PROC #uspGetAllUsers
AS
    SET NOCOUNT ON;
    SELECT TOP 10 DisplayName, Location, Reputation
    FROM Users;
GO
EXECUTE #uspGetAllUsers;
GO
-- Or
EXEC #uspGetAllUsers;
GO
-- Or, if this procedure is the first statement within a batch:
#uspGetAllUsers;

fork query

edited jan 18 12

created jan 18 12 Mark Hurd