Đẩy dữ liệu cho MetaData

use [QLDT_tiensi]DECLARE @tbName nvarchar(100)declare @colName nvarchar(100)DECLARE @lst CURSORSET @lst = CURSOR FOR    SELECT table_name, column_name    FROM INFORMATION_SCHEMA.COLUMNS     OPEN @lstFETCH NEXTFROM @lst INTO @tbName,@colNameWHILE @@FETCH_STATUS = 0BEGIN    print @tbname + ' ' + @colName    if (not exists( select * from tbMeta where tenbang = @tbName and tentruong = @colName))         insert into tbMeta(tenbang,tentruong, dorong,...

Chi tiết