| Author |
Topic |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2007-12-11 : 18:20:12
|
| can someone please tell me if you can implement a drop down list within a table attribute.If anyone could show me an example please do.Kind RegardsRob |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-11 : 19:15:19
|
Where would you like to implement the drop down list?It is not clear what you want.Please elaborate.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-12-12 : 03:53:37
|
| well if i have two related tables. iecreate table Students( StudentID int primary Key Not null,SEX MALE OR FEMALE I want to have a drop down selection withinthis table attribute. How would i do this?RegardsRob |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-12 : 03:55:29
|
You can't in Microsoft SQL Server. However, this is possible in Microsoft Access.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-12-12 : 05:10:51
|
| ok thank you,I would of thought that would of been a basic feature to use.but never mindTHnak you anyway.I will have some more basic questions later onRegardsRob |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-12 : 05:16:25
|
quote:
Originally posted by masterdineen
ok thank you,I would of thought that would of been a basic feature to use.but never mindTHnak you anyway.I will have some more basic questions later onRegardsRob
A drop down list is not a basic feature in a back end product. The only reason Access has this is because it is not a true database product, it has it's own forms etc..SQL Server is a true database product in that no front end programming features are included, it is more concerned with storing and retrieving data as fast as possible. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-12-12 : 06:23:46
|
| Thank you RickI am going throught A self paced training Kit to gain mt MCTS in SQLServer 2005.I know the basics of SQL and am gradually learning the features. I'm am looking for a Junior Developer Role, have you any tips at all.RegardsRob |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-12 : 06:47:34
|
| Whereabouts in the UK are you based? If you are looking for a junior role, be prepared to travel as they do not come up too often. The best sites to look for roles are jobserve and Totaljobs.Other than this, read the books and forums to learn. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-12-12 : 07:08:50
|
| I live in Loughton Essex so i work in london at the moment |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-12 : 07:38:15
|
| OK, you are probably in the best place to get junior roles. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2007-12-12 : 07:47:28
|
| sorry to be a pest,do you have any good tips, like what attributes are best for an SQL Developer, What features to know, coding, Reproting Services etc... ??? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-12 : 08:19:23
|
| For a SQL Developer, T-SQL, SSIS, RS as well as a good grounding in Database Design. |
|
|
|
|
DropDownList Attribute ????