O tempora, o mores

From The Bible, Old Testament Ecclesiastes iii

To every thing there is...

There is no magic about udf's or stored procedures

create procedure showsp

as

select * from ::fn_helpcollations()

go

exec showsp

drop procedure showsp

But as this is a very broad topic, I suggest to first take...

Now, if you want to read the text, you can only do this when you have stored only the text.

When you have stored the file and want to read the text,...

Sorry, this one is better. Especially the chapter on 'Large Address space'

http://download.microsoft.com/download/5/2/5/525343cc-7ba4-4e3b-a96a-c7a040d98d2d/IPv6.doc

A string of 100k length? What are you trying to do?

Maybe this will help you http://www.sommarskog.se/dynamic_sql.html

I guess you know this already?

http://www.microsoft.com/windowsserver2003/technologies/ipv6/default.mspx

Oops, really? Yes, memory weakness

Now, isn't that nice from Erland 

Still trying to figure it out, but I think, Mark, your solution does not account for the Access LIKE comparison, or am I blind?

If that happened on a production box, I suggest reviewing your security and permission policy and have an interview with that programmer

Do you want to store the whole file or just the text?

Why do you need a cursor?

set nocount on

if object_id('myIdentity') is not null

drop table myIdentity

if object_id('myresult') is not null

drop table myresult

declare @i int

set @i = 10

create table myidentity(id int identity(1,1), col1...

Are you looking for something like this?

set nocount on

if object_id('MyIdentity') is not null

drop table MyIdentity

create table myidentity(id int identity(1,1), col1 char(1))

declare @i int

set @i=10

insert into myidentity(col1) values('a')

insert into myidentity(col1) values('b')

insert...

Yes, 01/01/1900 is SQL Server's reference date (day 0). All other dates are calculated as days before or after this date

I, too, cannot reproduce your case

if object_id('abc') is not null

drop...

You can use CASE.

BOL has some examples on this

Like Gary said, there is actually no real need for inserting a column at a specific position.

However, you should place fixed-length columns first, followed by variable-length ones. Within the variable...