<div>
found answer:<br />
update top (100) table1 set field1 = 1<br />
<br />
parentheses are required.
</div>


<div>
Just a comment:<br />
<br />
Such an update will change arbitrary rows.
</div>


<div>
that was just an example. ;)
</div>


<div>
Again: The rows changed by that statement are arbitrary.
</div>


<div>
So after you update your first 2000 piece, how do you determine what the second 2000 piece should be? Ste5an is absolutely right so the next 2000 piece could contain some, none of all of the first 2000 piece. What does the update statement look like that times out? It might be modified to perform without a time out.
</div>


<div>
I totally understand and I appreciate your feedback, but as I said, it was just from the example that I found showing that the parenthesis were required.<br />
<br />
I will actually use it like so:<br />
<br />
update top (2000) set fieldname = null where fieldname is not null
</div>


<div>
So your original update query that timed out was essentially -<br />
update table set fieldname = null where fieldname is not null?<br />
How many rows are in your table and what is the approximate percentage of null fieldnames and non-null fieldnames?
</div>


<div>
I'm done with this question. I have it all set. I just update the top (x) on a loop.<br />
<br />
thanks.
</div>


<div>
<div class="content wysiwyg-content">
SQL Server Database:<br />
<br />
I need to update by top X like:<br />
<br />
Update Top 2000 set ......<br />
<br />
I don't find an example and when I try it errors. Is there something similar?<br />
<br />
I am getting a time out on my update so I want to do it in pieces. Any ideas?<br />
<br />
thanks!
</div>
</div>


SQL Server Database:

I need to update by top X like:

Update Top 2000 set ......

I don't find an example and when I try it errors. Is there something similar?

I am getting a time out on my update so I want to do it in pieces. Any ideas?

thanks!

Update Top 2000 - something like that.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.