随笔分类 - MsSql
摘要：--包含数字SELECT * FROM Log WHERE LogInfo LIKE '%[0-9]%'--不包含数字SELECT * FROM Log WHERE LogInfo NOT LIKE '%[0-9]%'
阅读全文
摘要：Select identity(int,1,1) as iid,* into tmpTableName from TableNameSelect * from tmpTableNamedrop table tmpTableName
阅读全文
摘要：CREATE PROCEDURE [dbo].[P_MissiveRights]-- Add the parameters for the stored procedure here@UserCode varchar(50) ASBEGINSET NOCOUNT ON;declare @UserBiaoShi intdeclare @id intdeclare @sql0 nvarchar(400...
阅读全文
摘要：表值函数返回值是一个表。CREATEFUNCTION [dbo].[Split] (@str nvarchar(max),@spliter nvarchar(10))returns @tb table(Tmp nvarchar(256)) ASBEGINDECLARE @Num int,@Pos int, @NextPos intSET @Num = 0SET @Pos = 1WHILE(@Pos...
阅读全文
摘要：所谓标量函数指的就是此函数只返回一个值。--返回一个int值CREATE FUNCTION [dbo].[FilterCount](@Para1 int,@Para2 int)RETURNS int ASBEGINDECLARE @Result int;SELECT @Result=COUNT(*) FROM [Table] WHERE Field1=@Para1 AND Field2=@Para...
阅读全文
摘要：A、链接SQL Server服务器:1、使用 ODBC 的 Microsoft OLE DB 提供程序EXEC sp_addlinkedserver '别名','','MSDASQL',NULL,NULL,'DRIVER={SQL Server}; SERVER=远程名; UID=用户; PWD=密码; 'goexec sp_addlinkedsrvlogin @rmtsrvname='别名',@...
阅读全文
摘要：1. Select Top PageSize * From Table where biaoshi not in (Select Top (PageIndex-1)*PageSize biaoshi From Table )2.CREATE PROCEDURE [dbo].[UP_Common_Pager](@tblName nvarchar(255), -- 表名@Fields nvarchar...
阅读全文
摘要：过程片段: declare master_cursor CURSOR FOR select hangbiaoshi from tab_Test order by hangbiaoshi desc open master_cursor FETCH NEXT FROM master_cursor into @hangbiaoshi while @@fetch_status = 0 BEGIN...
阅读全文
摘要：1.表变量 DECLARE @indextable table ( uid int identity(1,1), id int ) 2.临时表 CREATE Table #temptable ( id int, date datetime ) 当...
阅读全文
摘要：cast(cast(分子*1.0*100/分母 as decimal(10,2)) as varchar(50)) +'%'
阅读全文
