自己用到的一些SQL語(yǔ)句匯總

1、關(guān)聯(lián)更新字段值（從另外一個(gè)表中找到當(dāng)前表記錄的所屬的另外一個(gè)表中記錄的上級(jí)名稱(chēng)）

update?A?set?[CarBrandName]=(select?[itemname]?from?[TTC].[dbo].[auto_car_brand]?where?[id]=(select?pid?from?[TTC].[dbo].[auto_car_brand]?where?id=A.[CarID]?)?)?FROM?[TTC].[dbo].[tuan_base]?A

2、批量體會(huì)掉車(chē)型名稱(chēng)中的品牌

??declare?@i?int
??set?@i=1
??while(@i<3171)
	BEGIN
		??declare?@aaa?nvarchar(200)
		??select?@aaa=ShowName?from?tuan_base?where?tb_id=@i
		??if(@aaa<>'')
			begin
				print?'update?record?'+convert(varchar(5),@i)
				update?tuan_base?set?ShowName=?REPLACE(ShowName,(select?top?1?a+'?'?from??dbo.f_split(@aaa,'?'))?,'')?where?tb_id=@i
			end?
		??SET?@i+=1
	END

3、查看最后修改的存儲(chǔ)過(guò)程

SELECT?[name],create_date,modify_date?
FROM?sys.all_objects?
WHERE?type_desc?=?N'SQL_STORED_PROCEDURE'?AND?modify_date?>='2017-01-05?00:00:00'