SJanki (12/27/2012)

---

I have a table that keeps track of a store open, closed, reopen, closed (again) , reopen(again) etc dates.

The table has StoreId , AuditTypeId (Open, Close, Reopen) and...

herring

lonhanner (12/27/2012)

---

Yes the data came from ACCESS. I imported to sql. Is their anyway I can convert the "UP_DATE" Column to the sql date type. If so could you give...

lonhanner (12/27/2012)

---

I have a column called "UP_DATE". When the code below trys to read "UP_DATE" I get the following

riders.UP_DATE = CDate(reader("UP_DATE").ToString)

error. Conversion from string "" to type date is...

tz.bahrami (12/27/2012)

---

Thanks alot.

How about polymorphism in sql? Could we use stored procedures for polymorphism?

And for nested relationships can we define an attribute as OId and use it in a select...

What you described would create that mirror image. If you just not want to have the identity column in the new table, you can simply exclude it from the select...

What you are describing is known as an adjacency list. They are frequently used in sql for a parent-child relationship. If you make the ParentID not null you can't have...

tz.bahrami (12/27/2012)

---

Thanks for your instruction, i am familiar with junction table, but i look a way to implement something like inheritance. In addition i agree with you for encapsulating by...

What are you trying to do here? I don't understand what the default of SCOPE_IDENTITY or @@IDENTITY are trying to do.

I don't understand what you are trying to do...

Of course since this is Oracle and not t-sql you will probably have much better luck on an Oracle forum getting help with performance. 🙂

No problem. Glad that worked for you.

Then you probably just removed it from the diagram. When you restarted SSMS did it fix the issue?

LastJedi (12/26/2012)

---

I may have clicked on delete tables from databases vs remove table from diagram.

I did rebooting SQL Server 2005 and it appears. I did research but I was afraid...

Did you make changes to the table from the diagram tool? This can cause the table to need to be dropped and recreated behind the scenes. Sometimes the diagram tool...

tz.bahrami (12/26/2012)

---

I know features of object orientation could not implemented, but i want to find a way to implement them. For example for implementing inheritance we can use foreign key.

Please...