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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21108548.html
Zones:
MS SQL ServerDate Answered: 08/27/2004 Rating: 8.6 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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21219219.html
Zones:
MS SQL ServerDate Answered: 11/29/2004 Rating: 8.8 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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24329169.html
Zones:
MS SQL ServerDate Answered: 04/16/2009 Rating: 7.0 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??.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10303450.html
Zones:
MS SQL ServerDate Answered: 05/03/2000 Rating: 7.0 Views: 0
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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21514919.html
Zones:
MS SQL ServerDate Answered: 08/09/2005 Rating: 7.2 Views: 0
Can table names be distinguished from field names on this table?
Thanx in advance,
G
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21726435.html
Zones:
MS SQL ServerDate Answered: 02/07/2006 Rating: 9.4 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
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22126633.html
Zones:
MS SQL ServerDate Answered: 01/17/2007 Rating: 9.4 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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20183437.html
Zones:
MS SQL ServerDate Answered: 09/18/2001 Rating: 9.2 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,...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20504138.html
Zones:
MS AccessDate Answered: 08/24/2003 Rating: 9.4 Views: 4
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...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21179215.html
Zones:
MS SQL ServerDate Answered: 10/22/2004 Rating: 9.4 Views: 0
