private static GetSqlForTableExtendedPropertyLikeCount ( string tableName, string likeString ) : string | ||
tableName | string | |
likeString | string | |
리턴 | string |
private static string GetSqlForTableExtendedPropertyLikeCount(string tableName, string likeString)
{
var sb = new StringBuilder();
sb.Append(" SELECT ");
sb.Append(" count(*) ");
sb.Append(" from ");
sb.Append(" sysobjects so ");
sb.Append(" inner join sysproperties sp on so.id = sp.id ");
sb.Append(" where ");
sb.Append(" so.name='" + tableName + "' AND ");
sb.Append(" sp.name like '" + likeString + "' ");
return sb.ToString();
}