摘要:
CREATE FUNCTION [dbo].[GetMaxLevel]()
RETURNS INT
AS
BEGIN DECLARE @maxLevel INT; SET @maxLevel = 1; DECLARE @level INT ; DECLARE @parentidVal NVARCHAR(50); DECLARE @natureid NVARCHAR(5... 阅读全文
posted @ 2015-01-21 15:34
Space Tian
阅读(341)评论(0)推荐(0)
摘要:
字符串拆分: ALTER FUNCTION [dbo].[f_Split](@sText nvarchar(max),@split NVARCHAR(20))
RETURNS @t TABLE (idx INT IDENTITY(1,1) Primary Key , [value] nvarchar(4000))
AS
BEGIN DECLARE @temp NVARCHAR(1000)... 阅读全文
posted @ 2015-01-14 15:37
Space Tian
阅读(336)评论(0)推荐(0)