- 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)
-
CREATE TAblE #temp ( T_Name VARCHAR(50), T_Times BIGINT ) INSERT INTO #temp(T_Name,T_Times) VALUES ('ASHISH',4) IN... -
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 ...
No comments:
Post a Comment