????SQL Server????????????
???????????? ???????[ 2015/7/30 10:49:26 ] ?????????????
?????????????
string sql = @" if exists
( select * FROM [{0}].sys.extended_properties PFD with(nolock)
left join [{0}].sys.columns C with(nolock)
ON PFD.class=1 AND C.[object_id]=PFD.major_id AND C.column_id=PFD.minor_id
left JOIN [{0}].sys.objects O with(nolock)
ON C.[object_id]=O.[object_id] AND O.type='U' AND O.is_ms_shipped=0
where C.name='{2}' and O.name='{1}' )
begin
USE [{0}];
EXEC sp_updateextendedproperty N'MS_Description'?? '{3}'?? N'user'?? N'dbo'?? N'table'?? N'{1}'?? N'column'?? N'{2}'
end
else
begin
USE [{0}];
EXECUTE sp_addextendedproperty N'MS_Description'?? '{3}'?? N'user'?? N'dbo'?? N'table'?? N'{1}'?? N'column'?? N'{2}'
end "; //?ж???????????????????????????
dbName = dbName.Replace('''?? ' ');
sql = string.Format(sql?? dbName?? TableName?? rowName?? Description);
????????????????????????д?????????2??
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
???????sql server 2000??????????????SQL Server???????????????????λ?????SQL Server??????????????????????????????SQL Server??Azure SQL??SQL SERVER ?????????????汾??????SQL Server??WITH (NOLOCK)SQL Server??????????????DML??????????SQL Server????????????????????SQL Server??????SQL Server???????????Ч?????????SQL Server?????????????????SQL Server?????????????????SQL Server????????SQL SERVER????????SQL Server????δ???????SQL SERVER??????????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????