4,707 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The results tab shows the results of a SELECT statement. Your code does not have any SELECT statements.
Result Tab is disappeared from My SSMS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 90%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Nabaraj Ghimire
1
Reputation point
Result tab is disappeared for this particular Query. However the query executed sucessfully .
Developer technologies | Transact-SQL
{count} votes
-
Olaf Helper 47,441 Reputation points2022-09-30T05:46:28.96+00:00 Just a note: I see a SP named SP_ SynPurchase
Never name a SP with prefix "sp_", it's reserved for system procedures.
See CREATE PROCEDURE (Transact-SQL) => procedure_name => caution: "Avoid the use of the sp_ prefix when naming procedures. This prefix is used by SQL Server to designate system procedures. Using the prefix can cause application code to break if there is a system procedure with the same name."
Sign in to comment
2 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 97%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
NikoXu-msft 1,916 Reputation points2022-09-30T01:34:07.053+00:00 Hi @Nabaraj Ghimire ,
You just successfully executed a piece of script, and if you want to output specific content, you need to use the select statement so that the content will be output in your console.
Best regards
NikoIf the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".