Frank Kalis

Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 5,356 total)

RE: creating a "is a" relationship

- Open your table in design view
- Right-click on properties
- Choose Relations (?!? Sorry, in german its' called Beziehungen) tab
- Add new
- Fill in the required informations as Parent and...

December 29, 2003 at 6:13 am

#487928
RE: using 'IN' keyword in cursor declaration

I guess this is expected behaviour. You can't use @TEMP to pass more than a single value. It will not be correctly interpreted as a list of values.
This might be...

December 29, 2003 at 5:45 am

#487924
RE: Passing a Table Column name to a Multistatement Ta

Is this http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1092 going your direction?
Frank
http://www.insidesql.de
http://www.familienzirkus.de

December 29, 2003 at 5:32 am

#487922
RE: is there something like subprocedure in TSQL ?

There is a GOTO command in T-SQL. It is explained in BOL. Also you'll find there
a topic 'nesting stored procedures'
Frank
http://www.insidesql.de
http://www.familienzirkus.de

December 29, 2003 at 5:28 am

#487920
RE: creating a "is a" relationship
Sorry, if I understand you correct, why do you have three tables at all?
Isn't a programmer at the same time also an employee?
However, is this what you're after
```
 
```
December 29, 2003 at 5:24 am

#487919

RE: Stars

I think, I have seen in some forums a functionality like 'View accepted answer' or alike. This might go into the direction of the original question.

December 29, 2003 at 5:11 am

#487917

RE: Generate Sequence Number Safely

If this is for some kind of index, I would also use the identity property on a numeric column. This is a built-in function of SQL Server that I'm feeling...

December 29, 2003 at 2:43 am

#487899