I'm pretty sure this can't be done reliably. Sure,...

I guess I'd have to ask... what does the CLR and the C# function do?

So far, the only place I've seen CLR's beat T-SQL is in the area of RegEx Replace...

Absolutely! First, I'd make bloody sure that the source code was in a...

dolly (7/30/2008)

---

In my web based application Identity column is duplicated when simultaneously record are inserted by different machine

(i think so) i will solution for handling...

Without a whole lot more information ;), my answer would be... change it so it doesn't do that anymore. 🙂

You might want to conscribe any XML to the VARCHAR(MAX)...

It's a paradigm shift... with Cursors, you think "rows"... with setbased programming, you must learn to think "columns"... as in "What do I need to do to this column for...

Lemme get this straight, Carl... you think it's better for the app to write and pass data in the forum of Unioned SELECT statements than to pass a comma seperated...

Heh... WHICH forum discussions would you be talking about? You have precisely 1...

Which edition of SQL Server 2005 are you trying to install?

Venkatesan Prabu (8/17/2008)

---

create table FirstTable(Attrib1 varchar(10), Attrib2 varchar(10),Attrib3 varchar(10))

insert into FirstTable values('Doc1','Attrib1','val1')

insert into FirstTable values('Doc2','Attrib2','val2')

insert into FirstTable values('Doc3','Attrib3','val3')

insert into FirstTable values('Doc4','Attrib4','val4')

select * from FirstTable

create table SecondTable(Attrib2 varchar(10),Attrib22 varchar(10))

insert into SecondTable...

GilaMonster (8/17/2008)

---

SQL 2000-related questions should rather be posted in the SQL 2000 forums in future please.

FirstTable has 1 lakh record , Second table has 2 Lakh record and Third...

Please post the link where you found the pricing so we can figure out what you mean by the "OEM" version because, to the best of my knowledge, nothing is...

masood24 (8/17/2008)

---

hello dear 1st thank you very much for help but I have tried the query but it is not working message is successful with 1 row changed but actually...

Heh... that's known as a "Headerless Ragged Right" file and they're a bugger to import correctly. BCP and BULK insert require that all the rows have the same number...