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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

WITH with Storeprocedure

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
Hi All,I have sp as:-EXCE sp_storeproducename 'parameter1', 'parameter2', 'parameter3', 1which will execute some 'n' number of columns depends on the value of last parameter (1)Now, I want to save the ouput of the above sp into some table  WITHOUT creating temporary table, Can I use With; statement if so how?This is because my result which comes out of the sp are different, if I useEXCE sp_storeproducename 'parameter1', 'parameter2', 'parameter3', 2than it will be give me output with 'n-1' number of columns.Can anybody help me out?ThanksRegards,Kumar

View Complete Post

More Related Resource Links

How to call a storeprocedure from another storeprocedure



How can I call a store procedure from the other storeprocedures ?

How to write storeprocedure update special character in Sql server 2005


Hi All,

I am using Sql Server 2005,My table structure is below.

Create Table ComentTable(id int,coments varchar(4000))

insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')

insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')

how to write storeprocedure update coments column replace %27 to '

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