Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    4

    Unanswered: help me out for storing more data

    CREATE TABLE [dbo].[blogs] (
    [blog_title] [nvarchar] (500) ,
    [blog_desc_full] [varchar] (8000) ,
    [blogger_name] [nvarchar] (100) ,
    [mailid] [nvarchar] (100) ,
    [blogid] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
    [blog_desc] [nvarchar] (125) ,
    [cat_name] [varchar] (100) ,
    [b_url] [varchar] (250) ,
    [b_date] [datetime] NULL ,
    [author] [nvarchar] (250) ,
    [approval] [char] (1)
    ) ON [PRIMARY]
    GO

    using this script i have created my blog table.

    and a procedure given below. i am using to insert data in it.


    CREATE PROCEDURE SP_BlogAdd

    @blog_title nvarchar(500),
    @blog_desc_full varchar(8000),
    @blogger_name nvarchar(100),
    @mailid nvarchar(100),
    @blog_desc nvarchar(125),
    @cat_name varchar(100),
    @b_url varchar(250),
    @author nvarchar(250)

    AS

    INSERT INTO blogs(blog_title, blog_desc_full, blogger_name, mailid, blog_desc, cat_name, b_url,author)
    VALUES(@blog_title ,@blog_desc_full ,@blogger_name,@mailid ,@blog_desc ,@cat_name ,@b_url,@author)
    GO

    now, the problem i m facing is.
    i am using varchar datatype for [blog_desc_full] [varchar] (8000).

    i want more than this size to store data in it.

    please give me some detailed code.

    i tried text datatype but i didnt succeed. how to use text datatype.
    i replaced with text datatype.but in length i couldnt type. it shows only 16.

    Please help me out.

    regards,
    ASIF

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •