菜鸟求教存储过程，大牛们晒下代码。 晒者有分 ！

--编写create proc proc_nameasselect 1go--调用exec proc_name--这个算简单的不
------解决方案--------------------
SQL code
--创建create proc proc_abcasprint 'abc'--调用exec proc_abc
------解决方案--------------------
我支持初学者，但是你自己的看懂
SQL code
CREATE PROCEDURE proc_Page @Table VARCHAR(100), --表名 @Primarykey VARCHAR(100), --主键 @Condition VARCHAR(500), --查询条件 @PageNumber INT,   --开始页数 @PageSize INT,   --每页大小 @IsCount BIT   --是否获得记录数，0为否 AS    DECLARE @SQL VARCHAR(8000)    IF @IsCount != 0        SET @SQL = 'SELECT Count(*) FROM ' + @Table + ' WHERE ' + @Condition    ELSE      BEGIN        IF @PageNumber = 1            SET @SQL = 'SELECT TOP ' + STR(@PageSize) + ' SerialNum AS 流水号,PatientName AS 病人姓名,CheckDate AS 检查日期 FROM ' + @Table + ' WHERE ' + @Condition        ELSE            SET @SQL = 'SELECT TOP ' + STR(@PageSize) + ' SerialNum AS 流水号,PatientName AS 病人姓名,CheckDate AS 检查日期 FROM ' + @Table +            ' WHERE ' + @Primarykey + ' NOT IN (SELECT TOP ' + STR(@PageSize*(@PageNumber - 1)) + ' ' + @Primarykey + ' FROM ' + @Table + ' WHERE ' + @Condition +   ') AND ' + @Condition      END    EXEC(@SQL)     RETURN
------解决方案--------------------
来个复杂的
SQL code
create procedure TestProc@Id int, --参数1@Name varchar(50) --参数2as select @id,@Namego--调用exec TestProc @Id=18,@Name='张三'
------解决方案--------------------
探讨


引用:
来个复杂的

SQL code


create procedure TestProc
@Id int, --参数1
@Name varchar(50) --参数2
as
select @id,@Name
go

--调用
exec TestProc @Id=18,@Name='张三'


slect后面没有from关键字？
……

------解决方案--------------------
SQL code
CREATE PROCEDURE [dbo].[P_GetTableRecord2]   @TableName varchar(50)ASBEGIN  SET NOCOUNT ON  DECLARE @SQL varchar(500)  SET @SQL='IF OBJECT_ID([email protected]+''') IS NOT NULL '  SET @[email protected]+CHAR(10)+' SELECT COUNT(*) AS FRowCount FROM [email protected]  SET @[email protected]+CHAR(10)+'ELSE'  SET @[email protected]+CHAR(10)+' SELECT 0 AS FRowCount'  PRINT(@SQL)  exec(@SQL)  SET NOCOUNT OFFEND
------解决方案--------------------
SQL code
--得到服务器的IP地址create   proc [dbo].[getip]ascreate table #ip(id int identity(1,1),re varchar(200))declare @s varchar(1000) select @s= 'ping '+host_name()+' -a -n 1 -l 1'--set @s='ping '+left(@@servername,charindex('\',@@servername+'\')-1)+' -a -n 1 -l 1'insert #ip(re) exec master..xp_cmdshell @sselect IP地址=stuff(left(re,charindex(']',re)-1),1,charindex('[',re),'')from #ipwhere id=2drop table #ip