摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->ALTER procedure [dbo].[GetUserList](@iid int) AS BEGIN DECLARE @tmp NVARCHAR(max); SET @tmp=... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->ALTER PROC [dbo].[BACKUP_DATABASE] (@file NVARCHAR(255)) AS BEGIN DECLARE @dbname NVARCHAR(255) D... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->/* 系统存储过程 描述 sp_columns 返回指定表或视图的列的详细信息。 sp_databases 返回当前服务器上的所有数据库的基本信息。 sp_fkeys 若参数为带有主键的表... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> CREATE proc [dbo].[page] @RecordCount int output, @ReturnCount bit, @QueryStr nva... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> CREATE PROCEDURE [dbo].[up_Page2005V2_Join] @TableName varchar(150), --表名 @Fiel... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->alter PROCEDURE [dbo].[up_Page2005V2] @TableName varchar(50), --表名 @Fields varcha... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[up_Page2005] @TableName v... 阅读全文
摘要:
Code Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->--列转字符串 declare @str nvarchar(4000) set @str='' select @str=@str + userid + ',' from com_ope... 阅读全文
摘要:
Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> Create function [dbo].[Fun_GetPY] ( @str nvarchar(4000), @rstat bit ... 阅读全文
摘要:
Code Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> SELECT * FROM CMlinkman Where id not in (SELECT min(id) FROM CMlinkman group by cid) 阅读全文
摘要:
Code Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> Create function [dbo].[f_split](@SourceSql varchar(8000),@StrSeprate varchar(10)) ... 阅读全文