|
safealloys wrote: After creating table what next? -
Drop it. Go Home. Eat and Sleep.
When you can not form a complete sentence correctly and can only crop-dust the forum multiple times with the same crap as here (http://www.codeproject.com/script/Forums/View.aspx?fid=1725&msg=2593420[^]), that is what you can do.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
All the world's a stage,
And all the men and women merely players.
They have their exits and their entrances;
And one man in his time plays many parts... --William Shakespeare
|
|
|
|
|
Populate it? - almost certainly
Select from it? - almost certainly
Delete from it? - possibly
Drop it? - maybe
Ask a sensible question - unlikely
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I,m a Beginner, Pls encourage. what next action after creating tables in SQL and creating interface in VB.net
|
|
|
|
|
safealloys wrote: what next action after creating tables in SQL and creating interface in VB.net
Writing code, I guess. Do you have a book you're working through ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Pls I want to add staff to my database, how do i go about it?
|
|
|
|
|
Pls I want to add staff to my database, how do i go about it? I wastold about DataAccesslayer, BusinessLogicLayer and PresentationLayer
|
|
|
|
|
I am creating a survey in asp.net to rate 46 departments from 1-5 on there quality, interpersonal skills, and timelines. Then store the data into a sql database. I am trying to figure out how I want to create the tables and I was wondering if anyone can provide any ideas. Should I create a table for each department with columns: quality, interpersonal, and timelines? If I do it this way I will have to create 46 tables which is alot. Or, should I just create one table and create columns for department, quality, interpersonal, and timelines.
Any feedback would help.
Thanks!
jds1207
|
|
|
|
|
I wouldn't go with creating 46 tables - as they will mostly be the same. Without more information to go on, I would look at creating this using the following structure:
Department:
ID (int autonumber PK)
Name (NVarChar(100))
Rating:
ID (int autonumber PK)
Score (int)
RatingTypeID (int fk)
DepartmentID (int fk)
RatingType:
ID (int autonumber PK)
Description (NVarChar(100)) Then, your RatingType table would hold the types, e.g. Quality. The Department table would hold details on the department, and the Rating table would be point to the Department and to the RatingType (it would also hold the score). In this way, you get a nice flexible structure where you can add rating types in the future.
I hope this helps.
|
|
|
|
|
Wow - you cross posted half the site. How annoying....
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
for forum database i hav fields Categories,Post_No,Post,Post_By,Post_Date. I need to know "other then this one more field is required that links post_no and Post" . wat is that field? i need an relavent fieldname
spriya
|
|
|
|
|
Make one up - its not a difficult question is it? Please don't post homework questions, its pointless.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
What about tables? Surely a forum requires multiple tables.
|
|
|
|
|
Colin Angus Mackay wrote: What about tables? Surely a forum requires multiple tables.
Nah - it can be done in one access table with 450 fields. Just call them Field1, Field2, Field3, ..., FieldN.
|
|
|
|
|
Hi All
I have 4 tables in a dataset:
ACTIVITY
ACTIVITY_PARTICIPANT related to ACTIVITY (nested)
PERSON related to ACTIVITY_PARTICIPANT (nested)
ROLE related to ACTIVITY_PARTICIPANT (nested)
if one person i related several times to one activity, with different roles, I get the "a child row has multiple parents" error.
I understand why I get the error
My question is:
How could I produce this xml
<DATASET>
<ACTIVITY>
<ACTIVITY_PARTICIPANT>
<ROLE ID="1" />
<PERSON NAME="PERSON A" />
</ACTIVITY_PARTICIPANT>
<ACTIVITY_PARTICIPANT>
<ROLE ID="2">
<PERSON NAME="PERSON A" />
</ROLE></ACTIVITY_PARTICIPANT>
</ACTIVITY>
</DATASET>
from my dataset. Is there a method, or do I have to write it myself ?
I guess I have to start with
ACTIVITY
ACTIVITY_PARTICIPANT related to ACTIVITY (nested)
PERSON related to ACTIVITY_PARTICIPANT (NOT nested)
ROLE related to ACTIVITY_PARTICIPANT (NOT nested)
Thans in advance
Kjetil
modified on Wednesday, June 11, 2008 8:55 AM
|
|
|
|
|
I created a table for keeping Configuration parameters. When i wanna get the value via stored proc, i got null. Could u check me my stored procedure pls.
CREATE PROCEDURE [dbo].[sp_GetConfigurationParameter]
@Key char(4),
@Type char(4),
@Value nchar OUTPUT
AS
SET NOCOUNT ON;
SELECT @Value=[Value] FROM VpConfParameters WHERE [Type]=@Type AND [Key]=@Key
To Try
declare @Value nchar
EXEC [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value
select @Value
Result
NULL :'(
|
|
|
|
|
assuming that there is data that matches your query in the table, you could forego the output parameter and just select [Value] then your exec statement would be
declare @Value nchar
EXEC @value = [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value
select @Value
I know that works in sql server 2k, and i'm fairly certain it wont work in oracle.
Alcohol the cause of and solution to all of life's problems.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
as far as i know you can still select values out of a usp in sql server 2k5.
Alcohol the cause of and solution to all of life's problems.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
You have missed OUTPUT in your test
greekius wrote: declare @Value nchar
EXEC [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value
select @Value
Should be
declare @Value nchar
EXEC [sp_GetConfigurationParameter] 'DBNL','DEVE',@Value <big>OUTPUT</big>
select @Value
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hello,
I have the following query where I want to append to the existing table SalePrice and the the third coilumn SalePrice = 199 which is wrong .
Can you correct it ?
Can you sugest me sites to improve my query writing.
SELECT timeperiod.timeperiod,product.product,
convert(int,199) as SalePrice
INTO SalePrice FROM timeperiod,product where Product='Shirt199Light'
Can you
|
|
|
|
|
Ok, so you didn't really like my answer last time. What you want then is a variation on it.
SELECT timeperiod.timeperiod,product.product,
cast(null as int) as SalePrice
INTO SalePrice FROM timeperiod,product where Product='Shirt199Light'
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hello,
Your last answer was very helpful and I think asking the variation was really silly on my part but from where did you get these 'cast' and 'convert' 'as' keywords.
I have visited SQL sites but they don't offer anyting more than the basic SELEC,INSERT,WHERE keywords.
I will search for more sites and hope not to bother you much.
Thanks for your answer.
Pritha
|
|
|
|
|
Hello,
The above query does not add record to the existing table.It says
'There is already an object named 'SalePrice' in the database.'
I want to add records to an existing table where all the 3 columns exist.
Thanks.
Pritha
|
|
|
|
|
Hello,
I have got how to insert record
But are there any sites that offer help with such mix and match in SQL.
Prithaa
|
|
|
|
|
Hi all,
I want to connect to DB2 database in my application. IS there any command line utility for the same or is there any way I may program it. My application is based on C#.net.
Thanks,
Sankalp
|
|
|
|