I'm not sure what do you mean by locking......
Anyways the first choice look good.
For ex:
Insert into tbl_test1
SELECT col_Test2
FROM tbl_test2 (nolock)
WHERE NOT EXISTS
(SELECT Col_test1
FROM tbl_test1 (nolock)
WHERE tbl_test1.Col_t est1 = tbl_test2.Col_t est2)
Krishna :)
User Profile
Collapse
-
Schema Change of the table which is under replication
How do I change schema of the table which is under replication to the reporting box without effecting or doing any changes to the publication or the subscription. I know there is built in SP sp_repladdcolum n & sp_repldropcolu mn to add new or drop columns. But I want to alter the datatype of some of the columns. I have 2 fields with Varchar(20) which I want to convert to varchar(40) and 1 column from text to varchar(255).
Can anybody... -
Krishna Ladwa started a topic No Notifications appears when converting text column to varchar columnin SQL ServerNo Notifications appears when converting text column to varchar column
In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears when you convert the varchar column to text column.
Do this through Enterprise Manager Console
Create a New table with a column as varchar datatype from Enterprise Manager table created Open the table and...
No activity results to display
Show More
Leave a comment: