.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

get database column datatype from metadata

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :Sql Server

Is there a way to get the database column DataType length information given a table's EntityType by sql query?


Example like: varchar(MAX), nvarchar(255),decimal(16, 4) .....


I need that query for documentation purpose.

Meng Chew

View Complete Post

More Related Resource Links

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

How to perform math on a column of data in SQL database and display it in my VB app

Sorry if this is the wrong forum, cos it's SQL and VB2010 So I have my sqlserver database 3.5 compact editon called "Dive Club Records" and in it are stored columns of dive trip information and I want tthe user to be able run a query from my VB2010 application to sum a divers total dive hours and display it on the form, eg: MemberID, FirstName, LastName, DiveTime by the way divetime is a real number recorded as 15.5, 20.5, 5.0 etc What is the easiest way to do this? Would prefere to do it from within VB2010 code if possible or make a query from the datagrid on my form using query designer. thanks for any suggestions from you all, hope you can keep them simple for me :)   regards   paul   paul

Using equal operator in transact-SQL for ntext datatype column

Hi, I've a problem with using equal operator in transact-SQL for ntext datatype column. (SQL Server 2000) I'm using the following SQL command text. use NorthwindSelect * from Categorieswhere Description ='Seaweed and fish' If I use 'like' operator intead of '=' then the qurey retuns correct value. Any idea about this? Any help is appreciated. Regards, Julia

How to recover from Derived Column Transformation Editor corrupting table metadata?

Hi there, In attempting to use the DCTE to replace the value in a field with a trimmed version (SSN = trim(SSN)), it seems that my meta-data has become corrupted by the Derived Column drop-down list. As a result, #1: I no longer see my incoming SSN field in the "columns" tree, and any reference to it is deemed "invalid", even though it's value does make it out of the Data Transformation process. How can I get back the reference to this field without redoing this entire task? And, #2: in the process, DCTE created new columns with "SSN" prefixed by the task name, such as "trim character fields.SSN". How can I delete these? It seems that one slip of the mouse in this form can lead to irreversible corruption of the meta-data, which the "debugger" then references and uses to "invalidate" subsequent work. I have tried everything I can think of to refresh this, including using the "Advanced Editor" and reloading the entire package. Any ideas? Thanks, Karl Kaiser

Provision DocumentLibrary with Managed Metadata column

Via the SharePoint 2010 UI I've created a DocumentLibrary and added a new column of type Managed Metadata. I've associated a TermSet with this column and all works fine. Now I need to create a deployment package in Visual Studio 2010. It is easy enough to create the Document Library. I've followed the below steps 1. Create empty SharePoint 2010 project 2. Added new Empty Element to the project. In the Elements.xml I have <Field ID="{15712E76-A603-43AB-885E-CE48BD216381}" Type="TaxonomyFieldTypeMulti" Name="DocTags" DisplayName="DocTags" ShowInDisplayForm="TRUE" ShowInEditForm="TRUE" ShowField="Term1033" Required="FALSE" StaticName="DocTagsInternal" Group="NotSure"/> 3. Added ContentType to the project. Added FieldRef elements to the Element.xml 4. Added List Definition From Content Type and associated it with the above Content Type. 5. Created a List Instance of the above List Definition. 6. Build and Deploy. 7. Associate the column with a Term Set. 8. Add Document to the Document Library. I can select a Term from the applicable TermSet, but when I save the document I get: Failed to get value of the "DocTags" column from the "Managed Metadata" field type control.  See details in log. Exception message: Invalid field name. {00000000-0000-0000-000

What can be the datatype for a column having records as weblinks?

Hi, i am trying to insert records in a column having records as weblinks but it gives me following error. --------------------- Msg 128, Level 15, State 1, Line 2 The name "www.yahoo.com" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. -------------------------------- NOTE : i have tried nvarchar(2083) but still giving me the same error. but if i try insert something like http://yahoo.com i get ERROR : incorrect syntax near 'http:'-   

Write select query with a paremetrized where clause, and populate database with the retrieved column

I want to be able to retrieve column values using the dropdownlist values as parameters then populate the tbPO table with the retreived values. Where and how do I do it. ImportsSystem.Data.OleDb ImportsSystem ImportsSystem.IO Imports ?directcostDataSetTableAdapters PartialClass po_header  Inherits System.Web.UI.Page  Dim cn As OleDbConnection  Dim cmd As OleDbCommand  Dim dr As OleDbDataReader  Dim icount As Integer  Dim str As String  Dim vendor_id As Object   ?  Public Sub btn_click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.ClickTry   context.Items.Add(     cmd.CommandType = System.Data.   cmd.CommandText = Dim context As HttpContext = HttpContext.Current"Company_Name", DropDownList3.Text)Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Owner\Documents\Visual Studio 2010\WebSites\WebSiteJun25\App_Data\directcost.mdb;")Dim cmd As New OleDbCommand()CommandType.Text"insert into tbPO(ponumber, suppliername, ShipTo, basictype, DateNeeded, Purpose,ShippingInstr, ProjId) values(?,?,?,?,?,?,?,?)" cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.Add

Need to link multiple External Content List items to a single document metadata column

I have an external content list - for my purposes, the data isn't any fancier than a list of terms provided by a web service (read only - I don't need update/delete functionality). I want to be able to link any subset of those terms to a single document metadata column (in other words, I need it to work like a normal content list that is defined to allow multiple values in a column) but SharePoint doesn't let me do that on an ECL. I need the content list to be externally driven since more values are going to be added to an outside system over time, but I think it's possible that I may not need a full-fledged ECL list to make this work this way in SharePoint. Just to clarify: I don't need the metadata values in my documents to maintain a PERSISTENT link to the web service (if someone changes an underlying value in the web service DB, it doesn't need to be updated in the document table too). I just want SharePoint to offer up an updated set of source values from the web service if somebody goes in and edits the document metadata. Any ideas for how I can make this work?

search on managed metadata column values

I am trying to search on a managed metadata column in a list.  I have the managed metadata as a mapped property (these are automatically set up actually). I have a column frequency (daily, weekly, monthly, yearly) I can enter a search box owstaxIdFrequency=#a132a333-39f1-4737-9ad4-a932482e025f   //this is the taxonomy guid for Daily.  This shows results. How do I search on the word "Daily" in the frequency column?  (I just want to figure it out on a simple search first meaning just using one search box)   I noticed that there are extra maped columns for managed metadata columns (owstaxIdFrequency also has owstaxIdFrequencyx0020Tag, I tried owstaxIdFrequencyx0020Tag="Daily", but it didn't work)

Select column from all tables in database

I want to retrieve the name and phone columns from all the tables in my database not in systables....   Ok this works but i dont want to get it from just the test table I want to get it from all the tables that I create "USE mrpoteat SELECT name, phone FROM mrpoteat.dbo.test where name = name and phone = phone"

how to get datatype a column in sqlserver ?

hi all I want have datatype a field in sqlserver how to get it with (T-sql) thank you

select only 3 digits from the database table column ?

hi all i want to select data from database like that i have a column name ID , i want to select only first three digits from that column ? how can i do it ?

how to set the computed column into inbuilt database into vs2008 ?

hi..i have designed a database into the vs 2008 mobile database.my batabase has three column column1(int),column2(int),column3(int) and i want to set the value of val(column3)=val(column1)+val(column2);how and where to set the computed column value.

What's the purpose of __sysP1 column in the client's database?

I have a SQL Server 2008 Publisher and SQL CE 3.5 subscriber and every so often the synchronization will fail giving me the error: A subscriber row failed to apply at the publisher. Review the error parameters and the conflict logging tables at the publisher to determine the reason the row failed to apply. [ Table name = <tableName>, Row guid = {F40FF701-4AF1-B011-92B1-CAE5B3335706} ] HRESULT 0x80004005 (28802) What I have found is that if I look at the record indicated above, the only difference from it and other records is that it has the value 0x01 for column __sysP1. I have looked for information on what that column means, but so far all I found is that it is a custom column. Any help will be greatly appreciated.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend