sql 储存过程的使用
时间:2022-03-10 17:19
-<span style= "background-color: rgb(255, 255, 0);" >-获取所有数据 根据自定义函数传人类型id返回类型名称</span> USE [Cloths] GO /****** Object: StoredProcedure [dbo].[Proc_all] Script Date : 05/23/2014 12:10:37 ******/ SET
ANSI_NULLS ON GO SET
QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Proc_all] AS BEGIN SET
NOCOUNT ON ; select
ClothColorId , Name
,<span style= "background-color: rgb(255, 0, 0);" >dbo.myfun1(TypeId)</span> as
typename from
dbo.ClothColors; END |
这些储存过程都是修改的,吧ALTER改为create 就可以在数据库中创建
USE [Cloths] GO /****** Object: UserDefinedFunction [dbo].[myfun1] Script Date : 05/23/2014 13:53:46 ******/ SET
ANSI_NULLS ON GO SET
QUOTED_IDENTIFIER ON GO <span style= "background-color: rgb(255, 255, 0);" > --自定义函数</span> ALTER FUNCTION [dbo].[myfun1] ( @a varchar (50) ) returns
varchar (50) as begin declare
@ name varchar (50); select
@ name =[types]. name
from [types] where
typeid=@a; return
@ name ; end |
//既有传人参数,又有返回参数
USE [Cloths] GO /****** Object: StoredProcedure [dbo].[Proc_all] Script Date : 05/23/2014 13:56:48 ******/ SET
ANSI_NULLS ON GO SET
QUOTED_IDENTIFIER ON GO<br> --<span class="syntaxhighlighter csharp ie">
sql 储存过程的使用,布布扣,bubuko.com 相关推荐
电脑软件热门排行今日推荐热门手游 |