什么是从sql server 2008中的字符串读取的有效方法 [英] what is efficent way to read from string in sql server 2008

问题描述

大家好我想从sql server 2008中的字符串中读取一些特定数据我需要帮助让我知道什么是有效的阅读方法。我的字符串也包含该特定的单词，并以新行结束。

Hi all i want to read some specific data from string in sql server 2008 i need help let me know what is efficient way to read it.my string also contains that specific word and also end with new line.

Declare @string as nvarchar(max)
declare @Head as nvarchar(100)
declare @HeadDetail as nvarchar(500)
Declare @Host as nvarchar(500)
Declare @Connection as nvarchar(500)
Declare @Referer as nvarchar(500)
set @string=
'OPTIONS /Ads/PageTerms/GetTerms HTTP/1.1
Host: apps.developermedia.com
Connection: keep-alive
Cache-Control: max-age=0
Access-Control-Request-Method: POST
Origin: http://www.codeproject.com
User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML. like Gecko) Chrome/38.0.2125.111 Safari/537.36
Access-Control-Request-Headers: content-type
Accept: */*
Referer: http://www.codeproject.com/Articles/25600/Triggers-SQL-Server
Accept-Encoding: gzip.deflate.sdch
Accept-Language: en-US.en;q=0.8.ru;q=0.6

'

print 'Host: apps.developermedia.com'
print 'Referer: http://www.codeproject.com/Articles/25600/Triggers-SQL-Server'

我可以通过这个输入以这种方式打印数据@字符串和所有其他必要字段。

任何帮助都将非常感激。

can i print data in this way from this input @string and all other necessary fields.
Any Help will be really appreciated.

推荐答案

检查这个

check this

Declare @string as nvarchar(max)
declare @Head as nvarchar(100)
declare @HeadDetail as nvarchar(500)
Declare @Host as nvarchar(500)
Declare @Connection as nvarchar(500)
Declare @Referer as nvarchar(500)
set @string=
'OPTIONS /Ads/PageTerms/GetTerms HTTP/1.1
Host: apps.developermedia.com
Connection: keep-alive
Cache-Control: max-age=0
Access-Control-Request-Method: POST
Origin: http://www.codeproject.com
User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML. like Gecko) Chrome/38.0.2125.111 Safari/537.36
Access-Control-Request-Headers: content-type
Accept: */*
Referer: http://www.codeproject.com/Articles/25600/Triggers-SQL-Server
Accept-Encoding: gzip.deflate.sdch
Accept-Language: en-US.en;q=0.8.ru;q=0.6
 
'
declare @charindexloc int,@charindexlocNext int,@lengthOfString int

select @charindexloc=CHARINDEX('Host:',@string)
select @lengthOfString=LEN(@string)
select @charindexlocNext=CHARINDEX(CHAR(10),Substring(@string,@charindexloc,@lengthOfString))

select SUBSTRING(@string,@charindexloc,@charindexlocNext) As Host
 
select @charindexloc=CHARINDEX('Referer:',@string)
select @lengthOfString=LEN(@string)
select @charindexlocNext=CHARINDEX(CHAR(10),Substring(@string,@charindexloc,@lengthOfString))

select SUBSTRING(@string,@charindexloc,@charindexlocNext) As Referer

这篇关于什么是从sql server 2008中的字符串读取的有效方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！