1024programmer Java How to execute GO statement with dynamic counting?

How to execute GO statement with dynamic counting?

How to set the dynamic count of GO statement?

I receive the following error:

A fatal script error occurred. Incorrect syntax was encountered while parsing Go.

When I try to run the following query:

Declare @count int
 Select @count=COUNT(*) From Users

 Insert Into #DummyUsers
 Select * from Users where UserName = 'Sachin'

 GO @Count
 

But when I use the query below with hardcoded counts, the same works fine.

Declare @count int
 Select @count=COUNT(*) From Users

 Insert Into #DummyUsers
 Select * from Users where UserName = 'Sachin'

 GO 5
 

If you have any thoughts on this, appreciate your suggestions.

1> Sean Lange..:


You can’t. Once SSMS encounters GO, the batch terminates and your variables no longer exist.

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/756369

author: admin

Previous article
Next article

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Contact us

181-3619-1160

Online consultation: QQ交谈

E-mail: [email protected]

Working hours: Monday to Friday, 9:00-17:30, holidays off

Follow wechat
Scan wechat and follow us

Scan wechat and follow us

Follow Weibo
Back to top
首页
微信
电话
搜索