Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
| Name | Data Type | Length | Description |
|---|---|---|---|
| @partnumber | varchar | 100 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.spc_dataparths
@partnumber as varchar(100)
AS
BEGIN
SELECT TOP 1 [id]
,[part_no]
,[part_name]
,[part_name_customs]
,[hs_code]
,[bm]
,[cek_price]
,[part_no2]
FROM [DB_PEMI].[dbo].[tbl_data_part_hs]
where [part_no] = @partnumber
END
GO
GO
CREATE PROCEDURE dbo.spc_dataparths
@partnumber as varchar(100)
AS
BEGIN
SELECT TOP 1 [id]
,[part_no]
,[part_name]
,[part_name_customs]
,[hs_code]
,[bm]
,[cek_price]
,[part_no2]
FROM [DB_PEMI].[dbo].[tbl_data_part_hs]
where [part_no] = @partnumber
END
GO
Depends On
1Used By
No items found