Monday, April 7, 2014

Don’t you see print statement appearing while running stored procedure script as below?

The missing Go statement with yellow back ground is the cause of it.

CREATE PROCEDURE [dbo].[spGetEmployees]
@EmpId INT
AS
BEGIN
SET NOCOUNT ON

SELECT
E.EmpName,
        E.Designation,
        E.Salary
FROM
Employee
        WHERE Q.EmpId = @EmpId
END
GO

PRINT '[dbo].[spGetEmployees] is Created'
GO

No comments: