vensgaldeepak.s (9/26/2012)

---

hi,i am working on a web application that has c#.net has front end and sql server as back end.

now they are telling me to take up DBA job....

nicoleaslater (9/26/2012)

---

I AM new, and I am grateful for your help. I am actually quite new at query writing as well and I often find exactly what I am...

jrichards54 (9/26/2012)

---

Sean Lange (9/25/2012)

---

jrichards54 (9/25/2012)

---

Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the...

No you are not asking the impossible but you did not post this like I suggested (ddl...

Oksana March (9/26/2012)

---

Sorry, my bad. Of course Dup is an exact copy of NestleComments which is a table I made for testing. I have corrected the original query.

Thanks everyone for...

nicoleaslater (9/26/2012)

---

I have a datetime (your standard yyyy-mm-dd hh:mm:ss) column and a varchar column that holds an appt time that looks like this: 1030 or 0735. I need...

You are welcome. I hope that gives you enough of a push in a direction to get done what you need.

Jonathan Marshall (9/26/2012)

---

I have worked with importing an XML file but not working with XSD files.

A client sent over a bunch of XSD files to analyze.

Can someone point...

Grant Fritchey (9/26/2012)

---

It's limited based on the available memory.

But why would you be nesting IF/ELSE statements to the limit of your memory capacity? It strikes me that you might be...

That is one of the most irritating things about sql server. There is a connect issue somewhere to change the message of that error to include the column name. DUH!!!...

maida_rh (9/26/2012)

---

[font="Arial Black"]I want to compare a column value if following char are in the string then need to split it ?

MY C# CODE :[/font]

string val = strtxt.Text.Trim();

...

Oksana March (9/26/2012)

---

Hi everyone,

I need help understanding something.

The situation is - I have a table that stores comments about shipments, and sometimes the same comment is in a table...

Are you sure that works?

For me it has errors. There's no such thing as "DELETE field FROM Table" as it will delete the entire row. And AFAIK you can't use...

jrichards54 (9/25/2012)

---

Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help...

jrichards54 (9/25/2012)

---

"Can you use ADODB instead of OLEDB?

I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual...