How do I lock Queries

Question

Post reply

How do I lock Queries

kiasystemsoft

Old Hand

Points: 329
More actions
November 27, 2012 at 7:34 am

#285444

hi
How do I lock Queries?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 1

You dont have to, SQL does it automatically for you.

Pavan.

Lowell SSC Guru Points: 323518 More actions · Answer 2

what does locking queries mean to you?

preventing queries?

reuse the same queries?

encrypt queries or values?

you'll definitely have to explain, in much more detail, and preferable with an example query.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

kiasystemsoft Old Hand Points: 329 More actions · Answer 3

kiasystemsoft

Old Hand

Points: 329

November 27, 2012 at 8:36 am

#1562717

Lock Design Show

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Could you perhaps be a little more specific about what you're trying to do?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

kiasystemsoft Old Hand Points: 329 More actions · Answer 5

sorry

I can not speak English well

-------------

I do not view design mode for the user in Views

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

kiasystemsoft (11/27/2012)
sorry
I can not speak English well
-------------
I do not view design mode for the user in Views

Try typing your question in your native tongue and then use google translate to translate it to english. We are willing to help but we just don't know what the question is. 🙂

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

kiasystemsoft Old Hand Points: 329 More actions · Answer 7

kiasystemsoft

Old Hand

Points: 329

November 27, 2012 at 10:41 am

#1562768

Thank you my dear friend

Was dissolved