There are some aspects in SQL Server that a lot of people get wrong mainly because they seem so obvious that no one dared to ask questions about it. Robert Sheldon said that there are no dumb questions about SQL Server and each deserves frank answers.
Here are some common questions you were to shy to ask:
- “I often come across T-SQL script in which the names of tables, columns and other objects are enclosed in brackets. Even data types are often treated this way. Do I have to enclose object names in brackets?”
- “I’m trying to create a table that contains a foreign key, but I keep getting an error message saying that there are no primary or candidate keys in the referenced table that match the referencing column list. Whatâ€™s going on?”
Aren’t they too obvious? But there are explanations to that. Find out how Â Sheldon answers these questions and what are the other questions we are too shy to ask here:Â https://www.simple-talk.com/sql/t-sql-programming/sql-server-tables—11-questions-you-were-too-shy-to-ask/