Lets suppose You have executed the given query in SQL SERVER .
CREATE TABLE [dbo].[BookDetail] (
[ID] INT,
[BookTitle] VARCHAR(100),
[BookSummary] VARCHAR(9000)
)
Error Message :
But getting the below error.
Msg 131, Level 15, State 2, Line 4
The size (9000) given to the column 'BookSummary' exceeds the maximum allowed for any data type (8000).
Causes:
The VARCHAR data type is a variable-length while the CHAR data type is a fixed-length, Variable length data with a length of n bytes, where n must be a value from 1 through 8,000.
Solution of the Error:
To avoid this type of error, Please ensure that the length specified for a VARCHAR data type does not exceed 8000.
CREATE TABLE [dbo].[BookDetail] (
[ID] INT,
[BookTitle] VARCHAR(100),
[BookSummary] VARCHAR(max)
)
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.