Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Formatting uppercases the word 'definition' in select #272

Open
Tarjei-stavanger opened this issue Sep 15, 2021 · 1 comment
Open

Formatting uppercases the word 'definition' in select #272

Tarjei-stavanger opened this issue Sep 15, 2021 · 1 comment

Comments

@Tarjei-stavanger
Copy link

This is code from www.sqlservertutorial.net/sql-server-views/sql-server-get-view-information/
It allows us to view the code in a view.

SELECT
definition,
uses_ansi_nulls,
uses_quoted_identifier,
is_schema_bound
FROM
sys.sql_modules
WHERE
object_id
= object_id(
'sales.daily_sales'
);

The Character between the 'select' and 'definition' in the output might not survive copy and paste. It appears to not do that when I pasted the result into OneNote.

@yogeshSawant0931
Copy link

You can use square bracket.

SELECT [definition]
,uses_ansi_nulls
,uses_quoted_identifier
,is_schema_bound
FROM sys.sql_modules
WHERE object_id = object_id('sales.daily_sales');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants