Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Database
Checks for valid SQL Server identifier names. All nonbinary and nonzero data, including Unicode data that can be stored by using the nchar, nvarchar, or ntext data types, are accepted as valid characters for identifier names.
Transact-SQL syntax conventions
sp_validname
[ @name = ] N'name'
[ , [ @raise_error = ] raise_error ]
[ ; ]
The name of the identifiers for which to check validity. @name is sysname, with no default. @name can't be NULL
, can't be an empty string, and can't contain a binary-zero character.
Specifies whether to raise an error. @raise_error is bit, with a default of 1
, which means that errors are displayed. 0
causes no error messages to appear.
0
(success) or 1
(failure).
Requires membership in the public role.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today