Ravi Shankar Kota
A blog about my Life and Work !
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment