Viewing 15 posts - 16 through 30 (of 45 total)
"We are trying to release a product and one of the parameters are that we don't want DBA's or anyone of our client to see database architecture (tables/columns and if...
July 18, 2006 at 10:11 am
Mark,
I don't know of one that is free.
Do you have VSS and Vis Studio?
I could explain my process for tracking.
If you have issues with versioning, maybe...
July 13, 2006 at 10:04 am
Robert,
We currently use SQL 2000, Visual Source Safe 6.0 for versioning, along with Visual Studio 2003 to do object versioning on the servers.
See here for info on VSS keywords:
July 5, 2006 at 10:07 am
In response to the original question...
The front end developers should write the front end, the BAL objects and the DAL layer with the proc calls.
Nothing past that.
C#/Vb.net/etc are...
May 31, 2006 at 6:52 pm
Okay, first, I haven't worked with SQL 05 yet, I'm still up to my neck in bad 2000 databases. So I'm not 100% that what I'm saying is what 05...
May 17, 2006 at 9:08 am
lol, I'm totally following you.
It's late here, the screwdrivers are sinking in and the wife wants me to come to bed...I'll get you a reply in 12 hours or so......
May 16, 2006 at 10:16 pm
If you make the decision in the proc, it will have to redo the execution plan everytime AFAIK.
That's why I recommended doing it in the application's DAL layer instead....
May 16, 2006 at 3:33 pm
No problem, let me know if you need help.
You're right on about the CONVERT type.
What I would do to find the correct varchar length would be to look...
May 16, 2006 at 3:01 pm
No problem, glad I could help.
BTW, I noticed that you are using 1 as your seed value for a primary key with a datatype of INT.
Did you know...
May 16, 2006 at 2:15 pm
My response assumes you are not entering values for one answer into multiple tables.
May 16, 2006 at 2:00 pm
select QuestionText
, AnswerYear
, AnswerInt
Convert(VARCHAR(100), AnswerText) as 'AnswerValue'
from tblQuestion q
inner join tblAnswer a
on q.questionid = a.questionid
inner join tblAnswerText at
on a.answerid = at.answerid
UNION
select QuestionText
, AnswerYear
, AnswerInt
Convert(VARCHAR(100), AnswerDecimal) as 'AnswerValue'
from tblQuestion q
inner join...
May 16, 2006 at 2:00 pm
Okay, that puts it into perspective.
In that case you really have 3 types of questions...each question will always have an answer of the same type right?
This is abit...
May 16, 2006 at 1:16 pm
Can you explain why there are 3 possible types for this attribute?
I would hate for you to have to deal with 3 times the amount of tables because of...
May 16, 2006 at 10:04 am
Also,
Sorry if I appeared to be terse, I totally understand that sometimes things like this aren't under our control.
May 15, 2006 at 10:44 pm
"a situation where the attribute of an entity can have a float/integer/string"
Then you have a non-fully defined attribute there.
Fix the incomplete definition of the attribute and you've fixed your...
May 15, 2006 at 1:37 pm
Viewing 15 posts - 16 through 30 (of 45 total)