Message Box - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Message Box

Author

Topic

ashishkukreja
Starting Member

16 Posts

Posted - 2007-08-21 : 07:38:13

Hi

I have basic knowledge of SQL Server and Expert in MS Access

Know I want to change my Access Database into Database.
Now what i required is when I create any Procedure
then we use a condition helping keyword 'Where'

No what I required is when I execute any procedure using where clause It must open a Input Box where I put a condition

For Example
when I create a procedure like this

create Procedure prc_Demo
(
a int,
as
Select * from employee where emp_id = 'a'
)

Something like that So I want when I execute this then there must be open a box where I type emp_id then it show matching the result

How can it is possible

Thanks
Ashish

You Have to Loss Many Times to Win Single Time

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-21 : 07:42:20

nope. you have to provide this functionalty in your front end.

or if you want to run it from SSMS then you right click on the sproc and
choose Run it will open a window in which you enter your desired data.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ashishkukreja
Starting Member

16 Posts

Posted - 2007-08-21 : 07:55:48

Thanks very much for your reply sir
I will be try this

Thanks again
Have a very nice day
Ashish Kukreja

You Have to Loss Many Times to Win Single Time

ashishkukreja
Starting Member

16 Posts

Posted - 2007-08-22 : 01:20:54

hi sir

I can't get the meaning of that line so can you explain me again please becasue I try it but I don't get the result

or if you want to run it from SSMS then you right click on the sproc and
choose Run it will open a window in which you enter your desired data.

What is this SSMS?

Please sir reply me urgently

Thanks
Ashish

You Have to Loss Many Times to Win Single Time

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-22 : 01:54:33

ssms is SQL Server Managememnt Studio. it's a client tool for working with sql server databases that comes with sql server.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ashishkukreja
Starting Member

16 Posts

Posted - 2007-08-22 : 02:42:42

Thanks for your reply sir

But I am using SQL Server 2000 (Developer Edition) and there is no such kind of tool which are you saying i.e. SQL Server Management Sudio.

So can you tell me please how can I get that tool or this functionality is in any other version of SQL Server
Please reply me

Thanks
Ashish

You Have to Loss Many Times to Win Single Time

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-22 : 03:19:42

then you must use enterprise manager. but note that you can't just go installing enterprise manager to every client.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ashishkukreja
Starting Member

16 Posts

Posted - 2007-08-22 : 03:35:38

But in Enterprise Manager there is no such option which I required i.e. when I create any procedure then must be a dialog box display

Thanks
Ashish

You Have to Loss Many Times to Win Single Time

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-22 : 03:46:20

sorry... not enterprise manager. you have to use Query Analyzer.
right click stored proc and choose open

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ashishkukreja
Starting Member

16 Posts

Posted - 2007-08-22 : 06:55:28

Sir

their is no such option in Query Analyzer
I can't get that thing what you want to say

Thanks
Ashish

You Have to Loss Many Times to Win Single Time

NeilG
Aged Yak Warrior

530 Posts

Posted - 2007-08-22 : 08:07:11

To do this option in query analyser you need to make sure that the 'Object explorer' is open on the left hand side. Expand the database that has the sproc that you want to test, then expand the stored procedures section and then right click on the spoc that you require.

If the Object explorer is not open, click on the button on the toolbar to open it.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-22 : 08:21:42

<<
If the Object explorer is not open, click on the button on the toolbar to open it.
>>

or press F8

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources