database coding

Asked by At

Why all variables and datatypes are kept in '[]'

CREATE TABLE [dbo].[tblExerciseMultiMailTypeStructureDetails](
[ExerciseMultiMailID] [int] NOT NULL

1 Answers

Community On

Any name that are same as SQL Server Keywords or containing embaded space must be enclosed in double quotes("") or square brackets([]). Which words are considered as keyword varies,depending on the compatibility level to which you have set your database.