No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
I am creating a sample database and the work is so painful, I really wonder and need assistance to reduce my pain. I would like to create a "lookup Field" which returns the value (string) automatically from another table. Example, I have 2 tables - Department and Employee Department[DepartmentID, DepartmentName] …
I have 2 databases on my computer, managed in the same SQL Management Studio - named [B]DATABASE1[/B] and [B]DATABASE2.[/B] The two databases are different except they have 1 table is the same, this table is called [B]Employee[/B] Because this the content of this table should be the same, how could …
I would like to get information of an employee by his EmployeeKey - in my case : LastName, FirstName, Gender, and Title using ASP. Net - C# - then display this information to label (label.Text = return value) The SQL is simple - [code] use AdventureWorksDW SELECT [FirstName], [LastName],[Gender], [Title] …
The End.