Creating New Stored Procedure (SQL Server)

1. Select "Programability"

2. Select and Right Click "Stored Procedures"

3. Click "New Stored Procedure..." then window opened like this one,

4. Hit "Shift + Ctrl + M" then window pop up like this,


5. Edit "ProcedureName" into your prefer name, then hit OK.

6. I Add the following...


7. Hit the Stored Procedure then click Refresh...

Comments

Post a Comment

Popular posts from this blog

Free Download SRA Verbal Form Test complete test and answer key

One of the most common psychological entrance examination test given by human resource manager during hiring period and job seeker might encounter is either  SRA verbal form test , or the logic test that compost of an images. Here is a free download for SRA verbal form test , the complete test plus the SRA verbal form test answer key are included. 1. BEGIN means the same as or opposite of: _____morning _____work _____start _____journey   2. ENTRANCE means the same as or the opposite of: _____street _____curtain _____theater _____exit   3. Jim had twelve books, he bought three more and then loaned six to George. How many books does Jim have now? _____3_____6_____9_____12_____15   4. A mark which remains after the wound is healed _____F_____J_____N_____S_____V   5. A public sale of property to the highest bidder: _____A_____C_____E_____G_____R   6.The next number in the series 3 5 7 9 11 13 15 is: ______9_____11_____13_____15_____17   7. The next number in ...
Read more

Strategies for Answering Your Customers' Toughest Questions - Appliances

One of the hardest things to do in all of sales either appliances, or service is to handle tough questions from skeptical prospective customers. After interviewing thousands of customers as part of the win-loss studies conducted, we can say with certainty that answering customer questions successfully is often the difference between winning and losing. Here are seven points to consider when answering questions: I. Clarify the question first. Appliances Customers ask two basic types of questions: 1. Some are very specific questions about a feature or issue, while; 2. others are more general about a broad topic or your opinion. In both instances, make sure you understand the question before answering it. 1. Either rephrase the question in your own mind using your own words and repeat it to the questioner aloud, or; 2. ask the questioner to further explain what he meant before answering. Many times salespeople are too eager to give an answer to a question that wasn't even asked. Pleas...
Read more

My 16 Rules of life to follow !

1. Get and stay out of your comfort zone. I believe that not much happens of any significance when we're in our comfort zone.  I hear people say, "But I'm concerned about security."  My response to that is simple: "Security is for cadavers." 2. Never give up. Almost nothing works the first time it's attempted.  Just because what you're doing does not seem to be working, doesn't mean it won't work.  It just means that it might not work the way you're doing it.  If it was easy, everyone would be doing it, and you wouldn't have an opportunity. 3. When you're ready to quit, you're closer than you think. There's an old Chinese saying that I just love, and I believe it is so true.  It goes like this: "The temptation to quit will be greatest just before you are about to succeed." 4. With regard to wh...
Read more