Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

store procedure

Home
Forums

store procedure

Ramya S

10yAsked Apr 5, 2016, 5:29 AM1.1k

My Question is can we change column datatype of store procedure after creation?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Shubham Kumar10y ago
Accepted answer
Ramya Firstly proc have not any column it have parameters if you want to change the parameter datatype so its possible just alter the proc as your desire change after datatype
0
Shubham Kumar10y ago
No, You have to do like this

before -- on creating time
create procedure sp_insertdata
@someParameter varchar(20)
As
begin
--your query
end
------------------------------------
after -- on altering time
Alter procedure sp_insertdata
@someParameter varchar(10)
As
begin
--your query
end

and execute it
0
Ramya S10y ago
Here i want to change the varchar (size) from 1 to 10 of the parameter, how to do
ex:alter proc sp_insertdata alter @name varchar(20)
0