Advertisement

Check out our new and improved Advanced Search! We have added additional search options and the ability to save your searches.
 
Enter Keywords:
 
1 - 10 of 26(0.008 seconds)
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6
Does SQL Server CE have tables like Syscolumn in SQL server 2000?  Are there system tables that store system information other than just MSysObjects? Also, for some reason, I can access all tabl...
Zones: MS SQL ServerDate Answered: 08/27/2004 Views: 0
Hi, I need to find all the table names in the database which have a column called 'StatusFrom'. How do I select from the syscolumns and sysobjects? And once I've retrieved this list, I need t...
Zones: MS SQL ServerDate Answered: 11/29/2004 Views: 0
-- (SQL 2000) This query is to be run in a SP and yields the expected result, listing all matching tables in the current catalog (myDB): use myDB  -- can't do this line in a SP select objec...
Zones: MS SQL ServerDate Answered: 04/16/2009 Views: 0
How can you tell if a table exists on a MSSQL database using T-SQL?. I can use an 'IF EXISTS (select * from syscolumns....' etc if one of the column names is unique, but what if this isn't the case??.
Zones: MS SQL ServerDate Answered: 05/03/2000 Views: 4
I have a table called Campaigns.  Inside this table, I have a Camp_ID and a field that specifies whether  campaign is ACTIVE or not.... I also have another table tbl_CAMPAIGN_DETAILS that has the C...
Zones: MS SQL ServerDate Answered: 08/09/2005 Views: 0
Can  table names be distinguished from field names on this table? Thanx in advance, G
Zones: MS SQL ServerDate Answered: 02/07/2006 Views: 0
I would like to ge the list of tables which has the column "InvId"... How can I do this? should i use syscolumns table?  I am using sql server 2000
Zones: MS SQL ServerDate Answered: 01/17/2007 Views: 0
Hi, I want to write a small script to compare and produce the missing columns of a table residing in another databases. I am attempting to do that with the following script, but is unsucessfu...
Zones: MS SQL ServerDate Answered: 09/18/2001 Views: 0
Hi all the query below runs in Ms_sql server i want it's equivlant query in ms-access. is this possible? if not then what's the alternative SELECT a.name AS tablename, b.name AS columnname,...
Zones: MS AccessDate Answered: 08/24/2003 Views: 8
How do I join syscolumns with sysobjects to get a list of tables that has a particular field in it?   select sysobjects.name, syscolumn.name from sysojects inner join on syscolumns on syscolumns...
Zones: MS SQL ServerDate Answered: 10/22/2004 Views: 0