Viewing 15 posts - 15,031 through 15,045 (of 18,923 total)
He needs to query the system tables... not to get their columns info
.
July 13, 2005 at 9:33 pm
Really depends on the indexes... I like the exists better but the left join does the job really well
.
July 13, 2005 at 9:29 pm
Select T1.* from dbo.Table1 T1 where not exists (Select * from dbo.Table2 T2 where T2.colid = T1.Colid /*all the other conditions you need and T2. = T1...*/)
July 13, 2005 at 4:13 pm
Check out SQLDMO (VB). It may be your next best friend.
July 13, 2005 at 4:07 pm
It'll be displayed in the newsletter tommorrow, you'll most likely get an answer.
July 13, 2005 at 3:48 pm
"I do have one other question though.....if you go to this link:
http://test.rbrsystems.us/entergas.asp"
you're not validating any parameters.. this can be dangerous.
Read this :
July 13, 2005 at 3:41 pm
I'm not the expert on permission about mails.. However I know it's a security breach to give normal users access to that proc. It's best to have a job...
July 13, 2005 at 3:40 pm
"It's because of rule 1 about databases: everybody thinks he's an expert."
You can blame MS Access for this one... It's nice to have wizards but it doesn't mean you...
July 13, 2005 at 3:37 pm
I'll take that bet... and lose
.
Seriously we usually don't answer when we can't and since I have 0 experience with replication and Yukon...
July 13, 2005 at 3:30 pm
CREATE PROCEDURE dbo.emailgas --might wanna add the paramers in here ![]()
AS
EXEC master..xp_sendmail
@recipients = 'brad@domain.com',
@subject = 'SQL Server - Updated Gas Transaction',
@message =...
July 13, 2005 at 3:23 pm
It's a shame... I have neither
.
Ya, ya... I'm trying to slow down
.
July 13, 2005 at 3:19 pm
Can you post the code of the proc?
July 13, 2005 at 3:16 pm
The worst that will happen is that you'll get a call that the guy can't connect no more... But I don't think you will get it
July 13, 2005 at 3:14 pm
Viewing 15 posts - 15,031 through 15,045 (of 18,923 total)