存储过程-前台

Create proc [dbo].[ P_ZZ_SelectVGuestLike]
/*************************************************
**FN:夜审处理
**TIME:
***CHARINDEX函数返回字符或者字符串在另一个字符串中的起始位置
*** CHARINDEX('SQL', 'Microsoft SQL Server')
***这个函数命令将返回在“Microsoft SQL Server”中“SQL”的起始位置，在这个例子中，CHARINDEX函数将返回*** S在“Microsoft SQL Server”中的位置11。
*** 找不到 CHARINDEX返回零
**************************************************/
(
    @name nvarchar(50),
    @nHotelId int
)
as
begin
    select top 100 * from C_VirtualGuest where charindex(@name,cName)>0
end

 

-- =============================================
-- Author:        <Author,,Name>
-- Create date: <Create Date,,>
-- Description:    <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[LSW_GetTableColInfo]
    -- Add the parameters for the stored procedure here
        @TableName nvarchar(50)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT 
    Sysobjects.name AS [表名], 
    syscolumns.name AS [列名], 
    systypes.name AS [数据类型], 
    syscolumns.length AS [字段长度], 
    sys.extended_properties.[value] AS [字段描述], 
    syscomments.text AS [默认值], 
    CASE syscolumns.isnullable WHEN '1' THEN 'Y' ELSE 'N' END AS [是否允许空值], 
    ISNULL(COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'Scale'), 0) AS [小数位数], 
    COLUMNPROPERTY(syscolumns.id, syscolumns.name, 'IsIdentity') AS [自增标识] , 
    CASE WHEN EXISTS (SELECT 1 FROM sysobjects WHERE xtype = 'PK' AND name IN 
    (SELECT name 
    FROM sysindexes 
    WHERE indid IN 
    (SELECT indid 
    FROM sysindexkeys 
    WHERE id = syscolumns.id AND colid = syscolumns.colid))) 
    THEN '√' ELSE '' END AS [主键] 
    FROM syscolumns 
    INNER JOIN systypes 
    ON syscolumns.xtype = systypes.xtype 
    LEFT JOIN sysobjects ON syscolumns.id = sysobjects.id 
    LEFT OUTER JOIN sys.extended_properties ON 
    ( sys.extended_properties.minor_id = syscolumns.colid 
    AND sys.extended_properties.major_id = syscolumns.id) 
    LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id 
    WHERE (systypes.name <> 'sysname') 
    AND syscolumns.id IN (SELECT id FROM SYSOBJECTS WHERE xtype = 'U' AND NAME = @TableName) --仅查某表，否则注释掉本行为全库 
    ORDER BY [表名],[列名]
END