Search results for query: *

Never mind anyway...

Obviously I tried that...it redirects back to asp.net.

Where has IBuySpy gone? It used to be found at asp.net... Cheers, lfc77

If I have multiple table updates in a stored procedure and one fails, does this mean that the earlier updates are automatically rolled back, since the stored procedure is a block of code that is run as a whole? Cheers, lfc77

When did this forum change from Tek-Tips to Sarcastic-Tek-Tips??

Cheers Katy!

How can I view all triggers for a particular database? I'm currently trying to find if there are any triggers on a large number of tables by right clicking on the table > all tasks > manage triggers and it's taking forever. Can anybody help me out? Cheers, lfc77

How do you use sockets in C#? I need to convert some old VBScript code to C#, and I need to establish a socket connection to another machine and then send to it. Any assistance would be really appreciated. Cheers, lfc77

Found a good example here : http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=5

Does anybody have a simple example of appending text to a text file? Cheers, lfc77

DBomrrsm, Yes, all the string variables in my app are initialising to "" before I try to populate them with the contents of an XML file. If the relevant tag in the XML file is there, then I populate the string with it, otherwise I leave the string in the state it was in when it was...

This seems to work : UPDATE MyTable SET Column2 = CASE @Param2 WHEN '' THEN Column2 ELSE @Param2 END Cheers, lfc77

John, That isn't quite what I was trying to do. If the Param is empty, I DON'T want to update the field....is this possible? Cheers, lfc77

I have 9 different parameters which are coming in from an XML document, and they may or may not be entered by the user. When I am parsing the XML I am setting a string to the value of the relevant parameter, so if the value is entered by the user, the string will equal that value, otherwise the...

Cheers SQLSister...that could explain some of the problems we've been having with one of our websites. Thanks, lfc77

This would be the correct way to do this? CREATE PROCEDURE TESTPROC ( --PARAMETERS WILL GO HERE } AS DECLARE @DIV AS INTEGER INSERT INTO DIVISION(CUG, DIV_NAME, SUBCUG, AGENTID, EXDIRECTORY) VALUES (5790, 'TESTNAME', 1234, 1234, 1) SELECT @@IDENTITY AS '@DIV' INSERT INTO ADDRESS(CUG...

I need to write a stored procedure that inserts a record into 2 separate tables. However, the insert into the second table needs to take the auto incrementing primary key from the record inserted into the first table for one of its fields. Can anybody tell me how to do this? Any assistance...

I'm currently reading data from an XML file using XPathNavigator and XPathNodeIterator to select the subset of data that I want. I've never using the XPath objects before so I'm not sure how to get this data into a dataset. XPathDocument doc = new...

Obislavu, Your example loads a complete XML file into a dataset. What I need to do is select particular records in the XML file and then load those into the dataset (that's why I was using the XPath stuff, but maybe that's not the right way to do it?) lfc77

I'm currently reading data from an XML file using XPathNavigator and XPathNodeIterator to select the subset of data that I want. I've never using the XPath objects before so I'm not sure how to get this data into a dataset. XPathDocument doc = new...