摘要:
如增加新闻:ALTER PROCEDURE [dbo].[news_insert] @title varchar(100),@content text,@caid intASBEGININSERT INTO news (title, [content], caId)VALUES (@title,@content,@caid)END根据内容搜索新闻:ALTER PROCEDURE [dbo].[news_selectByContent] @content varchar(1000) AS BEGIN select top 10 n.id,n.title,n.createTime,c.[name] 阅读全文