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


ADVERTISEMENT

Integration Services :: Connect SSIS To Google Drive Or Google Sheets

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

Need Script That Can Shrink Copy Of DB To Fit On A Notebook

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

Transfer Of Subset Of Data To/from Notebook

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

How To Link To ACT7 With SQLexpress,both On Same Notebook.

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

Google SiteMap From SQL

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

Google Your Database

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

Google DB Engine ?

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

GetXpDeleteFileFormat: No Results On Google!

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

Google Like Full Text Search

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







Copyrights 2005-15 www.BigResource.com, All rights reserved