حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to change datatype Bigint to Nvarchar in a View in SQL Server

band.atul

band.atu...

SOLVED CLOSED ACTIVE ANSWERED
User: band.atul
Posted: on Feb 05, 2014 12:11 AM
Forum: SQL Server
Answer: 1
Views: 6877

Sir I want to change data type in view. How to change? please give me the solution

Mudassar

Mudassar

0 2

Reply
ANSWER
User: Mudassar
Replied: on Feb 07, 2014 07:07 AM
Report

You can easily use CAST or Convert to change the datatypes

ALTER view [dbo].[Products] AS
SELECT CAST(Products.ProductId as VARCHAR(5)) [ProductId]
FROM Products

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2026 ASPSnippets.com ALL RIGHTS RESERVED.