Viewing 15 posts - 31 through 45 (of 98 total)
Do you get this message when in query analyzer and the stored proc window?
February 28, 2002 at 2:12 pm
Another option which might be a little overkill, would be to use the odbc text driver to access the file as a recordset. Then just check the value of...
February 28, 2002 at 2:10 pm
Not sure a join will return the same hierarchy as using the shape provider. Depending on the amount of data returned and the frequency it is queried, you could...
February 27, 2002 at 6:31 pm
Another approach would be to return the data as xml. Then, using client side script, resort the data. This way there is only one call to the db...
February 27, 2002 at 6:26 pm
Off the top of my head, try using the 'if exists' keywords to control what is queried.
i.e.
If exists(select * from table1)
begin
select serialnumber, (select * from table1) from table 3 where...
February 25, 2002 at 7:42 pm
Are you experiencing problems when doing multiple updates? If so, select everything from the inserted table into a cursor, then loop through the cursor to do the updates.
February 5, 2002 at 3:25 pm
Not sure I'm clear on your problem. Is your problem in returning the query or populating the drop down with the correct values?
January 31, 2002 at 5:40 pm
ADO.NET is definitly not overkill. ADO.NET is simply the next version of ADO. Its SqlDataReader and SqlCommand objects provides a low resource intensive method for selecting, inserting and...
January 31, 2002 at 5:37 pm
Depending what you want to do with the results of the stored proc, you can execute it in an ActiveX Script task as well.
January 30, 2002 at 1:06 pm
I've been coding C# in .NET since the Beta 2 release, specifically ASP.NET apps (A windows service or two as well and a web service or two).
In addition to the...
January 27, 2002 at 4:25 pm
A few questions for you...
Are you using a client or server side cursor? Does the table contain a text datatype column?
January 24, 2002 at 7:00 pm
Stored procs are generally not the best places to do string manipulation. SQL is not optimized for it. Why are you using this method? Just curious, maybe...
January 20, 2002 at 9:52 am
Just want to make sure we're talking about full-text indexing rather than index server. If I recall, the problems we were having were with index server, not full-text indexing...
January 6, 2002 at 3:53 pm
I dont know of a lookup table off the top of my head, but I'll look. I dont have the ids, but here are a few mappings:
text data type...
January 4, 2002 at 3:02 pm
Viewing 15 posts - 31 through 45 (of 98 total)