⟩ What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?
- To modify the datatype of a column the column must be empty.
- To add a column with NOT NULL constrain, the table must be empty.
Question and Answer:
Home SQL
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Tell me why would you use SQL Agent?
Tell us about your SQL Server DBA Experience?
Do you know what happens on checkpoint?
Tell us can we hot add CPU to SQL server?
Do you know what purpose does the model database serve?
Tell me what is Transparent Data Encryption?
Tell us how many files can a Database contain in SQL Server?How many types of data files exist in SQL Server? How many of those files can exist for a single database?
Tell us do you have experience working with Hadoop?
Tell us what is SQL Server Reporting Services?
Tell us what the different components of Replication and what is their use?
