read data (data window) unclear

yucikala's profile image yucikala posted 6 years ago in Running SQL scripts Permalink

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 6 years ago Permalink

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

What exactly means lock/nolock?

yucikala's profile image yucikala posted 6 years ago Permalink

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's profile image ansgar posted 6 years ago Permalink

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 6 years ago Permalink

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 6 years ago Permalink

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.