Categories
SQL

Stored Procedures

Creating

CREATE PROCEDURE sp_GetRecord
@pro_num varchar(10)
AS
SELECT *
FROM DATA_DETAILS
WHERE pro_number = @pro_num

Executing

EXECUTE sp_GetRecord '16571565'

Related posts:

  1. SQL: YYYYMMDD SELECT CONVERT(VARCHAR(8), GETDATE()-365, 112) This is a way to query...
  2. SELECT WHERE ANY SELECT * FROM VTM_DATA_DETAILS WHERE (PRO_NUMBER = ANY (SELECT pro_no...
  3. SQL 2005 Stored Procedures Last Modify Date USE Database --Change to the database you want to use...
  4. Convert Julian Dates in SQL SERVER SQL SERVER JULIAN TO DATE (WHEN DOWNLOADING JULIAN DATE) date...