|
|
-
RobinJain Question Received 6 Months ago through ASK
I want wildcard character to search Match & March at the same time in indexing service. I am trying it with following query:
Select * from Table_Name WHERE CONTAINS(Column_Name, '"Ma*ch"') Or
Select * from Table_Name WHERE CONTAINS(Column_Name, '"Ma?...
|
-
Leonid Koyfman Learned 10 Months ago through Just Learned
While some functions do not allow subqueries as part of parameter, some do allow as seen below
[code]
select day(
(
select max(date)
from (
select getdate() as date
union all
select getda...
|
-
Leonid Koyfman Liked 10 Months ago through Just Learned
While some functions do not allow subqueries as part of parameter, some do allow as seen below
[code]
select day(
(
select max(date)
from (
select getdate() as date
union all
select getda...
|
|
|
-
Leonid Koyfman Liked 11 Months ago through Just Learned
While some functions do not allow subqueries as part of parameter, some do allow as seen below
[code]
select day(
(
select max(date)
from (
select getdate() as date
union all
select getdate(
|
|
|
-
Leonid Koyfman Commented 1 Years ago through Blogs
The important part is that exec tempdb..sp_help '#t' is session specific.
If we run in 2 sessions
create table #t(i int)
exec tempdb..sp_help '#t'
we'll get 2 different results. Something similar to
#t____________________________0000000000AB
...
|
-
Leonid Koyfman Commented 1 Years ago through Blogs
The important part is that exec tempdb..sp_help '#t' is session specific.
If we run in 2 sessions
create table #t(i int)
exec tempdb..sp_help '#t'
we'll get 2 different results. Something similar to
#t____________________________0000000000AB
...
|
|
|
|
|