I want to protect some column which are sensitive.

demonfox (3/8/2013)

---

okay, If your requirement is to have a column where in currency symbols has to be type in then go with varchar ..

or you can have a Currency Code...

jformosa (3/11/2013)

---

Hi Winmasoft,

I had similar questions to these:

"then what is the use of inserting currency symbol?? And your link has list of symbols. How can i type symbols other than...

I found this in your link

It is important to remember that while you...

That will...

ChrisM@Work (3/7/2013)

---

winmansoft (3/7/2013)

---

ChrisM@Work (3/7/2013)

---

yes - do this instead:

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'seh,jyo,mhf'

SELECT *

INTO #Elements

FROM dbo.DelimitedSplit8K (@Parameter,',')

SELECT...

ChrisM@Work (3/7/2013)

---

yes - do this instead:

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'seh,jyo,mhf'

SELECT *

INTO #Elements

FROM dbo.DelimitedSplit8K (@Parameter,',')

SELECT m.*

FROM reminder.dbo.Reminder...

Thank you

I found that i can do this

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = 'seh,jyo,mhf'

DECLARE @Elements TABLE

(

...

Sorry for my misunderstanding..solutions suggested will work for those condition.. I have to get minimum date from top 100 max dates. Any query work for this?

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...