Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Inserting data...
You cannot have two values for a given row column pair... you could have an associate table that will have the users id and then values for the other column.. ie: Users [uid] [username] 105 Jorge 55 Tom then another table: UserNews [uid] [news] 105 No news News. 105... -
counting duplicate entries
Use a SQL Statement like this: select ip_addr, count(*) from myipvisitors group by ip_addr having count(*) > 1; HTH -
How do I get a list of databases and tables
Ok, I got this one figured out. With a bit of scripting and dynamic SQL combined with piping I was able to get the information that I needed. -
How do I get a list of databases and tables
I want to create a table with a sql statement that will have the dbname and the tables in that db (like the sysobjects in SQL Server or the user_tables in Oracle). Is there a way to do this? I know about show tables and show databases but how do I get this information into a table with a sql...
