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.
| Author |
Topic |
|
gsrinivas.
Yak Posting Veteran
56 Posts |
 Posted - 2008-10-21 : 11:09:59
|
| hello all,this is srinivas,can you anybody tell me please about "taking input from keyboard to sql server 2005" without using any front end.please reply.thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-21 : 11:17:19
|
| you cant take input directly from users to sql server 2005. you need to use your front end to design form/GUI for that. and captured values needs to be passed to sql server as parameters and write query in sql to accept parameters and return the data from tables based on passed values. |
 |
|
|
gsrinivas.
Yak Posting Veteran
56 Posts |
Posted - 2008-10-22 : 02:45:01
|
| thank you for reply.but i know that our sql server is a mid layerin real time projects.that means ... .Net framework sqlserver -------------- ---------- step 1)input(textbox)------> 2)database processing | 3)output(gridview)<------------i know about all these treditional formates.generally we send parameters to stored procedure.then executes.but in oracle there is a chance to take input directly from keyboard.(using '&' symbol) "is there any alternate in sqlserver" .that is my doubt.please reply... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-22 : 02:50:37
|
quote:
Originally posted by gsrinivas.
thank you for reply.but i know that our sql server is a mid layerin real time projects.that means ... .Net framework sqlserver -------------- ---------- step 1)input(textbox)------> 2)database processing | 3)output(gridview)<------------i know about all these treditional formates.generally we send parameters to stored procedure.then executes.but in oracle there is a chance to take input directly from keyboard.(using '&' symbol) "is there any alternate in sqlserver" .that is my doubt.please reply...
yup i know oracle you've that provision. But we dont have anything of that sort in sql server. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-10-22 : 05:36:03
|
| Yes, there is no way to script for a prompt in general use. However if all you want is to run a stored proc and pass it paramaters you can go into management studio, navigate to the stored proc. Right click on it and go to 'execute Stored Procedure' Management studio will then prompt you for values for the paramaters.Probably won't help you but you never know,Regards,-------------Charlie |
|
|
|
gsrinivas.
Yak Posting Veteran
56 Posts |
Posted - 2008-10-22 : 09:37:33
|
| thank you charlie... |
|
|
|
|
|
|
how to take input from keyboard