read data (data window) unclear

yucikala posted 3 weeks 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 posted 3 weeks ago

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

What exactly means lock/nolock?

yucikala posted 3 weeks 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/

ansgar posted 3 weeks 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 posted 3 weeks 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 posted 3 weeks 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.