Acme.Northwind.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)
		{
			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();
		}