SQL SERVER性能问题求助专家解答,在线等
SELECT TOP 100 k_task.taskguid, k_task.taskcode,
k_task.topic, k_task.taskType,
k_task.sldate, k_Receive.tsFcInfo,
k_Receive.requestMan, k_task.Status
,k_Receive.CstName,k_Receive.BUGUID
from k_task INNER JOIN k_Receive ON k_task.receiveguid = k_Receive.ReceiveGUID
WHERE (k_task.ProjGUID in
('20ee7748-63ca-4289-bc9c-de828b9cbd21','21983bc9-118c-46fe-a487-36222fc3dd81','73338871-91c5-4bdc-86ea-835a669526d2','9d56e8f3-5c6f-44a9-9c23-0f5a41cab158','6bf0dad2-a2f3-4ec4-8f0d-cf928c587c3b','667d9a97-d140-429e-b5ff-408121258e19','c6d17027-37d7-4e4d-8c85-6a4f43c3639c','a3c80652-13e8-4c9a-8c0b-6eb0a6b961e6','47ec8614-5028-4179-8b82-879fda147263','e3ad8a04-522e-4fd1-baf3-e7e683b002cb','ba54b3a7-d25a-41cf-b9cb-7e4dcf0627d9','9848d95c-3ad0-48f4-9a44-c75288b0a3e7','3879220a-b45d-4da9-ad4d-97e6632a2fed'))
AND k_task.TaskRange = '日常服务'
AND k_task.IsZbcl = 0
ORDER BY k_task.SlDate desc, k_task.TaskCode DESC
非聚集索引 建在 ProjGUID、TaskRange、Is
相关问答:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
如何在SQL2005中设定定时作业,比如说定时清理某些表的数据,
或者是定时的将某些表的数据导出excel!
在线等待,急急急,最好是详细步骤!
之前我做的作业有点问题!
帮UP
参考:http://hi.baidu.com/toiota ......
哪位仁兄有功能完整可用的SQL下载地址呢,我有一个地址,但是安装后功能不完整无法使用(没有服务器)我知道的地址是
http://down.xlylw.com/downlist/s_66_1.html
看来,你只能到网上自己搜索了!
自己动手就可 ......
第一句:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht. ......