SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Question???
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Professor
Starting Member

5 Posts

Posted - 04/28/2008 :  15:32:36  Show Profile  Reply with Quote
Hi every body

Q/ How I can write documentation as note in SQL SERVER 2000?


tkizer
Almighty SQL Goddess

USA
37119 Posts

Posted - 04/28/2008 :  15:34:51  Show Profile  Visit tkizer's Homepage  Reply with Quote
I don't understand your question.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 04/28/2008 :  16:48:17  Show Profile  Visit spirit1's Homepage  Reply with Quote
well... first you need a music notes sheet. then apply notes to each line. try not to go beyond next and previous octaves

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/28/2008 :  16:53:53  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You don't have the datatype NOTE in Microsoft SQL Server. Only in Microsoft Access.
You have

1) VARCHAR(MAX) for SQL Server 2005
2) VARCHAR(8000) for both SQL Server 2000 and SQL Server 2005
3) TEXT for both SQL Server 2000 and SQL Server 2005



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

m_k_s@hotmail.com
Insecure what ??

38 Posts

Posted - 04/28/2008 :  23:08:16  Show Profile  Visit m_k_s@hotmail.com's Homepage  Reply with Quote
quote:
Originally posted by Professor

Hi every body

Q/ How I can write documentation as note in SQL SERVER 2000?






If you are asking how to comment in tsql, the prefix is --
Go to Top of Page

Van
Constraint Violating Yak Guru

458 Posts

Posted - 04/29/2008 :  12:14:42  Show Profile  Reply with Quote
If it's a long comment (multiple lines), you can enclose the whole block of text with:

/*
text here
and here
*/
Go to Top of Page

eilert
Starting Member

3 Posts

Posted - 04/29/2008 :  20:42:22  Show Profile  Reply with Quote
Also, if you're talking about comments in the code, there is an icon in SQL Server Management Studio that will comment out any selected lines.

If you're not talking about commenting code, then you might be looking for extended properties...

You can add an extended property by using the sp_addextendedproperty procedure:
EXEC sp_addextendedproperty
@name = N'TableDescription', @value = 'This is a test table.',
@level0type = N'Schema', @level0name = 'dbo',
@level1type = N'Table', @level1name = 'tblTest';

(find out more about this proc: http://msdn.microsoft.com/en-us/library/ms180047.aspx )

You can then retrieve it using fn_listextendedproperty
SELECT objtype, objname, name, value
FROM fn_listextendedproperty (NULL, 'schema', 'dbo', 'table', 'tblTest', default, default);

(find out more about this fn: http://msdn.microsoft.com/en-us/library/ms180047.aspx )

Also, if you'd like to SELECT these extended properties from system tables, check out sys.extended_properties:

SELECT
A.type_desc,
A.name object,
B.name ExtendedProperty,
B.value
FROM sys.objects A
INNER JOIN sys.extended_properties B
ON A.object_id = B.major_id
Go to Top of Page

Professor
Starting Member

5 Posts

Posted - 04/30/2008 :  04:12:54  Show Profile  Reply with Quote
I mean (if I want to descripe tables or parameter for other developer by using sql server tools how I can do thet?)



thanks.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 04/30/2008 :  04:23:28  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You mean a documentation tool?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Professor
Starting Member

5 Posts

Posted - 04/30/2008 :  04:29:03  Show Profile  Reply with Quote
It is like documentation tool but manul (writting by developer)
Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 04/30/2008 :  04:39:52  Show Profile  Reply with Quote
MS Word?
Go to Top of Page

Professor
Starting Member

5 Posts

Posted - 04/30/2008 :  04:45:20  Show Profile  Reply with Quote
Mnual documentation like text document to write any thing I want.
Go to Top of Page

Professor
Starting Member

5 Posts

Posted - 04/30/2008 :  04:51:38  Show Profile  Reply with Quote
Can I integrate MS word with SQL server 2000?
Go to Top of Page

m_k_s@hotmail.com
Insecure what ??

38 Posts

Posted - 04/30/2008 :  06:58:25  Show Profile  Visit m_k_s@hotmail.com's Homepage  Reply with Quote
quote:
Originally posted by Professor

Can I integrate MS word with SQL server 2000?



If your document were just text, the first set of suggestions regarding nvarchar(max) as your data type might be ok.

If your document is a word document, there is encoding in the document that would require you to save it as a blob data type.

While you can store the document directly in the database, it is a bit of work to marshall it to and from being a blob and document. But if this is what you really need...

A cheap and easy work around is to maintain the documents in a well thought out directory structure and simply maintain the filename and directory location in your db.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000