0
I have tables with names. Table "Alphabet" contains only names starting with letter A and so on until table "Letter Z".
Task:
Search any name in all tables and locate it.
0No answers
Browser other questions tagged sql-server-2012
You are not signed in. Login or sign up in order to post.
And what have you ever done? There’s no way I’m doing your homework!
– Junior Moreira
I made several attempts using the query builder from management studio, but no attempt worked, so I asked for help.
– dezoldan
But where are your attempts, friend? There is no way to start from 'nothing' and help you not, show what you have tried, you said 'several attempts' show what else worked! Click Edit and add more information!
– Junior Moreira
Your bank is normalized?
– Marcelo Bonus
I believe the task is simple. once working with two tables will give you all. Find a term in two tables. The attempts I made were in the query builder, and with each new attempt I delete the previous one, so I’m starting from scratch now.
– dezoldan
the database is normalized. There are no repeated names or missing names. There are no numbers and etc. The Alphabet table contains only names that start with letter A. and so on.
– dezoldan
Without adding your attempts or what you’ve already done, it’s hard to help.
– user28595
If it were a table I just think it would look good, but I need it in all tables. SELECT * FROM Letraa WHERE Last name LIKE @Last name + N'%'
– dezoldan