quoted identifier - 'True' ensure only single quotes are allowed when using this database : Database Option « Database « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Database
  3. Database Option

quoted identifier - 'True' ensure only single quotes are allowed when using this database

1>
2> -- quoted identifier - 'True' ensure only single quotes are allowed when using this database.
3>
4> --By setting this to OFF, you can delimit a string by either a single quote or a double quote.
5>
6> CREATE DATABASE myDatabase;
7>
8> EXEC sp_dboption 'myDatabase', 'quoted identifier', 'True'
9> GO
1>
2> Drop database myDatabase
3> GO








Related examples in the same category

1.autoclose: 'True' ensures that the resources are cleared when the last user logs off
2.read only: 'True' ensures no modifications to the data can be made. Only data reads are allowed
3.dbo use: 'True' means that only the user ID that created the database has access and can use the database. Any other ID will be refused
4.autoshrink: 'True' indicates this database can be shrunk in size safely
5.ANSI null default - 'True' ensures SQL Server follows the SQL 92 rules to see if a column can allow NULL values
6.single: 'True' ensures only one user has access to the database at a time. Any subsequent users will be refused