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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
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

  

Dears,

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 '



Categories: 
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