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]
SET NOCOUNT ON
WHERE Q.EmpId = @EmpId
PRINT '[dbo].[spGetEmployees] is Created'
Get data with column names from SQL Result set
Use copy with header and then press Ctrl +V in an excel.You will get column names too along with data.