With the help of below SQL script we will get the max length
of the data of the table.
|
declare @sql varchar(8000),
@table_name varchar(50)='Employee',
@table_schema varchar(50)='HumanResources';
set @sql = 'select '
select @sql += 'max(len( ' + column_name+ ')) AS ' + column_name + ','
from information_schema.columns
where table_name = @table_name
and TABLE_SCHEMA= @table_schema
and data_type in('varchar','char','nvarchar','nchar')
set @sql = left(@sql,len(@sql) -1)
set @sql +=' from '+ @table_schema+'.'+@table_name
exec (@sql)
|
Basically
this script create a dynamic sql script to get the max length of the column.
Here I am
getting only varchar, nvarchar, char or nchar data type column.
The below script is generating this script.
|
select
max(len( NationalIDNumber)) AS NationalIDNumber,
max(len( LoginID)) AS LoginID,
max(len( JobTitle)) AS JobTitle,
max(len( MaritalStatus)) AS MaritalStatus,
max(len( Gender)) AS Gender
from HumanResources.Employee
|
We will get the same result as above.
Did you hear there's a 12 word sentence you can say to your man... that will trigger deep emotions of love and impulsive attraction for you deep within his heart?
ReplyDeleteBecause deep inside these 12 words is a "secret signal" that triggers a man's impulse to love, worship and look after you with his entire heart...
12 Words That Fuel A Man's Love Instinct
This impulse is so hardwired into a man's brain that it will make him work better than before to make your relationship the best part of both of your lives.
Matter-of-fact, triggering this influential impulse is absolutely binding to getting the best possible relationship with your man that the moment you send your man a "Secret Signal"...
...You will instantly find him expose his heart and soul to you in a way he's never expressed before and he'll distinguish you as the only woman in the galaxy who has ever truly fascinated him.