两个在存储过程(CPU,读磁盘占用很多)的优化? 需要提供一些典型的测试数据才好判断,(1)表dbo.edu_Contents、dbo.web_News的数据,(2)传入两个存储过程的参数是什么样式的,(3)这些参数是从哪里得到的,应用系统的界面,还是在其他存储过程中查表查出来的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 既然要LIKE,为什么要AS NVARCHAR,应该直接设计为NVARCHAR是个设计问题,非单纯SQL语句问题 而传递过来的@UnitID 是个字符串 如:"12,32,45,34,36,27,76,87"等 但c.EduUnitID是一个数字,所以只能用like 请问还有其它办法吗 CREATE TABLE [edu_Contents] ([ID] [uniqueidentifier] NOT NULL,[Title] [nvarchar] (200) NULL,[CategoryID] [uniqueidentifier] NULL,[Content] [ntext] NULL,[CententPhotosUrl] [varchar] (100) NULL,[Source] [varchar] (200) NULL,[TypeId] [int] NULL,[ClickCounts] [int] NULL DEFAULT (0),[IsEnable] [bit] NULL,[Sort] [int] NULL,[ImgPath] [varchar] (100) NULL,[PublisherUser] [varchar] (50) NULL,[PublishTime] [datetime] NOT NULL DEFAULT (getdate()),[EditUser] [varchar] (50) NULL,[EditTime] [datetime] NULL,[EduUnitID] [int] NOT NULL,[SchoolIdList] [text] NULL,[RelayMenu] [text] NULL,[NewsState] [varchar] (50) NULL,[xj_IsLocalNet] [bit] NULL DEFAULT (0))INSERT [edu_Contents] ([ID],[Title],[CategoryID],[Content],[Source],[TypeId],[ClickCounts],[IsEnable],[Sort],[PublisherUser],[PublishTime],[EditTime],[EduUnitID],[RelayMenu],[NewsState],[xj_IsLocalNet]) VALUES ( N'f6872494-945f-4921-98fe-00089b661282',N'标题',N'3ee708b3-7759-4004-9d81-440c48f91fa2',N'新闻内容',N'000180',1,0,1,0,N'100021',N'2014/7/18 17:03:50',N'2014/7/18 17:05:23',207,N'9bb9924c-a8c6-42ca-9117-a39c212827dc|35395571-f641-4aca-aade-998548f3abe1,3ee708b3-7759-4004-9d81-440c48f91fa2|f6872494-945f-4921-98fe-00089b661282',N'0',0)INSERT [edu_Contents] ([ID],[Title],[CategoryID],[Content],[Source],[TypeId],[ClickCounts],[IsEnable],[Sort],[PublisherUser],[PublishTime],[EditUser],[EditTime],[EduUnitID],[SchoolIdList],[RelayMenu],[NewsState],[xj_IsLocalNet]) VALUES ( N'92f71088-1c51-47ba-bcc9-000c6e495b82',N'标题',N'12bced70-5246-42e3-a0c4-49fd0c4b8e8d',N'新闻内容',N'000001000001',1,49,1,0,N'123456',N'2013/11/29 9:53:07',N'123456',N'2013/11/29 9:53:07',6,N'a3489578-877f-48a9-9881-f39c6a4a5ac1,dfd4fc10-9df5-4f73-b4b1-94e27075c9f4|dbff9b69-96ee-4258-967a-a9cabbf2d94e',N'0',0) 此sql语句如何编写? 高分求SQL问题!!!! General SQL error具体见下,到底是什么错误呢? 正则匹配最大相同字符串求助 求一SQL语句 sql server2000 执行.sql脚本的问题 难题啊 帮忙看下这么简单的语句会出错呢 列动态相乘. 能不能用sql查到当前有哪些表被哪些用户锁住了? 关于sqlserver数据库权限问题 SqlServer 怎样实现动态视图查询多个库的数据
是个设计问题,非单纯SQL语句问题
[ID] [uniqueidentifier] NOT NULL,
[Title] [nvarchar] (200) NULL,
[CategoryID] [uniqueidentifier] NULL,
[Content] [ntext] NULL,
[CententPhotosUrl] [varchar] (100) NULL,
[Source] [varchar] (200) NULL,
[TypeId] [int] NULL,
[ClickCounts] [int] NULL DEFAULT (0),
[IsEnable] [bit] NULL,
[Sort] [int] NULL,
[ImgPath] [varchar] (100) NULL,
[PublisherUser] [varchar] (50) NULL,
[PublishTime] [datetime] NOT NULL DEFAULT (getdate()),
[EditUser] [varchar] (50) NULL,
[EditTime] [datetime] NULL,
[EduUnitID] [int] NOT NULL,
[SchoolIdList] [text] NULL,
[RelayMenu] [text] NULL,
[NewsState] [varchar] (50) NULL,
[xj_IsLocalNet] [bit] NULL DEFAULT (0))INSERT [edu_Contents] ([ID],[Title],[CategoryID],[Content],[Source],[TypeId],[ClickCounts],[IsEnable],[Sort],[PublisherUser],[PublishTime],[EditTime],[EduUnitID],[RelayMenu],[NewsState],[xj_IsLocalNet]) VALUES ( N'f6872494-945f-4921-98fe-00089b661282',N'标题',N'3ee708b3-7759-4004-9d81-440c48f91fa2',N'新闻内容',N'000180',1,0,1,0,N'100021',N'2014/7/18 17:03:50',N'2014/7/18 17:05:23',207,N'9bb9924c-a8c6-42ca-9117-a39c212827dc|35395571-f641-4aca-aade-998548f3abe1,3ee708b3-7759-4004-9d81-440c48f91fa2|f6872494-945f-4921-98fe-00089b661282',N'0',0)
INSERT [edu_Contents] ([ID],[Title],[CategoryID],[Content],[Source],[TypeId],[ClickCounts],[IsEnable],[Sort],[PublisherUser],[PublishTime],[EditUser],[EditTime],[EduUnitID],[SchoolIdList],[RelayMenu],[NewsState],[xj_IsLocalNet]) VALUES ( N'92f71088-1c51-47ba-bcc9-000c6e495b82',N'标题',N'12bced70-5246-42e3-a0c4-49fd0c4b8e8d',N'新闻内容',N'000001000001',1,49,1,0,N'123456',N'2013/11/29 9:53:07',N'123456',N'2013/11/29 9:53:07',6,N'a3489578-877f-48a9-9881-f39c6a4a5ac1,dfd4fc10-9df5-4f73-b4b1-94e27075c9f4|dbff9b69-96ee-4258-967a-a9cabbf2d94e',N'0',0)