TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
anjumathi kumar
NA
54
64k
how to select decima precision and scale value from table?
Jun 24 2011 2:44 AM
how to select decima precision and scale value from table?
USE
dbname column_name
'Column Name'
,
data_type
'Data Type'
,
CHARacter_maximum_length
'Maximum Length'
,
COLUMNPROPERTY
(
OBJECT_ID
(
Table_Name
),
Column_Name
,
'IsIdentity'
)
as
FieldIdentity
FROM
information_schema.columns
WHERE
table_name
=
tbname
;
with this if the data type is decimal i want that values also ..how to list .
eg:decimal(4,2)
how to select that precision and scale from table
Reply
Answers (
1
)
Sending automated reminder Email from Sql Server
How to add different user with different permission for the Database