摘要:
this.dataGridView1.EndEdit(); this.buttonX1.PerformClick(); 阅读全文
摘要:
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[proc_Generate_Rand_Bigint]') AND type in (N'P', N'PC'))DROP PROCEDURE [dbo]. 阅读全文
摘要:
update aaa set aaa.name = bbb.name from user_01 aaa left join user_02 bbb on aaa.code = bbb.code where bbb.name is not null; 阅读全文
摘要:
if not exists(select 1 from sys.servers where name='DBVIP') begin EXEC sp_addlinkedserver @server='DBVIP',--被访问的服务器别名(任意的名称) @srvproduct='', @provider 阅读全文
摘要:
select top 1 * from student order by newid() 阅读全文
摘要:
private void btnSelectPath_Click(object sender, EventArgs e) //弹出一个选择目录的对话框 private void btnSelectPath_Click(object sender, EventArgs e) //弹出一个选择目录的对话 阅读全文
摘要:
//Download by http://www.codefans.net using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Dra 阅读全文
摘要:
rank() over,dense_rank() over,row_number() over的区别 1.rank() over:查出指定条件后的进行排名。特点是,加入是对学生排名,使用这个函数,成绩相同的两名是并列,下一位同学空出所占的名次。 select name,subject,score,r 阅读全文
摘要:
CONVERT(VARCHAR(100), DATEADD(m, ( SELECT PeriodOfValidity FROM Info_CardType WHERE gInfo_CardTypeID = CardTypeID ), '2018-12-01'), 23) 阅读全文
摘要:
把列中凡是有2011的全部修改成2014,如 lieming 里的201101131431改成201401131431,写法: update tab set lieming = replace(lieming,'2011','2014'); update tab set lieming = repl 阅读全文