The following SQL statement cannot be converted
CREATE TABLE tempdb.guest.temptable (
user_id int NOT NULL,
req_id int NOT NULL
)
LOCK DATAROWS
user_id int NOT NULL,
req_id int NOT NULL
)
LOCK DATAROWS
LOCK DATAROWS keyword is not available in sql server.
To achieve the same in sql server, we should give nolock for the select statments involving the above table or else we should set the isolation level as 'Read uncommitted '.
Please click here to know about sybase to sql server migration issues
Please click here to know about sybase to sql server migration issues
No comments:
Post a Comment