Tables Description

Jun 3, 2007

I have hundreds of tables in my database.
Is there a way to get a list of them with a description
of their content (the procedure and the transaction they
are related to, the way columns are created)?

Thank you. Anna - Verona (Italy)

View 2 Replies


ADVERTISEMENT

Adding Description To Tables And Fields

Oct 27, 2000

Can I add a description to a table or field? The way access gives you to add a description to a field.


Thanks!

View 1 Replies View Related

Where Is Stored Columns Description For SQL Server Tables?

Jul 20, 2005

I am a beginer in SQL Server and if someone knows I would like to knowwhere are stored columns description - am refering at that columndescription that can be write for each column when you create a tablein a SQL Server Database using SQL Server Enterprise Manager.I want to get this information from the database and display it in aC# application, I 've tryed COLUMNPROPERTY function and sp_columnsprocedure, but this are not giving me the column definition, onlytype, name, etcThanksMaria

View 4 Replies View Related

Joining Tables - Return Name / Description And Keyword For Every Record ID

May 7, 2012

I have 3 tables I'm trying to join:

Table 1: Contains ID, Name, Description
Table 2: Contains ID, Keyword
Table 3: Is lookup table for tables 1 & 2

I need a query to return a table having columns of:
Name, Description, Keyword for every record ID in Table 1

The issue is that table 2 contains multiple keywords for each key ID and my query returns an error: Subquery returned more than 1 value.

When I run this query using a specific key, it returns the correct information the way I want it:

DECLARE @ServiceID VARCHAR(10)
SET @ServiceID = '35'
DECLARE @Name VARCHAR(8000) DECLARE @Desc VARCHAR(8000) DECLARE @Keywords VARCHAR(8000)
SELECT @Name = [DefService].[Name],@Desc = [DefService].[Description],@Keywords = COALESCE(@Keywords + ', ', '') + [DefKeyword].[Name] FROM [DefService] INNER JOIN [DefKeywordServices] ON [DefService].serviceid = [DefKeywordServices].[ServiceID] INNER JOIN [DefKeyword] ON [DefKeyword].[KeywordID] = [DefKeywordServices].[KeywordID] WHERE [DefService].[ServiceID] = @ServiceID PRINT @Name + ' | ' + @Desc + ' | ' + @Keywords
SELECT @Name AS Name,@Desc AS Description,@Keywords AS Keywords

Results:
NameDescriptionKeywords
GoToMyPC - Account RequestRequest a Citrix GoToMyPC account.GTMPC, GoTo, application, software, install, Installation, applications

When I run the same query without a specific key it fails. The results only return a single row containing Name, Description and then ALL keywords for every key ID...very odd behavior.

BTW, I need to do this in a single SQL query and not a stored proc or other method.

View 10 Replies View Related

How To Get The Description ?

Jul 27, 2005

Hi,I have a SQL that is working fine:
SELECT DISTINCT T1.ATCkod FROM ATC_tot T1    JOIN ATC_tot T2 ON T2.ATCkod = T1.ATCkod and T2.Typ_lakemedel LIKE '%' + @Kod2 + '%'    JOIN ATC_tot T3 on T3.ATCkod = T1.ATCkod AND T3.Typ_lakemedel LIKE '%' + @Kod3 + '%'    WHERE T1.Typ_lakemedel = @KodNow I need to have a description together with the ATCkod, tablename ATC columnname ATCdesc. ATC_tot.ATCkod = ATC.ATCkod. I have tried Inner join without success. Any good suggestions ...?

View 1 Replies View Related

How Can I Set Description Property By T-SQL ?

Jun 6, 2007

I would like to create table by T-SQLand need to specify DescriptionBut I can't find any sample to add Description property by T-SQL  Additionally, I also would like modify Description property by T-SQL. What can I do ?????  Please help me ...... 

View 2 Replies View Related

Description Field

Sep 30, 2004

Hi

Getting an error on the following SQL. The field in question is the Description field which has * in the description. Not sure how I should have the SQL to solve this

UPDATE Taylors
SET Area=::Area::,Avail=::Avail::,Address=::Address::,Type=::Type::,Price=::Price::,Bedrooms=::Bedrooms::,HotProps=::HotProps::,Office=::Office::,Description=::Description::
WHERE RefNo =::RefNo::


Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* modern retirement flat * double bedroom * south lounge * fitted kitchen * good size bathroom * communal gardens * residence parking *'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

View 1 Replies View Related

Column Description

May 18, 2005

Hello, it seems I forgot how to do it,
I want to create a query to get the column description table, I mean get structure without data.
I remember it was select DESC or something like that, donno if im right!!!
 
regards

View 6 Replies View Related

Syntax Description Help - *=

Mar 22, 2001

WHat does *= do in SQL syntax?

eg, SELECT * FROM Cars WHERE COLOR *= "Blue"

thanks,
Nick

View 1 Replies View Related

Getting Error Description

Dec 29, 2005

Hi all,
I need to get the error description from the SQL Server in a SP. For ex:

I have one insert statement which is inserting some values in a tabUserMaster table. If user tries to insert any duplicated row then following error is retruned [in Query analyzer].

Server: Msg 2601, Level 14, State 3, Procedure csp_ProvisionUser, Line 70
Cannot insert duplicate key row in object 'CoreUser' with unique index 'IDX_CoreUser_UserName'.
The statement has been terminated.

I want to trap this whole message in a variable. How to do this..... :(

View 5 Replies View Related

Description Column In SP

Dec 17, 2013

I am having trouble bringing "description" column in to my sp and them at the out put. in the ppatient_status_mstr there is a column called“description” which has patient status such as “discharged” “termed collection” etc... How do I use the SP to bring this description into application? I am assigning it to @mytext. I am not sure how to declare “description” in the SP? Every time I use it I get errors like:

Msg 4104, Level 16, State 1, Procedure CheckStatus, Line 20
The multi-part identifier "pm.alerts_ind" could not be bound.
Msg 207, Level 16, State 1, Procedure CheckStatus, Line 40
Invalid column name 'description'.
Msg 207, Level 16, State 1, Procedure CheckStatus, Line 43
Invalid column name 'description'.

I want to say if user picks a description from application . show me that description in output. But I am having trouble how to use the description? I am not sure if my “IF” statements are correct either?

Here is the procedure

ALTER PROCEDURE [dbo].[CheckStatus] (@enc_id varchar(36) OUTPUT, @Mytext varchar(50) OUTPUT, @data_ind Char(1) OUTPUT)
AS
BEGIN
DECLARE
@alerts_ind char(1)

[code]....

View 20 Replies View Related

Columns Description How To Use It On QA

Sep 20, 2007

how do you use columns description on QA? I want to type it in some description for my columns. I see this option on EM. Need to know how to do it on QA

=============================
http://www.sqlserverstudy.com

View 19 Replies View Related

Get The Description Of A Column

Jul 23, 2005

Okay guys heres the senario.I have written a kick butt asp application that allows me to test sqlstatements and manage/display all my databases from the web but I havea feature I want to include that I can't figure out how. In EnterpriseManager, one of the column editable properties is the ColumnDescription. I can't find it in sql server itself. only in theEnterprise Manager. I need to access it using a sql statement so thatit will display in my table definiation view that I create in the aspapp.

View 1 Replies View Related

Get Description In Table

Jul 20, 2005

i want get fields description in structure tables that i madetables.please help me for resolve this problem .thank you

View 2 Replies View Related

Table Description

Jul 20, 2005

Hi All,In SQL Server how can I get the descriptions of tables in adatabase?From MSDN help I could find a way to get the description of columnsusing the following extended propertySELECT *FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table','Reports', 'column', default)ThanksRegardsSobhan

View 1 Replies View Related

Error Description

Nov 1, 2006

I want to club the ErrorDescription system variable property in OnError.

And I want to send this whole ErrorDescription variable on onTaskFailed.

Can you please suggest how to club this errordescription on OnError event



View 5 Replies View Related

ErrorCode Description

Dec 11, 2007



This is a request to the Microsoft SSIS staff.
I did a search for the keywords in the description and can already see a lot of people frustrated about this.

A lot of well designed integration packages will route error messages to an error table or file.
SSIS appends a couple of extra error columns called ErrorCode and ErrorColumn. At runtime, an extra
column is visible in the DataViewer called ErrorCode - Description.

The description is hardcoded into the dtsmsg.h file in the SDK folder of Sql Server.
This file is very hard to parse.

Can some from SSIS please post an XML or CSV file with all the error codes and descriptions for us to download please.
This will be such a big help in debugging.

Many Thanks.


Shailen Sukul
Software Architect/Developer/Consultant
(BSc | Mcts (Biztalk (IP)) | Mcpd | Mcts (Web, Win, Dist Apps) | Mcsd.NET | Mcsd | Mcad)
Ashlen Consulting Services Pty Ltd
(http://www.ashlen.com.au)
MSN | Skype | GTalk Id: shailensukul
Ph: +61 0421 277 812
Fax: +61 3 9011 9732
Linked In: http://www.linkedin.com/in/shailensukul

View 3 Replies View Related

Number / Description Of Sql Error

Oct 24, 2006

HiAll Sql Server errors have a number. Is there any MS or MSDN website or any .net method in which I can see these errors?Thanks a lotswitch (error.Number){case 17:msgErro =....break;case 4060:msgErro = ....break;case 18456:msgErro = .....break;default:msgErro = exSql.Message;break;}

View 2 Replies View Related

Searching In Title And Description

Apr 29, 2007

hey guys, so i have my website, everything is ok, until i have to put in a title field, along side my description. so far i have this code which searches in the description, how can i make it so i can search in the title as well
SelectCommand="SELECT [Stock_ID], [cat_id], [description], [size],
[selling_price], [qty], [picture1] FROM [tbl_stock]
WHERE ([description] LIKE '%' + @description + '%')">
 Any help would be great
 Cheers
Jez

View 2 Replies View Related

Item Description In Shorthand

Jun 29, 2005

Hi,

If you browse to Amazon and drill down through categories until a paged
listing appears, you will see in each item of the listing that the
description rendered as Book Description, is a cutdown version of the
full description, with a ... and "Read More" hyperlink.  How is
this achieved programatically? I dont know if thre is an efficient way
in SQL Server to do this, or whether it would be easier to have a
ShortHand field and a Description field, both of which are teh full
description when shown in the Details page, but the ShortHand is the
field rendered in listings.  This seems like a simplistic solution
and I am thinking there may be programmatic means of doing the same -
has anybody got any experience in this area?

Thanks!

jr.

View 4 Replies View Related

SQL Server2000 And COLUMN DESCRIPTION

Nov 16, 2001

HI

I have a big problem with SQL server2000. I can't get COLUMN DESCRIPTION.
I will print DATADICTIONARY from a DB, I can get all elemnts (table name, columns name, datatype, precision, scale, FK, PK, default value..) I missed only DESCRIPTION. How I can get it????

Medo

View 1 Replies View Related

Description Of *.ldf File Format

Apr 28, 2002

do anyone know the format of the *.ldf file?

View 2 Replies View Related

Accessing Description Field

Mar 20, 2001

On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?

Thank you!

View 2 Replies View Related

Table Description Information

Jul 20, 2000

In oracle there is a describe command:
describe table_name
This command will tell you the columns names, datatypes, and length of the columns for that particular table. Does anyone know if there is a simliar command in SQL server that would do that? The only way that I have found so far is to do a join of the syscolumns with sysobject by table name.

View 2 Replies View Related

Where Is "description" Col In Repository Metadata

Apr 20, 2000

I'm trying to create a Data Dictionary view from system table info like tablename, fieldname, datatype etc. I can find all that I need except for the "description" field which is displayed in Enterprise Manager/ Repository metadata pane.

How can I locate this field so I can reference it in a view? Isn't it stored in a system table? Master, model? Where is it?

Thank in advance,

Phil

View 1 Replies View Related

Accessing Description Field

Mar 20, 2001

On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?

Thank you!

View 1 Replies View Related

List Column Name And Description

May 26, 2006

Hello everybody,

If I know the table name, is there any command to list all "Column Name" and the Columns "Description" as shown in the Design Table window.

Any feedback is welcome!

Thank you,

Edi

View 3 Replies View Related

Systems Analyst - Job Description

Apr 7, 2004

Does anyone have a description of what is a System Analyst responsibility should involve. I was recently assigned the title and is no longer sure what my responsibility should entail. I asked mgmt for a description. Still waiting.

Thanks.

View 8 Replies View Related

Description Properties In SQL 2000

Jul 15, 2001

A query to get the Table and Column Description fields in SQL Server 2000.


SELECT so.name, sc.name, sc.xtype, sc.length, sc.colid,
tableprop.value as TableDescription,
colprop.value as ColDescription

FROM

sysobjects so

INNER JOIN syscolumns sc ON sc.id = so.id
INNER JOIN sysproperties tableprop ON tableprop.id = so.id and tableprop.type = 3
INNER JOIN sysproperties colprop ON colprop.id = sc.id and colprop.type = 4
and colprop.smallid = sc.colid

WHERE so.type='u' and so.name = 'TableName'

Order by sc.ColID





Damian

View 2 Replies View Related

Adding A Table Description

Jul 31, 2007

Hi everyone,

I'm using SQL 2005. I want to add a description for each table on my database. How do I do that? I know I can add a description to each field, but how do I add a description to each TABLE? I tried going to Properties but don't see anything.

Grateful for any help. Thanks.

View 12 Replies View Related

Get And Set Column Description From Sql Server2005

Aug 10, 2007

I dont know,how can I get column description from Sql Server 2005 and use it in vb.net 2005? would you please help me solve it?

View 1 Replies View Related

Set COLUMN Description In .Net 2005,

Aug 13, 2007

Hi,
I want to set column description in .Net 2005, Please guide me.
thanx very much

View 1 Replies View Related

File / Table Description.

Aug 24, 2005

Newby question but can't find it myself.How can I get a file-description from a file / table ?eg. the decription must deliver the following info:Record nr.Field nr.FieldnameField descriptionData typeLenghtDecimalsetc....Can somebody please tell me what to do?ThanxMF

View 5 Replies View Related







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