|
|
-
Patrick Lambin Liked 5 Months ago through Just Learned | 1 Point
This short tip is a result of my quick research in attempt to solve this MSDN thread
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f02aefbd-09a5-4336-84d2-d67bdf238221
In order to use case sensitive search with PATINDEX we need to...
|
-
Patrick Lambin Learned 5 Months ago through Just Learned | 1 Point
This short tip is a result of my quick research in attempt to solve this MSDN thread
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f02aefbd-09a5-4336-84d2-d67bdf238221
In order to use case sensitive search with PATINDEX we need to...
|
-
Patrick Lambin Commented 11 Months ago through Just Learned | 1 Point
trailing spaces = spaces at the end of the string ? I do think so.
for a fixed (N)char(m) string, the stored value is including the spaces needed to have the m correct length.
for a (n)VarChar(m) string, the spaces at the end of the values are rubbed ...
|
-
Patrick Lambin Commented 11 Months ago through Just Learned | 1 Point
trailing spaces = spaces at the end of the string ? I do think so.
for a fixed (N)char(m) string, the stored value is including the spaces needed to have the m correct length.
for a (n)VarChar(m) string, the spaces at the end of the values are rubbed ...
|
-
Patrick Lambin Liked 11 Months ago through Just Learned | 1 Point
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Patrick Lambin knew 11 Months ago through Just Learned | 1 Point
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Patrick Lambin Liked 11 Months ago through Just Learned | 1 Point
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Patrick Lambin knew 11 Months ago through Just Learned | 1 Point
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ...
|
-
Patrick Lambin Commented 12 Months ago through Just Learned | 1 Point
According to
http://msdn.microsoft.com/en-us/library/ms176104.aspx
part $IDENTITY , but i recognize that it is not clear .So it is possible i have not understood what it is written
"If more than one table in the FROM clause has a column with the IDE...
|
-
Patrick Lambin Commented 12 Months ago through Just Learned | 1 Point
According to
http://msdn.microsoft.com/en-us/library/ms176104.aspx
part $IDENTITY , but i recognize that it is not clear .So it is possible i have not understood what it is written
"If more than one table in the FROM clause has a column with the IDE...
|