Find solution
How to write SQL statement with dynamic where clause?

How to write a SQL Select Statement ?

  • Hello, I need to write a procedure to print a report Please give me the sytanx of writing a procedure which includes select statement to print a report on the screen.

  • Answer:

    CREATE PROC NameOfProc AS SELECT * FROM Table I've created this basic example to address your 'Update': CREATE PROC NameOfProc2 @UserID int AS DECLARE @Print VarChar(50) SET @Print = (SELECT FirstName + ' ' + LastName FROM Users WHERE UserID = @UserID) PRINT N'User: ' + @Print You can then execute the stored procedure using EXECUTE NameOfProc2 {Param} For example: EXECUTE NameOfProc2 1

TVFWOIO5RTTL4Y2P35XYJZMWR4 at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Select * from table1

AJ

SELECT CustomerName,City FROM Customers; http://www.w3schools.com/sql/sql_select.asp NOTE: If you create a SQL database from a web hosting service, you don't need to write things like CREATE PROC (that is done automatically by the database), you just write the SQL. At least not with the one that I use. You would write the SQL statement along with some PHP code, for example: <?php include("connect.php"); // include the file that connects to your db // assign an SQL query statement to the variable known as sql $sql = mysqli_query($con,"SELECT name FROM Users"); ?> // connect.php <?php // assign an sql query that establishes a connection to a SQL database to the variable known as con $con = mysqli_connect('host','user','pass','db'... ?>

CyberSoul

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.