Hello,
If you need to have a liste of tables starting with 'WI', under Oracle for example, with a simple select of a system view (with a filter : table_name like 'WI%') you have the result.
Under SQL Server, how to do this simply (sp_tables ?) ?
Thanks in advance
Hello,
Maybe anyone have done that before?
I have table where i store SOURCE_TABLE_NAME and DESTINATION_TABLE_NAME, there is about 120+ tables.
i need make SSIS package which selects SOURCE_TABLE_NAME from source ole db, and loads it to DESTINATION_TABLE_NAME in destination ole db.
I made such SSIS package. set ole db source data access mode to table or view name variable.
set ole db destination data access mode to table or view name variable. set to variables defoult values (names of existing tables)
but when i loop table names is changed, it reports error, that can map columns, becouse in new tables is different columns.
how to solve that problem?
I have a database that has 370 tables that match %_REF_% naming. All of these tables have a column call ds_name.
I need to get a list of all values of ds_name for each table.
i need to give list all table in my database plaese give me qurity?
thanks a lot
Hi Group!I would like to get a list of all the table names from a database, cananybody please tell me how to do that? Many thanks!
View 4 Replies View RelatedHi,
i want to get the list of column i have in a table using sql statment
can someone send me example?
thanks
Anybody know any method/script I can use to see a list of table name
and table size (in bytes, not rows) within a database?
I know I can see the size of any particular table in "Table info" tab or using "sp_spaceused" procedure. But I can't generate a report with a list of table name and table size using these methods.
Any idea? Thanks.
John
SELECT Item.Unit_price
FROM Item
ORDER BY Item.Unit_price DESC
How can I display the Top10 only? thanks.
Hi guys, i'm sort of stuck.
I have a list of names, all i have to do is check to see if any of them are in a table, if they are they get deleted. The unique field of the table is title and it is what i have. I don't really know how i am meant to do this. I thought of creating a new table, placing my values into it and comparing to the already existing table, but surely their is a simple way?
Is there a system table that holds the table definitions, names, properties, etc. for tables that I have designed? I would like to write a transact SQL query to insert a field in every table that I have defined.
View 1 Replies View RelatedPlease how can I get list of tables in a database? Thanks.
View 3 Replies View RelatedHi Everybody,
i am it sutck when i am writing this sql in sqlserver2005
my requirement is to list all the table name and along with their filed name if some one modified (table definition ) for a specifc date range ?
is there any way to get these information in sql server 2005 ?
regards
sujithf
Hi,How to get list of all relations of certein database's table?
View 7 Replies View RelatedHi! There must be a very simple answer to this question, but it’s my first venture into using SQL Server data.
I’ve set up an ASP.NET site to provide for on-line sign-up of events. The site has a masterpage and utilizes a wizard to create an e-mail to request sign-up for an event.
I’d like to make my radiobuttonlist dynamic so that events past the signup deadline will not be displayed. So, I’ve created a database table that includes two fields: event_description and event_date – such that the radiobuttonlist will only show those events that are at least three days beyond today’s date.
I’ve configured the data source and the radiobuttonlist so that I can display all the entries in the event table, but I can’t figure out how to restrict them to today + 3 events only.
I’m guessing my problem is in the “Add Where Clause� of the “Configure Data Source� wizard. I’m sure the “Column� should be set to event_date and the “Operator� should be set to “>�, but what should I set the “Source� & “Parameter Properties� to? I’ve set a variable in my program as “Dim deadline As Date = Today.AddDays(3)�, but the wizard doesn’t seem to see it.
Can anyone steer me in the right direction?
Thanks, Jerry
Hi masters
well got a SQL server 7 and a table
and got drop down list in my asp page
what I want to do is that the content and value of the drop down list will be grabbed from the database, when page loads.
can you please guide me
many thanks
S
Hi,I have table (tbl_a) that get it values form three Dropdown List and the PK of this table is FK in different table(tbl_b).Since tbl_a get its values from three Dropdown List the number of rows in this table is limited to the number of combinations the three Dropdown List is offer (in any case the number of raws in that table will be final).Assuming tbl_a and tbl_b are both empty.
The problem is that if i want to insert row to tbl_b i have to check first if there is a row that holds the values (or combination of values) i am getting from the Dropdown List in tbl_a .Then, if such row is exist i have to get the PK of that raw and insert it to tbl_b (as FK),if such row does not exist, i have to insert it and then get the PK of this row and insert it to tbl_b (as FK).
In the end, tbl_a will have all the combination the three Dropdown List can offer so checking if raw exist in this table will not be necessary.
In my opinion this is not effective way to do that.Can someone offer me better way to do it?
Thanks
Hi,
Is there a query I can run to retrieve a list of all tables and their sizes in a database? I want something that is like the feature in Enterprise Manager when you click on a database and then the 'Tables & Index' link. It lists the tables and their respective size. I want to push this into a spread sheet.
The reason why I am doing this is the compare data between 2 different databases. Since I cannot find a tool that will compare the data, the closest I can get (without bcp-ing out all data and comparing) is to look at the sizes of each table.
Thanks!
Joyce
We are listing available SQL databases for selection in a VB list box, but need to be able to then elicit the tables in the database for another list. I am sure it is something simple, could someone help me out with this? Thanks!!
Laura
Hi,
I have table (tbl_a) that get it values form three Dropdown List and the PK of this table is FK in different table(tbl_b).
Since tbl_a get its values from three Dropdown List the number of rows in this table
is limited to the number of combinations the three Dropdown List is offer (in any case the number of raws in that table will be final).
Assuming tbl_a and tbl_b are both empty.
The problem is that if i want to insert row to tbl_b i have to check first if there is a row that holds the
values (or combination of values) i am getting from the Dropdown List in tbl_a .
Then, if such row is exist i have to get the PK of that raw and insert it to tbl_b (as FK),
if such row does not exist, i have to insert it and then get the PK of this row and insert it to tbl_b (as FK).
In the end, tbl_a will have all the combination the three Dropdown List can offer so checking if raw exist in this table will not be necessary.
In my opinion this is not effective way to do that.
Can someone offer me better way to do it?
Thanks
Hi.
My boss would like a list of all the tables in a specific database and their record counts. There are over 80 tables in this database, so doing one by one is not something I have time for.
Does anyone know of a system table that stores this information or an easy way of doing this?
Please help.
Thanks,
ODaniels
I use this macro to list in A column of sheet the name of sql server on
my lan.
Is possible to "scan server by server" and insert into column B the
name of database and related table?
Tks.
Sub test_sql()
Dim TEST As String
Dim RIGA As String
Set sqlApp = CreateObject("SQLDMO.Application")
Set serverList = sqlApp.ListAvailableSQLServers
numServers = serverList.Count
RIGA = 2
For I = 1 To numServers
TEST = serverList(I)
Range("A" + RIGA) = TEST
RIGA = RIGA + 1
Next
Set sqlApp = Nothing
End Sub
How can I list indexes with a (SQL) query ?
Thanks
I accidently deleted the file that I was working on in notepad that had the tables and views that I created. Is there a way to retrieve a list and the code that I put in for the tables and views?
View 1 Replies View RelatedHi, I know sys.tables and sys.columns gives me a list of tables andcolumns in a SQL 2005 database.How can I list Columns in a specific Table please?Thanks in advance,Ronny
View 3 Replies View RelatedCan anybody help on this question?When I select 3 values from the drop down list box, how can I insert into atable?Please help
View 3 Replies View RelatedIs anyone know about waht type of table or database name
that not supported or will have error during execution of SQL statement
in SQL or MS Access database. For my, I know only two ,
i.) cannot put table name that same as the the database name
ii.) cannot put database name like "RETURN", "POSITION",etc.
Is there any reference site that show out a list of table about the
table or database name ??? Thank You ... :)
Hi All,
As the thread title state, I was wondering if it is possible to alternate the list table row colors between 2 colors. Just wanted to make it more presentable when viewing.
Regards,
Fadzli
I know it is basics, just slipped out of my mind, How do we list or print the columns names of table in sql server 2000.
thanks,
I'm having trouble generating an XML file from a sql table. Basically its an HR Dept. table that has departmentID and ParentDepartmentID. I need to create a hierarchal xml file that has a parent node, and all its departments, and if any of the sub departments have any below them, stick those departments in accordingly. I can do this two ways...either through tSQL or through .NET recursive methods. I've tried the recursion but can't wrap my head around it enough to get it working.
Here is the table schema:
Code BlockCREATE TABLE [dbo].[DepartmentTree](
[DepartmentID] [varchar](13) NOT NULL,
[ParentDepartmentID] [varchar](13) NOT NULL,
[Description] [varchar](30) NOT NULL,
[ManagerEmployeeID] [varchar](13) NOT NULL
) ON [PRIMARY]
here is the xml markup I'm looking for (or facsimile thereof...doesnt really matter)
Code Block
<?xml version="1.0" encoding="UTF-8" ?>
<Department ID="1" Name="IT" Manager="12345">
<Department ID="2" Name="IT Info. Sys" Manager="23456" />
<Department ID="3" Name="IT Technical" Manager="34567">
<Department ID="4" Name="IT Technical West" Manager="45678" />
<Department ID="5" Name="IT Technical East" Manager="56789" />
</Department>
</Department>
Here is my test data:
DepartmentID
ParentDepartmentID
Description
ManagerEmployeeID
1
1
IT
12345
2
1
IT Info. Sys
23456
3
1
IT Technical
34567
4
3
IT Technical West
45678
5
3
IT Technical East
56789
Does anyone have a suggestion as to how to do this?
i have a SSIS package on a server that transfers 4 tables from one database to another.
The pakage runs fine with an admin account who is the creator of the package. The package was created and imported to the server.
A non admin user, is able to connect to SSIS and browse the packages but when he runs the pakage, he gets the following error:
Error: An error occured while trying to get set the table list to transfer. "An exception occured while executing a Transact SQL statement or batch."
Does anyone know how to fix this?
Any help is appreciated.
In SQL Server, is there a way to list all the data pages, index pages, IAM pages, etc. for a given user table? Like this:
Â
Data pages: (1, 200), (1, 201)
Index pages: (1, 202)
Â
Or if that is impossible, then is it possible to list only the data pages for a table?
How to create a script to input one table name(already indexed) to get list of all index for that table?
View 5 Replies View RelatedHi everyone!
I would like to import an excel list into an existing sql server table.
How ist that possible?
Thanks a lot in advance!
Greetings from Austria, landau