Viewing 15 posts - 586 through 600 (of 1,473 total)
Watch for schema issues as well, I seem to remember having issues with that the last time I worked with MySQL.
October 1, 2009 at 1:05 pm
I'm still on SQL2000 in my production environment, but I can tell you that I used derived tables daily.
October 1, 2009 at 1:02 pm
Views don't use variables. But all you'd need to do is get rid of your where in the view and use it in the referencing statement.
IE.
create view V_myView as
Select...
October 1, 2009 at 12:58 pm
I guess I'm unclear on the question.
I'm assuming you're doing this with a cursor/loop and xp_sendmail?
Seems pretty straightforward if you already know how to process the table and send all...
October 1, 2009 at 7:47 am
Matt Whitfield (10/1/2009)
Have some code. The important bit is the CommandBehaviour.SchemaOnly parameter to the SqlCommand.ExecuteReader call.
So, to use FMTONLY, it'd be... this?
using (TextWriter tw = new StreamWriter("c:\\metadata.txt"))
...
October 1, 2009 at 7:34 am
Maria,
You might also take a look at this thread, which shows another application of the quirky update and compares it to other methods.
http://www.sqlservercentral.com/Forums/Topic789373-8-1.aspx
While a lot of it might...
September 30, 2009 at 7:28 pm
Stopping to think about this for a few, I realized I could just select each UID (Yeah, the table has a UID already, and it's NOT the field used to...
September 30, 2009 at 3:11 pm
[Edit] Nevermind, apparently I never actually stopped to think about this one, it wasn't really a difficult problem.
September 30, 2009 at 1:48 pm
GSquared (9/30/2009)
For SQL 2000 (which is the forum you posted in, so I assume...
September 30, 2009 at 12:52 pm
The comments about the cursor/complicated TVF are true, and if it's possible for you to re-write this in a set based manner, that would be ideal. As to why...
September 30, 2009 at 12:49 pm
TRIGGERS ARE EVIL!
But yeah, I agree with Ian, consolidate triggers wherever possible. Although you can set the trigger order, any time you modify/insert/delete a trigger, that order gets changed...
September 30, 2009 at 9:27 am
Jeff Moden (9/30/2009)
The two things that bother me about the quirky updates are:
1) The clustered index is required in the...
September 30, 2009 at 7:24 am
Matt Whitfield (9/29/2009)
If you're using say SqlClient under .NET then that gives you meta-data irrespective of the presence of rows.
You can move from one result set to the next with...
September 29, 2009 at 3:58 pm
richard.smith 47066 (9/29/2009)
OK I see what you mean. The only thing is that for every procedure it would have to pass its input parameters otherwise you just get...
September 29, 2009 at 3:25 pm
Also, what do you do with multiple result sets from the same SP?
USE tempdb
CREATE TABLE Test( TestIntint)
INSERT INTO Test(TestInt) SELECT 1
GO
CREATE PROCEDURE TestSP
AS
DELETE FROM Test
SELECT 'A' A, 'B' B, 'C'...
September 29, 2009 at 3:20 pm
Viewing 15 posts - 586 through 600 (of 1,473 total)