摘要:
select srvname,* from master.dbo.sysservers//创建linkServer exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','服务器名'//登陆linkServer exec sp_addlinkedsrvlog... 阅读全文
摘要:
delete a from ( select *,ps=row_number()over(PARTITION by cCaption order by getdate())from AA_ColumnDic where ckey='r003')a where a.ps=2 阅读全文
摘要:
update u_menuset issort=t1.rowIdfrom(--select * from--( select cmenu_id,ROW_NUMBER() over(Order by cmenu_id) as rowId from u_menu) as t1where t1.cmenu... 阅读全文
摘要:
/**功能:数据库备份*dbname:数据库名称*bakname:备份名称,包含完整路径*/usemasterBACKUPDATABASEdbnameTOdisk='c:\bakName'/**功能:数据库还原*@dbname:数据库名称*@bakname:备份名称,包含完整路径*/usemaste... 阅读全文
摘要:
1、判断是否存在addOneArticle这个存储过程if Exists(select name from sysobjects where NAME = 'addOneArticle' and type='P')drop procedure addOneArticle2、判断是否存在countAr... 阅读全文