V
V
Vladislav Artemenko2019-05-18 20:10:12
Microsoft SQL Server Management Studio
Vladislav Artemenko, 2019-05-18 20:10:12

How to display MS SSMS 18 view?

I write a simple representation of the type

create view view_1_sql as select kod_filii, nazva_filii, adresa_filii, cout_of_agents from Artemenko_291_main.dbo.Filia

but it does not appear in the "Views" branch....
But when it is repeated, it says that such a view already exists.
When creating a view using the constructor, everything is fine)

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2019-05-18
@vlar909

5ce0448fd8b02493905602.png
-

Addition
USE Testus
GO

IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'Example' )
  DROP VIEW Example
GO

CREATE VIEW Example
AS
SELECT 'Example' AS Example

N
ns5d, 2017-05-15
@ns5d

1. code formatting
2. '{"response":[{"status":"success","message":"2"}]}' is better in Json
3.

$.get( "https://moysite.ru/check.Url?url=blablabla&secrekey=blablabla", function( data ) {

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question