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. ......
