Like Google Notebook
Jul 25, 2007
Hi All,
Has anyone tried writing a db structure that would replicate a google notebook heirarchy?
I'm very interested in learning to do this. My knowledge of MSSQL is poor. I had someone else develop a db in MSSQL for me. I'd like to add a similar functionality for my website to that of google notebooks. I don't need the browser plugins and stuff, only the ability to create new notes and sub notes which can have a few fields. For instance.
A - History
----a1.Name: World War 1
----a2.Name: Germany 1918-1945
----a3.Name: World War 2
------a3i.Name: Causes of World War II
------a3ii.Notes: bla bla bl a
------a3iii.Description: These notes are about the causes of WWII
------a3.SubTopic.a1.Name: Hitler's actions prior to WWII
------a3.SubTopic.a1.Notes: notes notes notes
------a3.SubTopic.a1.Description: desc desc desc
I need to develop a max of two level heirarchy for my website to provide my students a google notebook like functionality. I want to develop it for my school's website. Can someone help?
Navs
View 4 Replies
Aug 12, 2015
I need to download a file from google Drive or open it, using SSIS but I have not found any reference about it. Is it possible? Is there a provider to connect to Google Drive.
View 3 Replies
View Related
Feb 11, 2004
I need a script that will take a 40GB 300+ table database and shrink it to the 1st 1000 rows in each table and delete security tables like tblchargecard. Want to get size to about 1gb to fit on a notebook for development. Any suggestions would be appreciated.
View 3 Replies
View Related
Mar 25, 2004
I have a need to dump a subset of a database from the server (SQL Server) to a notebook via the network, for data entry to be done on the notebook when it is in the field & not connected to the network & then the changes made to this data on the notebook to be applied to the database on the server.
The application for the front end to this is in Access. Would MSDE be the way to go for the database on the notebook ?
It's a small application with not many users, likelihood of conflicting edits is small.
Would the data transfer best be done with replication or with DTS ?
Presumably replication would allow options for control over conflicts, such as the same bit of data being changed on the server & on the notebook’s copy of the data ?
I need guidance re direction to head in with this.
Thanks
View 2 Replies
View Related
Apr 9, 2007
How to link to ACT7 with SQLExpress,both on same Notebook.
I tried to make ODBC via settings Adm.Tools for Sql Server, and I made System DNS,
From Msaccess 2003 I try to male "get external data" and via ODBC databases,.... but it did not work. I don't see
and popping up if listing/prgs/database or whatever, it remains dead.
I can however via Start,Programs work with Sql express studio and with a demo database it is working,but I need the ACT7 tables to work with.
What my main task is, is to connect via Msaccess/ODBC to my ACT7 ( Sql) in order to do some update/import etc etc.
because standard Import features very poor for Additional Contacts etc.
Thanks for any help.
William
View 2 Replies
View Related
Jun 18, 2008
Hello All,
I have two columns in MS-SQL, 1st column has Web-Links and 2nd has Dates
Example:
Names
Date
Link1
Date1
Link2
Date2
Link3
Date3
Link4
Date4
Link5
Date5
Link6
Date6
Required Output:
<?xml version="1.0" encoding="UTF-8"?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <url> <loc>http://www.example.com/Link1</loc> <lastmod>2005-01-01</lastmod> <changefreq>monthly</changefreq> <priority>0.8</priority> </url>
etc.....
</urlset>
Thanks.
- David
View 2 Replies
View Related
Nov 1, 2006
I hope you'll like a tool I've made called Nautilus.
Nautilus (sqlserver) v1.0.1
Google your MS SQLServer database
http://sourceforge.net/projects/nautilus/
Author: Marcos Luis Casamayor (marcos.casamayor@gmail.com)
WHAT
----
Nautilus is a tool for developers, advanced users and auditors.
The main objetive is to find information in a SQLServer database without knowing too much about the database. User can search tables and records with no SQL knowledge required.
You can also browse related data following the foreign key links.
View 7 Replies
View Related
Jul 20, 2005
Hi,I was so lost in Google Desktop Search last night, I kept on dreamingabout the endless possiblisties of Google Search Technology.While I was in school I had read enough about DB informationretrivial. Why can't google use their search technology to buildDatabase engine ? Isn't that a possiblity ?Am I still dreaming or am I awake ?Cheers,da_LazyBoy
View 5 Replies
View Related
May 27, 2008
Maintenance plan cleanup task is failing on one of my client servers with the following message:
Method not found: 'System.String Microsoft.SqlServer.Management.DatabaseMaintenance .TaskUIUtils.GetXpDeleteFileFormat(Boolean, Boolean)'.
A google search for "GetXpDeleteFileFormat" returns zero results, as does a search of the MS website.
Any clues?
View 6 Replies
View Related
Jul 15, 2004
Hello,
I have a Full-Text Catalog that is populated by various columns in a few different tables. I have been able to create a stored procedure that will search across all of the different full-text columns and return me the results.
My problem is, if the someone searches for
hello world
then to my understanding I want to use FREETEXTTABLE to return my results (I actually get 0 results if I use CONTAINSTABLE)
If someone searches for
"hello world"
then I want to use CONTAINSTABLE because FREETEXTTABLE returns too many results.
And now the biggest problem would be, if someone searches for
"hello world" program
I would somehow need to use CONTAINSTABLE for the phrase and FREETEXTTABLE for 'program'. The SQL to accomplish something like this would probably be very ugly (if possible at all)
Can anyone give me any suggestions on this matter? I'm trying to create a google like search on a database which contains text and files (as BLOBs).
Thanks in advance
View 5 Replies
View Related