我做ADO.net程序始终用sql语句从没有用过存储过程,因为从没有成功过.... 把你从没有成功过ADO代码拿来看看 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这是查找的CREATE PROCEDURE stocklookup1 (@qidian char(20),@begintime datetime="1900-1-1",@endtime datetime="2050-1-1")asselect * from stocklookup where qidian=@qidian and rukushijian>=@begintime and rukushijian<=@endtimeGO 这是插入的CREATE PROCEDURE wangdiantifu1 (@shijian char(20),@yinghuijing money,@shihuijing money,@yingsoudingzhong money,@yukuen money,@waijiaoxenjing money,@waitihowu money,@wangdianmeng char(20),@wangdiandaima char(15)) AS insert into wangdianyunfu(shijian,yinghuijing ,shihuijing,yingsoudingzhong,yukuen,waijiaoxenjing,waitihowu,wangdianmeng,wangdiandaima)values(@shijian,@yinghuijing ,@shihuijing,@yingsoudingzhong,@yukuen,@waijiaoxenjing,@waitihowu,@wangdianmeng,@wangdiandaima)GO 这写存储过程是放在sql server上呢,还是在.net程序代码里 我觉得应买一本sql server的书学一下 游戏的主要编程语言 DLL调用主程序函数后能调用成功但是主程序报错”尝试读取或写入受保护的内存“ WPF代码中的一些小问题 求教 初来论坛0分求助.算法问题. 数据库编程的基础问题 奇怪的问题,各位帮帮忙! c#中的DataSet 写入数据库时出现的异常 网页首次登录的指引操作如何处理 c#,关于后台多线程问题 C#中如何实现自定义事件? 高分求C#输出问题!(任意分值,谢谢!)
CREATE PROCEDURE stocklookup1
(
@qidian char(20),
@begintime datetime="1900-1-1",
@endtime datetime="2050-1-1"
)
as
select * from stocklookup where qidian=@qidian and rukushijian>=@begintime and rukushijian<=@endtime
GO
CREATE PROCEDURE wangdiantifu1
(
@shijian char(20),
@yinghuijing money,
@shihuijing money,
@yingsoudingzhong money,
@yukuen money,
@waijiaoxenjing money,
@waitihowu money,
@wangdianmeng char(20),
@wangdiandaima char(15)
)
AS insert into wangdianyunfu
(
shijian,
yinghuijing ,
shihuijing,
yingsoudingzhong,
yukuen,
waijiaoxenjing,
waitihowu,
wangdianmeng,
wangdiandaima
)
values
(
@shijian,
@yinghuijing ,
@shihuijing,
@yingsoudingzhong,
@yukuen,
@waijiaoxenjing,
@waitihowu,
@wangdianmeng,
@wangdiandaima
)
GO