Thanks for sharing...

But that's still going to have the same problem as PatIndex... For example... if you're looking for the word "GUID" or the word "DEFAULT" in a word document,...

How so?

Unfortunately... no... I don't. Sounds like you have everything you need to run it correctly.

GSquared (6/17/2008)

---

Matt Miller (6/17/2008)

---

I've done something like that with DTS a few times. For better or worse - I found it easier to have DTS handle the importing of...

karthikeyan (6/18/2008)

---

I have executed a query which has more number of ( around 500) string's in the IN clause. (All of us know IN will be treated internally as OR...

Syed (6/17/2008)

---

Also one problem with documentation (atleast places i have worked) is that initially documentation is created but after some time process is changed and no one updates the documentation....

Very well said.

Please see the following for how to do a numbered "split"

http://www.sqlservercentral.com/articles/T-SQL/63003/...

You may not have the privs to run it.

Open a Word document in a text editor like Notepad and let me know if you think a search for any word would actually work...;)

I suppose you could have someone write a CLR for this particular functionality.

You could assign them to "owners" other than DBO...

ola_blixten (6/17/2008)

---

Hey!

My case:

I want to generate 5 digit random numbers which should start with:

00001

00002

00003.....

and 2 digit for week so from 1-52

and 1 digit for year, from 0-9

And everyting should be...

OpenRowSet will not create a new file. It can be used to populate an existing file. Same goes with a text based linked server.

Bulk Insert will certainly do...

There were also some security enhancements that smack of deprecations... for example... sp_MakeWebTask now requires SA Privs to use...