两表操作问题 不一定需要存储过程,写一个SQL语句就可以 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 写存储过程逻辑会清晰点-- =============================================-- Create procedure basic template-- =============================================-- creating the store procedureIF EXISTS (SELECT name FROM sysobjects WHERE name = N'<procedure_name, sysname, proc_test>' AND type = 'P') DROP PROCEDURE <procedure_name, sysname, proc_test>GOCREATE PROCEDURE <procedure_name, sysname, proc_test> <@param1, sysname, @p1> <datatype_for_param1, , int> = <default_value_for_param1, , 0>, <@param2, sysname, @p2> <datatype_for_param2, , int> = <default_value_for_param2, , 0>AS SELECT @p1, @p2//把所有逻辑加到这里,并替换掉模板参数就可以了GO-- =============================================-- example to execute the store procedure-- =============================================EXECUTE <procedure_name, sysname, proc_test> <value_for_param1, , 1>, <value_for_param2, , 2>GO sql 语句 返回时间的问题 学习程序设计,到底需不需要顺序呢? 关于connect pool! 用asp.net写的ftp不支持中文目录 实习生求救 asp.net中数据导入excel中,excel文件却不能显示,但任务管理器中却有此进程excel.exe? extjs学习方法讨论 web.conf错误 使用com控件时,有些控件的方法无动态提示? 怎么看范例? 留言本 window.showModalDialog("Dialog.aspx");传递参数的问题
-- =============================================
-- Create procedure basic template
-- =============================================
-- creating the store procedure
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'<procedure_name, sysname, proc_test>'
AND type = 'P')
DROP PROCEDURE <procedure_name, sysname, proc_test>
GOCREATE PROCEDURE <procedure_name, sysname, proc_test>
<@param1, sysname, @p1> <datatype_for_param1, , int> = <default_value_for_param1, , 0>,
<@param2, sysname, @p2> <datatype_for_param2, , int> = <default_value_for_param2, , 0>
AS
SELECT @p1, @p2
//把所有逻辑加到这里,并替换掉模板参数就可以了
GO-- =============================================
-- example to execute the store procedure
-- =============================================
EXECUTE <procedure_name, sysname, proc_test> <value_for_param1, , 1>, <value_for_param2, , 2>
GO