摘要：1.最早知道的是用 IDENTITY(int, 1, 1) 塞到临时表中,再与原表中数据相SELECT CASENO,SEQNUM , IDENTITY(int, 1, 1) AS [ID] into #tmptest FROMtable where PO='888'order by CASENO,CAST(SEQNUM AS INT)虽然这种方式有点麻烦...2.后来知道了Dense_rank() over (order by colname)---才发现原来可以不用塞临时表3.再后来才知有个更历害的Row_number() over (partition by colnam 阅读全文

摘要：1.获取程序启动路径:string strpa=Application.StartupPath;2.浏览文件: OpenFileDialog openFile = new OpenFileDialog(); openFile.Filter = "excel file(*.xls)|*.xls"; if (openFile.ShowDialog() == DialogResult.OK) { txtFilename1.Text = openFile.FileName.ToString().Trim(); }3.生成保存文件名获得保存路径:string strOutPath = 阅读全文

摘要：select name from syscolumns where id = object_id('table')----get columns;select name from sysobjects where type='U'----get all tables in DB;-----搜索存储等SELECT sys.id, sys.text, obj.nameFROM syscomments SYS Inner join sysobjects obj on sys.id = obj.idWHERE sys.id IN (SELECT id FROM syso 阅读全文