C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » .NET »

stored procedures


Posted Date: 14 Jun 2007      Posted By: kyatham ramesh      Member Level: Gold     Points: 2   Responses: 2




Hi friends

1.can we create Global variables in sql? how ?
2. can we compile stored procedure each time?
3. what is the limitation of querystrings in .net?

what is stand for @@ in sql

clarify





Responses

Author: Shiva SaiRam    14 Jun 2007Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

3. what is the limitation of querystrings in .net?
- It depends on the browser. In case of Internet explorer it is 255

what is stand for @@ in sql?
In SQL Server 2000 global variables are preceeded with @@ symbols



Author: Sukanya     14 Jun 2007Member Level: DiamondRating: 2 out of 52 out of 5     Points: 2

Stored procedure is a compiled code and if you want to compile it you can just alter the stored procedure and compile it again.
And you can have global variables in stored procedures they will start with @@



Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : Rounded Figure
Previous : need translation in Thai Language
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use