USE \[LOGODB\]
GO

/\*\*\*\*\*\* Object:  View \[dbo\].\[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA_CAS\]    Script Date: 30.11.2021 12:29:00 \*\*\*\*\*\*/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

\
CREATE VIEW \[dbo\].\[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA_CAS\] AS
SELECT
\[ID\] AS PLUNo
,\[KOD\] AS ItemCode
,\[ACIKLAMA\] AS Name1
,\[ACIKLAMA2\] AS Name2
,\[BIRIMLIBARKOD\],\[GRUPKOD\] AS GCode
,\[TERAZIKODU\]
,REPLACE(CONVERT(VARCHAR, \[FIYAT\]),'.','') AS UPrice
,\[DARA\] AS Tare
FROM \[LOGODB\].\[dbo\].\[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA\]

GO

USE [LOGODB] GO
/****** Object: View [dbo].[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA_CAS] Script Date: 30.11.2021 12:29:00 ******/ SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
 CREATE VIEW [dbo].[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA_CAS] AS SELECT [ID] AS PLUNo ,[KOD] AS ItemCode ,[ACIKLAMA] AS Name1 ,[ACIKLAMA2] AS Name2 ,[BIRIMLIBARKOD],[GRUPKOD] AS GCode ,[TERAZIKODU] ,REPLACE(CONVERT(VARCHAR, [FIYAT]),'.','') AS UPrice ,[DARA] AS Tare FROM [LOGODB].[dbo].[VW_ZENPOS_TERAZI_DOSYASI_EXCELI_HAZIRLA]
GO

MS SQL