- UPDATE t1
- SET t1.TID = t2.DOID
- FROM dbo.Table1 AS t1
- INNER JOIN dbo.Table2 AS t2
- ON t1.CommonField = t2.[Common Field]
Subscribe to:
Post Comments (Atom)
-
Setting Header Programatically You can also set the cache headers programmatically. This can be useful for generated content and allows m...
-
CREATE TABLE dbo.M_Bank ( ID INT IDENTITY NOT NULL, MB_NAME NVARCHAR (50), MB_SNAME NVARCHAR (20), MB_ADDUSER ...
-
SELECT distinct(volume_mount_point), total_bytes/1048576 as Size_in_MB, total_bytes/1048576/1024 as Size_in_GB, available_bytes/1048576 ...
No comments:
Post a Comment