Acme.PROJECTNAME.Install.SqlServers.GetSqlForTableExtendedPropertyLikeCount C# (CSharp) Метод

GetSqlForTableExtendedPropertyLikeCount() приватный статический Метод

private static GetSqlForTableExtendedPropertyLikeCount ( string tableName, string likeString ) : string
tableName string
likeString string
Результат string
		private static string GetSqlForTableExtendedPropertyLikeCount(string tableName, string likeString)
		{
			StringBuilder 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();
		}