General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I don't know if is typical for everybody but I worked for a couple of clients and they were doing it that way. Also, at the time I did not know much about MS SQL either (not that I know a lot now) and these ideas people give you here, like "GUID" I had no idea existed.
AFAIK Transactions locks the whole table.
>Is using a combination of local and sql tables a typical method of doing things? I had thought of that, but guessed a true sql program only used sql tables. Do transactions lock the whole table or just the record being added/worked on?
>
>- Gary
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only