Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

read data (data window) unclear

yucikala's profile image yucikala posted 8 months ago in Running SQL scripts

Is's possible to read data at MSSQL with nolock when I use data window? It very help...

There can be some settings (nolock or not nolock).

Thanks

ansgar's profile image ansgar posted 8 months ago

Are you using the "Data" tab or a "Query" tab?

What exactly means lock/nolock?

yucikala's profile image yucikala posted 8 months ago

Data tab. When I use query tab, I can use nolock manualy. I Like Data tab.

Nolock query: select from Table (nolock) Normaly : select from Table e.g.: https://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/



Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
ansgar's profile image ansgar posted 8 months ago

Ah ok, you're on MS SQL - and that (nolock) is an SQL extension, right?

You should file an issue in the bugtracker for that.

yucikala's profile image yucikala posted 8 months ago

I'm not sure if not using nolock is bug. What ever using nolock make more faster reading and does not lock tables.

So - may I put it to bugtracker?

ansgar's profile image ansgar posted 8 months ago

The tracker is also for enhancements, not only for bugs. So, yes, please file an issue there.

Please login to leave a reply, or register at first.