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

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

SQL Procs

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

Hello Experts,

I need small help from you. I just want to know that if we have a stored procedure in sql, which has got just one select statement in it and expected to return a single row and it doesnt have any return statements for the dataset returned. Then can i use that row or can i map those columsn returned from the proc in some script. If yes then how.

Please give your valuable thoughts.


Thanks & Regards,


View Complete Post

More Related Resource Links

Test Run: Automate Testing of Your Stored Procs


Many Windows®-based applications have a SQL ServerT back-end component that contains stored procedures. Although techniques to automatically test functions in the front-end code are well known, the techniques to write test automation for stored procedures are not.

James McCaffrey

MSDN Magazine September 2004

Extended stored procs on 64 bit MSSQL 2008

We need to develop some extended stored procedures for 64-bit SQL Server 2008. We have written the DLL in Visual C++ but when we try to register it with the database, we see the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\xp_test.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15105).(42000,17750) Procedure(xp_test) Can anyone please tell me if you have come across such an issue and how it was successfully resolved? 

problems running stored procs on AS400 iSeries DB2

Hi, Im working on SSIS packages to populate a SQLServer Data warehouse from an I Series AS400 DB2. Downoading data is no problem, using the ISeries IBMDA400 provider. But I need to upload a couple od tables to the iSeries and then run a stored procedure to copy them into the prodution tables. To do this I had to switch to the iSeries provider IBMDASQL. this runs fine when running in BIDS debug mode but when I save the package on the server and run it from a job, it dails with an invalid password on the connection. I have tried this with, Protection level Server Storage, encrypt with password, and dont save sensitive, using a configuration table, in all cases it works fine running in BIDS, on the dev server, but runing as a SQLSERVE job on the same server it fails. when I saved as Server storage i got the following from the job but it works from BIDS Message Executed as user: Domain\XXXXXXXX. ...lity  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  7:38:53 AM  Error: 2010-09-08 07:38:55.30     Code: 0xC0202009     Source: PJCMTest001 Connection manager "GroupQAC.RunProc"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.&

runing a sql procs from a cmd file

Dear all, I need to run a sql procs from a cmd file in order to avoid users to go in SQL server administration AS I am new to that, I do not know what is the best way for that thnaks for help Sample will be helfull regards sergeYour knowledge is enhanced by that of others.

Enterprise t-sql Stored Procs against tables -vs- Views

I work for a very large enterprise and I am wanting to know what is the best way to design t-sql for the stored proces to be used from an application? Option 1 - Be sure to optimize your Database design so your application will only require at most 6 joins and used stored procs for queries using proper indexs to gain the most performance Option 2 - Create Views and use stored procs against the views My questions:  1. What is the perfromance hit in using views.   My thought process is that views should only be used when you know the data you want to return "hence the name 'VIEW', should not be used as a query".   2. Are stored procs against the schema tables the best for performance. 3. What is the best way to tune and ensure your stored proc is optimal with the correct indexes, so you build a lighting fast query? http://www.mmwebs.com

Stored Procs tutorial/learning resources?

I've always used some kind of ORM to fetch data,  LinqToSQL or NHibernate so i guess im spoiled - but now i have a prospective job where they primarily use stored procs.  Not my first choice as i'm not all too comfortable with DBs in general - but i like to brush up on stored procs - almost a Stored Procs for Dummies kind of thingWhats a good resource you guys use for this? I just wanna show that i some initiative and more or less hit the ground running when it comes to stored procs - assuming im selected.Thanks!

Report using Stored Proc calling multiple Stored Procs


Hi guys,

I am new to SSRS. I have to create a report from a Stored Proc. Thi Stored Proc excepts just one parameter 'ErecNo'. This parameter is passed to fetch the columns from table1. This result set contains OrderID. The OrderId is further passes to 5 SP's in to fetch 5 more result sets. Output of the main stored proc contains 6 result sets.

Now I have to create a report using this SP to show all the Result sets in a Single report. But When I pass the Parameter in SP in SSRS. It ends up showing just one result set with Order ID. 

Can you please guide me how can I show all the result set in a Single report? 



Stored Procs: Map Entity to Functions



I'm using VS2010, .net 4.0, EF 4.0

Using the ADO.Net Entity Data Model (edmx)

I have a view that spans > 1 table.

i can still Map my Entity to Functions?


Cannot pass null values to my Oracle procs (ORA-06550)


I am unable to pass null values to my oracle procedures thru my ASP.NET pages. If I do I get the following error:

"ORA-06550: line 1, column 7:\nPLS-00306: wrong number or types of arguments"

But the thing is I need to send null values to the proc and the columns that I am sending null accepts the null values. Does anyone know what might be going on and how to fix it?

Profiling CLR procs/triggers



I am trying to find out if one can profile managed triggers/procs as they execute within an SQL Server instance.

I use VS 2010 Ultimate and I also have JetBrains profiler here too, I am using SQL Server 2008 R2.

I'd like to cause a managed trigger to run say a hundred times and then get a feel for any hotspots, our managed triggers do some serious stuff, invoking remote systems over a network and all sorts, there is a lot going on and it would be nice to get a handle on where this code is slowest.









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