Viewing 15 posts - 2,326 through 2,340 (of 7,429 total)
I see one way this can be done is by using two fields and making a composite key if this is to be a driving data key.
Create a table with...
February 10, 2004 at 4:19 pm
No writing Dynamic SQL opens many variables for exploitation. You have to give extra rights to the underlying data tables which is a security risk. However all said you sometimes...
February 10, 2004 at 4:11 pm
Not sure what you mean. Do you mean you want to have like a generated number but start at say 20030000 to provied numbers 20030000 - 20039999 or some other...
February 10, 2004 at 3:49 pm
I have heard various numbers tossed around in the passed. It boils down to performance, for best performance denormalize so you can do fewer joins. However with newer and faster...
February 10, 2004 at 3:46 pm
A couple of things
1 you use reference to table 2 in and outside you trigger statement and I am kind of confused.
If you are trying to insert the data based...
February 10, 2004 at 1:17 pm
Thinking about it, if you do the following type of code
DECLARE @val INT
SET @val = (SELECT valid FROM tblx)
If multiple rows return you will get an error.
If you however do
DECLARE...
February 10, 2004 at 9:52 am
I agree with SQLBill, if you get bad data in the outputs from the select and try to insert you might be getting an error causing a rollback on the...
February 10, 2004 at 8:02 am
I know of no tool at this point that can hack the DTS encryption or these. However right click the package and try one of the previous versions (DTS has...
February 10, 2004 at 7:48 am
You could use a linked server (even to the server on) and using openquery to call the sp do the select into:
Ex:
Select * into #x from openquery (linksrv,'sp_name')
but you are...
February 10, 2004 at 6:54 am
The only problem is they do not always get attached to EM when installed. Not a guranteed place to see.
February 9, 2004 at 8:23 am
An installation of the SQL executables which can be run independently in memory. You have at minimum 1 instance but can install more that can be run independently in memory....
February 9, 2004 at 5:23 am
Personnally, I love this one. I have seen and been a part of manipulating the data to provide the best potential statistics possible. Most companies usually drop the lowest and...
February 5, 2004 at 4:55 am
COuld you please post the code for the SP so we have a bit of an idea what you are doing.
January 28, 2004 at 4:43 am
First I would consider dropping the NC index. The reason is this.
The NC index does not contain pointers to pages it only contains the associated value in the Clustered index...
January 28, 2004 at 4:40 am
Viewing 15 posts - 2,326 through 2,340 (of 7,429 total)