Viewing 15 posts - 12,931 through 12,945 (of 13,446 total)
updated!
Thanks again for all the feedback.
Thanks to David Russell for pointing me towards the fix for some subqueries returing more than one row;that bug is fixed.
other things i did:
added functions...
October 25, 2006 at 7:42 pm
thanks everyone for the feedback; some folks were kind enough to give me feedback on specific issues they encountered, so I'll tweak the logic to make it even better; my...
October 25, 2006 at 7:06 pm
aww nevermind; you stated that it occurs every time; that shoots down the easy fix;
October 25, 2006 at 2:21 pm
Greg is every connection, or just once in a while? if it is just once in a while, could it be something as simple as the db AUTOCLOSE being set...
October 25, 2006 at 2:08 pm
the bugs are from the forum converting things like semicolon + close parenthesis into a winking smily face.
the code worked perfect when i posted it; it just got a but...
October 25, 2006 at 1:56 pm
October 24, 2006 at 7:20 am
I've seen this before; it is caused by editing the name directly in Enterprise manager, and not via drop create/alter statements;
to prove it:
go to enterprise manager and find any view;
click...
October 24, 2006 at 6:34 am
usually, you get a collection of rows from the datatable, and loop thru the rows:
Dim
dt As DataTable
Dim
a()
October 24, 2006 at 6:19 am
there's pretty much only two ways; setting up a trace, which you stated you wanted to avoid;
you'd need to set up a trace to capture TSQL statement completed, and then...
October 20, 2006 at 12:37 pm
Greg's example is actually a bit better;
your example script would work, but it would always say 50000 rows affected, as there is no where clause. with no where clause,...
October 20, 2006 at 9:53 am
constraints are enforced acrross all data in the table, and there's no conditional constraints.... so you can't have a constraint Client_id and Code_id where isactive_flag = 'N' and a different...
October 19, 2006 at 7:21 am
Rgr is absolutely right....if you had a stored proc that was 30K in length, it would just occupy 7 rows in the syscomments table(30K /4K = 7 rows)
your boss on high...
October 19, 2006 at 6:02 am
and to expand on what Ken said, if the table doesn't exist yet, you can use the INTO command to create it on the fly:
SELECT Col1, Col2, ...
INTO MyNewTable
FROM YourView
October 18, 2006 at 11:12 am
From what you stated, I think I'd add a linked server for the Pervasive database, then write a procedure to grab the data from the ERP/Pervasive database, and insert that...
October 18, 2006 at 11:05 am
something like:
CREATE TRIGGER tr1 ON Transactions
AFTER INSERT,UPDATE AS
INSERT INTO TransactionLog(TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments )
--the table [INSERTED] is the data being affected by insert/update:
SELECT TransactionID, TransactionStatusCode, LogDate, ErrorCode, Comments FROM...
October 18, 2006 at 9:23 am
Viewing 15 posts - 12,931 through 12,945 (of 13,446 total)