select * from sysmaintplan_plans select * from sysmaintplan_log select * from sysmaintplan_subplans
2.根据ID号删除相应的"维护计划" 代码如下:
delete from sysmaintplan_log where plan_id = ' ‘ delete from sysmaintplan_subplans where subplan_id = ' ' delete from sysmaintplan_plans where id = ' '
1、 代码如下: select top 10 * from ( select top (@Page * 10) ROW_NUMBER() OVER (order by id) as RowNum, id, username from Guest where username = 'user' ) as T where RowNum ((@Page - 1) * 10) 2、 代码如下: select * from ( select ROW_NUMBER() OVER(order by id) as RowNum,id,username from Guest where user...
服务里没了SQL启动服务,数据库也连不上。打开SQL Server Management Studio,在服务器名称中选择"浏览更多",出现的"本地服务器"中没有选项. 选择"配置工具"- "SQL Server 2005外围应用配置器",选择"服务和连接的外围应用配置器",报错: "在指定的计算机上找不到任何SQL Server 2005组件.该计算机上未安装任何组件,或者,您不是此计算机上的管理员...