Location:
Search - refno
Search list
Description: 在进行zigbee的无线定位时，参考节点的相应的代码，实现与定位节点的相互通信。-Zigbee wireless location when making reference to the corresponding node code and locate the node to achieve mutual communication.
Platform: |
Size: 4096 |
Author: xujun |
Hits:
Description: Alter FUNCTION [dbo].[split](@expression VarChar(max),@delimiter VarChar(30) = ' ')
RETURNS @TmpTable TABLE (RefNo VarChar(max))
AS
BEGIN
if rtrim(isnull(@expression,'')) > ''
begin
declare @cxml xml
set @cxml = '<x_k><![CDATA['+replace(@expression,@delimiter,']]></x_k><x_k><![CDATA[')+']]></x_k>'
insert into @TmpTable select ls.row.value('.[1]','varchar(max)') as refno--, identity(int,1,1) as idno
from @cxml.nodes('/x_k') as ls(row)
end
RETURN
END
GO(A SQL imitates the split function in VB to achieve a high efficiency by turning a text string into a data table.)
Platform: |
Size: 1024 |
Author: salonstarA |
Hits: