Database

12-Aug-13 2:07

Hi
i want to design database that have different object but with the same structure .
we have feeling table with this structure (code,name,id) also zone table with (code,name,id).
my question is ,i have to design separate procedure for insert & update & delete or i can use one procedure for both table ??
is it possible to send table name??
is it good way to send table name from DAL OR BLL layer?
please help me

David Mujica12-Aug-13 2:38

David Mujica

12-Aug-13 2:38

Keep it simple.

Create 2 stored procedures.

Just my opinion. Java | [Coffee]

Mahdi_kishislan12-Aug-13 2:51

12-Aug-13 2:51

tnx david.but i have 8 table with this structure .we have to design (delete,update,insert,SearchByName,SearchCode,....)store procedure .now what is the best way??

David Mujica12-Aug-13 7:19

David Mujica

12-Aug-13 7:19

Since the data structure of the table seems to be identical across these 8 tables, why don't you create a "super table" which contains the name of the table, followed by the other columns ?

Data would look like:

Feeling,code,name,id
Zone,Code,name,id
Table6,Code,name,id

This way you would only implement a single set of Select,Insert,Upadate,Delete, just passing the name of the table as part of the "Where" clause.

Kind of hard to describe, but hopefully you get the idea. Cool | :cool:

Good luck. Thumbs Up | :thumbsup:

Mahdi_kishislan12-Aug-13 21:18

12-Aug-13 21:18

tnx

Mahdi_kishislan16-Aug-13 21:17

16-Aug-13 21:17

tnx david

Eddy Vluggen12-Aug-13 8:13

Eddy Vluggen

12-Aug-13 8:13

Mahdi_kishislan wrote:
now what is the best way??

The best way would be a design where each table has a specific structure optimized for the data it is holding. By using a dump-table where all has the same structure, you'll loose a lot of advantages that a usual database offers - simple things like references and type-safety.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Design

David Mujica12-Aug-13 9:27

David Mujica

12-Aug-13 9:27

I totally agree. It seems that his design is kind of lacking.

I just tried answering his question. Sounds more like a homework assignment than a real project.

Corporal Agarn12-Aug-13 3:08

Corporal Agarn

12-Aug-13 3:08

You can use dynamic SQL but I would not suggest that. Create the stored procedures. It is easy to use cut and past for creating all you need, and if one table changes you only change on procedure.

Another way would be to pass the table name into the procedure and have an IF ELSE IF structure within the procedure to update the tables.

Re: Start SQl Server Agent

Anudeep Jaiswal - MCA7-Nov-13 16:52

Anudeep Jaiswal - MCA

7-Nov-13 16:52

I Think You Should Add One More Column To Your Main Table As Type

Now Your Table Structure Is (Code,Name,ID,Type)

Now In Type Column You Can Insert Feeling Or Zone.

And Now One One Insert Update And Delete Procedure Can Do The Same, As You Required.

-------------------------------------------------------------------
Another Approach

You Should Pass Table Name To Your Procedure And Create Dynamic Query.
To Execute That Dynamic Query Use SP_ExecuteSQL

Hope This Will Help You.......

Start SQl Server Agent

Anjani Rajdev10-Aug-13 9:54

Anjani Rajdev

10-Aug-13 9:54

I an not able to start the SQl Server Agent in SQL Server 2008. When i opened SQL Server configuration and found there is no option to start it.When i changed the property from network service to local service it throws error "The service cannot be started either because it is disabled or because it has no enable device associated to it."

Please somebody help me

modified 10-Aug-13 16:02pm.

Mycroft Holmes10-Aug-13 13:12

Mycroft Holmes

10-Aug-13 13:12

This thread [^]turned up when I searched Google

I have the same setting on my local machine but I don't need Agent so have never enabled it!

Never underestimate the power of human stupidity
RAH

Firebird - how to create a view with select command to external data source?

Christoph19729-Aug-13 9:53

Christoph1972

9-Aug-13 9:53

Hello!

I will create a view on a Firebird database server by using the Execute Statement "ON EXTERNAL DATA SOURCE".

I found this document on firebirdfaq.org: http://www.firebirdfaq.org/faq16/

and also this: http://tech.groups.yahoo.com/group/firebird-support/message/114481

Unfortunately my SQL-skills are not good enough to solve this task by my selves.

I tried this:

SQL

SELECT * FROM(
FOR EXECUTE STATEMENT
'select code, name from TMaster where group = 'A' '
ON EXTERNAL DATA SOURCE '[IP Adrress]:\Data\DB\master.fdb' AS USER 'u' PASSWORD
'p' ROLE 'R'
into :code, :name do suspend ;)

Certainly that doesn't run. Unsure | :~

Please can anybody give me some interesting advises?

I look forward to all suggestions!

Kind regards
Christoph

I'm a novice from Germany.

modified 10-Aug-13 14:45pm.

Re: Firebird - how to create a view with select command to external data source?

jschell10-Aug-13 11:30

jschell

10-Aug-13 11:30

You are going from firebird to firebird right?

When you say it doesn't "run" what do you mean exactly?

Re: Firebird - how to create a view with select command to external data source?

Christoph197210-Aug-13 21:47

Christoph1972

10-Aug-13 21:47

Hi!

Thanks a lot for your reply!

You are going from firebird to firebird right?

Yes I do.

When you say it doesn't "run" what do you mean exactly?

It is not possible to compile my SQL example:

SQL

SELECT * FROM(
FOR EXECUTE STATEMENT
'select code, name from TMaster where group = 'A' '
ON EXTERNAL DATA SOURCE '[IP Adrress]:\Data\DB\master.fdb' AS USER 'u' PASSWORD
'p' ROLE 'R'
into :code, :name do suspend ;)

I got a SQL-Error in Line 2. If I try to compile without the select command I got the error in line 1.

I suppose my way to use the "FOR EXECUTE STATEMENT" is not correct. Or do I have problems with my Firebird version? (I don't know my current version at the moment, tomorrow)

I'm a novice from Germany.

Re: Firebird - how to create a view with select command to external data source?

Christoph197211-Aug-13 23:56

Christoph1972

11-Aug-13 23:56

My version is ok (2.5.2)

So my SQL must be incorrect. Is my example basicly possible?

I'm a novice from Germany.

Query related to enter in I T

Sanjay_sehrawat8-Aug-13 20:03

Sanjay_sehrawat

8-Aug-13 20:03

My name is sanjay i had done bsc in computer science and also a course in oracle currently pursuing mca and wants to enter in database jobs. Can anyone suggest me.

Thanks,
Sanjay

Richard MacCutchan8-Aug-13 21:52

Richard MacCutchan

8-Aug-13 21:52

This is a technical forum. You need to research your local area to find out what jobs are available. Try newspapers, recruitment agencies, friends etc.

Use the best guess

Corporal Agarn9-Aug-13 2:15

Corporal Agarn

9-Aug-13 2:15

There are also web sites like Dice and Monster.

Richard MacCutchan9-Aug-13 2:42

Richard MacCutchan

9-Aug-13 2:42

I know, but perhaps the OP does not.

Use the best guess

Corporal Agarn9-Aug-13 3:25

Corporal Agarn

9-Aug-13 3:25

Just trying to expand on what you said. Debated on under yours or OP.