|
I am using SQL Server 2000.
|
|
|
|
|
I think you can get table characteristics by looking in the system tables. Don't quite have the info right infront of me at the moment.
---modified
Never mind, imsathy got it 
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
SELECT <br />
TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH<br />
FROM INFORMATION_SCHEMA.COLUMNS<br />
WHERE TABLE_NAME = 'your table name'
Sathy
|
|
|
|
|
|
Its a pleasure 
Sathy
|
|
|
|
|
Hi All,
We have a PDF document about 2MB.It has many web links.
We are trying to get this document into a database format with search & reporting capabilities and we want to preserve all links and text formats in the document.
We have a couple of questions:
- What database technology could we use that could run on both a CD and a web site?
- What conversion tools (and processes) would be best to use to import the content into a database?
-Can SQL Server 2000 Reporting Services help us? If so,how?
Any help/suggestions will be appreciated.Thanks.
|
|
|
|
|
Good luck is all I can pretty much say right now 
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Makhangs32f wrote:
We have a PDF document about 2MB.It has many web links.
2MB isn't very big. I think it would be easier to migrate the content by hand rather that trying to do it programmatically.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Paul,
Thanks for your reply.
To migrate the content,here is our initial plan:
-Convert PDF into a word or text file.
-Use SQL loader to transfer the content to the database.
We appreciate your comments on this plan.Also please feel free to suggest any other way to migrate the content to a database.
|
|
|
|
|
Makhangs32f wrote: Also please feel free to suggest any other way to migrate the content to a database.
Not knowing anything about the structure of your data, I can't really help.
The content of a PDF file is likely to be unstructured. This means it would be difficult to write scripts to load data into a structured repository like a database. Your best bet is to cut and paste the content into Excel or a text file and load the data from there.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Paul,
Thanks for your suggestions regarding loading the PDF into a database.
We have one more thing where we need your suggestion.
We need to publish the database in some format (e.g., XML, MySQL, etc.) to a CD-ROM or DVD.Please let us know if you know some way to do it.Or if you can post a couple of URLs that we can look at to get some ideas on it,that will be helpful too.
Thanks.
|
|
|
|
|
If you are using SQL Server 2005, you should consider using SQL Server Integration Services (SSIS) to produce your exports. This site[^] has plenty of useful information. I suggest you search it for information on exporting data to specific formats. Deciding what format to export your data depends largely on the requirements of the people who will be consuming the data. Have you discussed this with your users, and what have they told you?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hello,
I have datatable and it is populated with some values.
Is it possible to add a column in an exiting datatable now with a auto increment values?
I am trying like this but it does'nt wotk
dslistItems1.Tables[0].Columns.Add("ID", Type.GetType("System.Int32"));
DataColumn[] pk = new DataColumn[1];
pk[0] = dslistItems1.Tables[0].Columns["ID"];
//dslistItems1.Tables[0].PrimaryKey = pk;
dslistItems1.Tables[0].Columns["ID"].AutoIncrement = true;
dslistItems1.Tables[0].Columns["ID"].AutoIncrementSeed = 1;
dslistItems1.Tables[0].Columns["ID"].ReadOnly = true;
This code doesn't populate the values in the column
Regards,
Pavas
|
|
|
|
|
mpavas wrote: Is it possible to add a column in an exiting datatable now with a auto increment values?
It is possible to add a column in an existing datatable with data's in it .. but u CAN'T set it to autoincrement
Sathy
|
|
|
|
|
|
Hii all,
I want to know how to insert multiple rows into a single column with one single statement. I want structure something like this.
JobNumber Supply Parts
J001 Tyres
Bonnets
Engine
J002 Mirrors
Seat Cover
Is it possible in Sql Server 2005 or My Sql. I want to insert values where column JobNumber will have only one value and Supply Parts for that particular job number say J001 will have different values like above in SupplyParts column.
Any help will be greatly appreciated
Thanks
Imran
|
|
|
|
|
You want to have more than one table and set up a relationship between tables. Then you create a row that represents the "job" in one table, and a series of rows in the other table to represent the supply parts. The supply parts table would have a link back to the job table.
|
|
|
|
|
hi All
i have a stored Procedure that runs well ,So i want to Run this Procedure in DTS, i get this Error
Invalid Pointer
My Stored Procedure runs well in Query analyzer, but when i use it in a DTS it gives me that Error. This is the name of my Stored proc
SDE.ACTIVITY_PROPERTIES_WITHOUT_NEW_GV_vUYI @Error = ' '
wHAT IS WRONG
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Use the SET NOCOUNT ON at the start of the query in your stored procedure and SET NOCOUNT OFF at the end of the query.
This should help resolve "invalid pointer" error messages.
This is a known issue with DTS packages.
Regards
Guy
You always pass failure on the way to success.
|
|
|
|
|
Thanks man you are a Star its Working
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
You're welcome
You always pass failure on the way to success.
|
|
|
|
|
hi folks
Actually from an employee database table i am reqd to find out the duration of time from the date of joining of that employee till 1st Jan 2008. How to do that .plz help.The date of joining field is date_of_join.
Thanks.
skd
|
|
|
|
|
Something like this[^] (Assuming that you are working with Sql Server)
|
|
|
|
|
Hello guys.
Im looking for a select statement for vbscript to access my Birthday database and display all the people that celebrates their birthdays on that particular day given that the day and month corresponds with the system month and day.
")
end if
rs.close
set rs = nothing
end if
%>]]>
Here is my script at the momen.If you have a script that mite work or a website that may help.Please help .Thanx in advance.
kagiso
|
|
|
|
|
matjame wrote: you have a script that mite work
You've given nobody any idea what the tables are like in your database. You expect people to magically know?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
