sqldataadapter

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: droope (droope_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 12:47:07 -0800

I am using the sqldataadapter to create stored procedures. The tables have
been created using "User Defined Data Types". When the tool creates the
Insert, Update, and Delete procedures the parameters are defined as
nvarchar(50) for all of the fields in the table that have character user
defined data types. It does however create the command parameters correctly.

command parameter example: Me.SqlInsertCommand1.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@ELIGIBLEORGID",
System.Data.SqlDbType.VarChar, 15, "ELIGIBLEORGID"))

proc def: @eligibleorgid nvarchar(50),

The problem that I have is if the user defined data type is longer than 50
characters the proc is created with the nvarchar(50).

The question that I have is has anybody found a resolution for this? How
can the procs be created with the correct datatype?

Thanks.

Relevant Pages

  • Re: A peculiar problem
    ... "Louis Davidson" wrote: ... >> I need to alter data types in all my stored procedures and triggers using ... >> and then to execute them. ...
    (microsoft.public.sqlserver.programming)
  • Re: A peculiar problem
    ... then to execute them. ... But it's not only the parameter data types which need ... > 1.Create a batch file with isql utility using an input file and putting ... Export the generated file(with the modified stored procedures) using ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedures
    ... The only data types that you can pass to a stored procedures are the ... varchar, nchar, etc'). ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I add columns in the form library that exceed the limited .
    ... information (and I would suspect many stored procedures used to read/store ... How can I change the column limit of specified data types? ...
    (microsoft.public.sharepoint.portalserver)