SQL Procedures help plz...
-
Hi Can i get parameters from the user at run time in a SQL Procedure. I want to implement a SQL function just like i used to do in my C++ introductory classes. In the function, i want to ask user to enter name, age, class, and address etc one by one and then i would store this record using INSERT query. Can anyone plz help me? Thank you
We Believe in Excellence www.aqueelmirza.cjb.net
-
Hi Can i get parameters from the user at run time in a SQL Procedure. I want to implement a SQL function just like i used to do in my C++ introductory classes. In the function, i want to ask user to enter name, age, class, and address etc one by one and then i would store this record using INSERT query. Can anyone plz help me? Thank you
We Believe in Excellence www.aqueelmirza.cjb.net
SQL Server is a database server, and has no "run time" user interface development tools. You need to write your interface in a programming language (C++,C#,ASP,etc.), then connect to SQL Server via some data connection method (ODBC,OLEDB,etc) and send your "INSERT query" to SQL Server.
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters