This blog show how to create a basic view in sql server using query analyzer
Syntax:
CREATE VIEW [ schemaname . ] viewname [ (columnNames) ]
[ WITH [ ENCRYPTION ] [ SCHEMABINDING ] [ VIEWMETADATA ]]
AS selectStatement
[ WITH CHECK OPTION ]
Example:
Create View dbo.vEmptable
AS
Select empid, empname, empsal from emptable
GO
SQL Server Transact Basic to Expert - Create basic View
SQL Server Transact Basic to Expert - Create basic View
Join the conversation! Your thoughts help the community grow.