CODEWITHSUNDEEP
sql
Shri S Softwares
Shri S Softwares

Reputation: 1529

Stored procedure with global table

Is there any difference between stored procedure which uses global temporary table and one which does not in MS SQL database?

Upvotes: 0

Views: 56

Answers (1)

Sateesh Pagolu
Sateesh Pagolu

Reputation: 9606

Global temporary table's scope is not limited to stored procedure, it can conflict with other procedures using same global temporary table(##TableName)

You can create Global temporary table in procedure, insert data and then see your data after store procedure execution.

Upvotes: 1

Related Questions