Viewing 15 posts - 121 through 135 (of 140 total)
I would suppose that if your IIS server is not secure then any strategy for protecting your SQL server will be compromised in one way or anthoer.
I read an article...
January 26, 2004 at 9:56 am
This forumware keeps only giving me one line for msg...whats up with that?
January 24, 2004 at 2:46 am
ASP is server side does not get sent anywhere. Clear or other wise.
January 24, 2004 at 2:45 am
Yes the NULL_yeilds_null off helped me find problem with var. Fixed that all is good. ty
January 17, 2004 at 1:26 am
Jonathan! You are the man!
SET CONCAT_NULL_YIELDS_NULL OFF
Ya know after all the other troubles I had with this procedure I was almost all outta fight. It was a fantastic learning event...
January 15, 2004 at 4:05 pm
Yes I did that. The vars contain what they are supposed to. But the proc is working fine from query analyer only not from ADO.
running this in qa performs the...
January 15, 2004 at 10:58 am
Yes I did that. The vars contain what they are supposed to. But the proc is working fine from query analyer only not from ADO.
running this in qa performs the...
January 15, 2004 at 10:58 am
thats better...
well unfortunetly i think the fetch is neccessary and in this case probable more efficient then any sql statement that if even possible would have too many joins. The...
January 15, 2004 at 9:25 am
hmmm forum only giving me one line for my reply
January 15, 2004 at 8:31 am
woot! Your solution got me moved ahead enough to find another problem that was causing it to not function.
Within the WHILE I was doing an insert like this:
insert into A...
January 14, 2004 at 3:10 pm
Thanks Gary!
I modified your script to more closely resemble mine and it worked. I still am having troubles getting my main proc to work, but it's a big proc and...
January 14, 2004 at 2:30 pm
Sounds more like a data model issue then a syntax one. The tables are not actauly identical.
Is there a requirement for the identity values of each row to be the same...
January 14, 2004 at 11:34 am
Had a brainwave this morning that since this proc calls two other proc's I should ensure that nocount is on in them as well. I had allot of hopes but...
January 14, 2004 at 10:18 am
I did a few tests:
CREATE PROCEDURE [dbo].[tblVarTest] AS
declare @TableVar table ( uid int)
insert into @TableVar (uid) values (1)
insert into @TableVar (uid) values (2)
insert into @TableVar (uid) values (3)
insert into @TableVar...
January 13, 2004 at 10:21 pm
Viewing 15 posts - 121 through 135 (of 140 total)