please help me.
-
explanation; I have one table in my sql database called tblStores .it have a column called name .i have created this table by using wizard in the enteprize manager what is problems: when i insert rows into the table (execute storedprocedure and pass the parameter value for it in query analyser)only the first character is inserted .if i call this procedure from asp.net this problem apear again.only if i use the datasheet view in enteprize manager the whole word is inserted . .when i create the script of this table the result was: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblStores]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tblStores] GO CREATE TABLE [dbo].[tblStores] ( [id] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , ) ON [PRIMARY] GO thank you.
-
explanation; I have one table in my sql database called tblStores .it have a column called name .i have created this table by using wizard in the enteprize manager what is problems: when i insert rows into the table (execute storedprocedure and pass the parameter value for it in query analyser)only the first character is inserted .if i call this procedure from asp.net this problem apear again.only if i use the datasheet view in enteprize manager the whole word is inserted . .when i create the script of this table the result was: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblStores]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[tblStores] GO CREATE TABLE [dbo].[tblStores] ( [id] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , ) ON [PRIMARY] GO thank you.
check your stored procedure parameters. It seems that you are not passing a parameter with type as nvarchar(500) Sanjay Sansanwal www.sansanwal.com