摘要:
获取oracel所有表结构和注释 SELECT t1.Table_Name AS "表名称", t3.comments AS "表说明", t1.Column_Name AS "字段名称", t1.Data_Type AS "数据类型", t1.Data_Length AS "长度", t1.Nul 阅读全文
摘要:
SET @VarSql = 'SELECT TOP 1 @Count=W_Count'+@i+',@Amount=W_Amount'+@i+',@AddCount=W_AddCount'+@i+',@AddAmount=W_AddAmount'+@i+',@DecCount=W_DecCount'+ 阅读全文
摘要:
原文地址:https://blog.csdn.net/weixin_44547599/article/details/88764558 group by是分组函数,partition by是分区函数(像sum()等是聚合函数),注意区分。 1、over函数的写法: over(partition by 阅读全文
摘要:
原文地址:https://blog.csdn.net/weixin_33910137/article/details/94087442 as we known,sql数据库高版本向低版本还原是不太可能但是又经常会碰到的事,今天实测了一种方法 步骤:任务—》生成脚本—》 下一步-》高级,选择数据库版本 阅读全文
摘要:
/// <summary> /// 获取MAC地址 /// </summary> /// <returns></returns> public static string GetMacAddress() { string mac = ""; ManagementClass mc = new Mana 阅读全文
摘要:
[ToolboxItem(true)] public partial class UserGridControl : GridControl { public new BaseView MainView { get { return base.MainView; } set { var gridVi 阅读全文