摘要:
SELECT a.table_name 表名, a.ordinal_position 字段序号, a.COLUMN_NAME 字段名, a.DATA_TYPE 数据类型, case a.column_key when 'pri' then 1 else 0 end as 主键, case extra 阅读全文
摘要:
public class ZipBin { public byte[] bytes; //C#读取压缩文件(将压缩文件转换为二进制 public void GetZipToByte(string inpath) { FileStream fs = new FileStream(inpath, FileMode.Open); bytes = new byte[fs.Length]; int count = Convert.ToInt32(fs.Length); ... 阅读全文
摘要:
select s.[name] + '.' + t.[name] as tablename from sys.tables as t,sys.schemas as s where t.schema_id = s.schema_id and s.[name] = @dbo order by tablename获取指定架构下的所有表SELECT ... 阅读全文
摘要:
@Ajax.ActionLink("news title a", "Contents",new{id=1}, new AjaxOptions {HttpMethod="Post",InsertionMode= InsertionMode.Replace, UpdateTargetId="news_content" }) @Ajax.ActionLink("news title b", "Contents",new{id=2}, new AjaxOptions {HttpMet 阅读全文