M
M
maks8442014-02-24 13:27:41
SQL
maks844, 2014-02-24 13:27:41

How to write MSSQL stored procedure with Russian comment?

How it is possible to implement record in service fields of stored procedure, for example in EXTERNAL_NAME, the Russian text during CREATE/ALTER of stored procedure?
Let's say there is a stored procedure on MSSQL
ALTER PROCEDURE [dbo].[ReportGetUsersByClubId]
(@clubId BIGINT)
AS
BEGIN
SET NOCOUNT ON;
SELECT * from Users Where club_id = @clubId
END
How to add a comment to some service field. For example : User list retrieval report

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
asd24, 2014-02-27
@asd24

INFORMATION_SCHEMA is a system directory and MS SQL Server doesn't seem to give permission to manually modify its contents.
To solve your problem, create a StoredProceduresDescrition table in which you store the information you need..

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question