if connection 2: COMMIT TRAN is done initially (in code)

and some err in connection 1

then connection 2: cannot not be rolled back right ?

I can't change the datatype from datetime to date.So is there any method like cast or anything?

ChrisM@Work (3/5/2013)

---

This is the simplest way to write it. If it generates dupes, then we'll change one side to a derived table. Can you use something a little more realistic...

Can use query instead of @SearchWord?? i dont think so

ChrisM@Work (3/5/2013)

---

INNER JOIN the two tables using LIKE. If that doesn't work, you will need to split out the words in 'checkout and play'. It will work but it won't...

Bhuvnesh (3/5/2013)

---

winmansoft (3/5/2013)

---

I have searching for a query that returns a row if column value contains result of another query. Its like "select * from table1 where col contains(select...

I will explain with example. I have a query "select work from entries1 WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'" and lets say it will return result

training

checkout

surfing

develop

...

I have another table...

Its just like "SELECT * FROM entries WHERE work IN (select work from entries1 WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013')". But IN matches with exact values from result column...

how to implement distributed transactions?

Thanks.

No,it is not mandatory to use the TOP and ORDER BY but they are required.. i can ditch order by by modifying query as "select min[a.date] from (select top 100...

I have to get min date from top 100 rows which satisfies date condition..If i do

select top 1 [date] from WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013' order by...

thanks for replies

We want sorting sometimes,I think we will stick to

select min[v.date]

from

(select top 100 [date]

from WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'

order by [date] desc) V

Anyone installed sql server 2008 R2 RTM in a Windows 8 pc?

Anyone plz reply me

I am installing sql server 2005 express together with my application because my application needs sql server for its working. So i choose silent mode install using command line in...