تبلیغات
یادداشتهای علی سالخورده حقیقی - How to get all MSSQL database columns names, data types and length
 
یادداشتهای علی سالخورده حقیقی
We Provide Solutions for The Future Developement.
درباره وبلاگ


دریافت لوح تقدیر از سازمان ملل به عنوان مشاور فناوری اطلاعات سازمان در انتخابات برون مرزی سال 2004.

مدیر وبلاگ : علی سالخورده
نویسندگان
نظرسنجی
از کدامیک از آنتی ویروس های زیر استفاده میکنید و راضی هستید؟








آمار وبلاگ
  • کل بازدید :
  • بازدید امروز :
  • بازدید دیروز :
  • بازدید این ماه :
  • بازدید ماه قبل :
  • تعداد نویسندگان :
  • تعداد کل پست ها :
  • آخرین بازدید :
  • آخرین بروز رسانی :

Some times we need to know all database columns names and data types and length for any activity, without this script you must check each database table for its columns names, data types and length but with this simple script you will able to get all these data with the minimum effort :)

SELECT SysObjects.[Name] as TableName,
SysColumns.[Name] as ColumnName,
SysTypes.[Name] AS [Name],
SysColumns.[Length] AS [Length]
FROM
SysObjects INNER JOIN SysColumns
ON SysObjects.[Id] = SysColumns.[Id]
INNER JOIN SysTypes
ON SysTypes.[xtype] = SysColumns.[xtype]
WHERE SysObjects.[type] = 'U'
AND SysTypes.[Name] <> 'sysname'
ORDER BY SysObjects.[Name]







نوع مطلب : پایگاه داده SQL، نکته ها و ترفندها، 
برچسب ها :
لینک های مرتبط :

       نظرات
1389/09/19
علی سالخورده
1397/02/28 09:47
fantastic issues altogether, you just won a logo new reader.
What might you suggest about your submit that you just made some
days ago? Any sure?
1397/02/26 09:02
Thanks in support of sharing such a pleasant idea, piece of
writing is nice, thats why i have read it entirely
1397/02/26 06:00
Marvelous, what a web site it is! This web site presents valuable
facts to us, keep it up.
1397/02/25 07:25
What's up, yes this post is actually good and I have learned lot of things from it
about blogging. thanks.
1397/02/7 15:58
Hey there! Do you know if they make any plugins to help with Search Engine Optimization? I'm trying to get my
blog to rank for some targeted keywords but I'm not seeing
very good results. If you know of any please share.
Many thanks!
1397/02/3 13:08
Hey very nice blog!
1397/02/3 07:32
Hmm it appears like your website ate my first comment (it was super long) so I guess I'll just sum
it up what I submitted and say, I'm thoroughly enjoying your blog.

I as well am an aspiring blog writer but I'm still new to the whole thing.
Do you have any recommendations for beginner blog writers? I'd definitely
appreciate it.
1397/02/3 07:32
Hmm it appears like your website ate my first comment (it was super long) so I guess I'll just sum
it up what I submitted and say, I'm thoroughly enjoying your blog.

I as well am an aspiring blog writer but I'm still new to the whole thing.
Do you have any recommendations for beginner blog writers? I'd definitely
appreciate it.
1397/02/3 03:08
Awesome blog! Do you have any tips and hints
for aspiring writers? I'm hoping to start my own blog soon but I'm a
little lost on everything. Would you suggest starting with a free platform like Wordpress
or go for a paid option? There are so many choices out there that I'm completely overwhelmed ..
Any tips? Appreciate it!
1397/02/3 02:30
Hi there, I read your new stuff on a regular basis. Your writing style is witty, keep it up!
1397/02/2 21:07
I love your blog.. very nice colors & theme. Did you make this website yourself or
did you hire someone to do it for you? Plz respond as I'm looking to design my own blog and
would like to find out where u got this from. cheers
1396/11/14 20:53
ممنون مطلب خوبی بود
1396/10/7 16:40
http://tubitv.wikidot.com
1396/06/26 20:14
This is really fascinating, You are an overly professional blogger.

I have joined your rss feed and look ahead to in search of more of your wonderful post.
Also, I've shared your site in my social networks
1396/06/16 06:38
Hi to every single one, it's in fact a pleasant for me to visit this site, it includes helpful Information.
1396/05/15 15:29
Hello There. I found your blog using msn. This is a very smartly written article.
I will make sure to bookmark it and come back to
learn more of your useful information. Thanks for the post.

I will definitely return.
1396/05/15 01:42
Excellent blog! Do you have any tips for aspiring writers?
I'm planning to start my own site soon but I'm a little lost on everything.
Would you recommend starting with a free platform
like Wordpress or go for a paid option? There are so
many choices out there that I'm completely overwhelmed ..
Any recommendations? Thanks!
1396/05/8 07:35
My family always say that I am killing my time here at web, except I
know I am getting experience daily by reading such pleasant posts.
1396/05/7 01:19
Every weekend i used to go to see this site, for the reason that i wish for enjoyment, since this this website
conations genuinely nice funny information too.
1396/04/31 16:09
When someone writes an piece of writing he/she keeps the plan of a user in his/her
mind that how a user can be aware of it. So that's why this post is great.
Thanks!
1396/04/11 11:30
First off I would like to say terrific blog! I had a quick
question that I'd like to ask if you do not mind. I was curious to find out how you center yourself and clear your thoughts prior to writing.

I have had difficulty clearing my thoughts in getting my
thoughts out. I do enjoy writing however it just seems like the first 10 to 15 minutes are wasted simply just trying to
figure out how to begin. Any recommendations or hints?

Thank you!
1396/02/13 13:53
Excellent blog! Do you have any recommendations for aspiring writers?
I'm hoping to start my own blog soon but I'm a little lost on everything.
Would you propose starting with a free platform like Wordpress or go for a paid option? There are so many choices out there that I'm completely confused ..

Any ideas? Thanks a lot!
1396/02/13 08:10
Everything is very open with a precise clarification of the challenges.
It was truly informative. Your site is extremely helpful.
Thank you for sharing!
1396/01/25 05:20
Hi to every body, it's my first visit of this website; this website consists of remarkable and
genuinely good material in support of readers.
1396/01/23 11:59
Because the admin of this web page is working, no uncertainty very quickly it will be renowned, due to its quality contents.
1396/01/16 09:53
Good day I am so thrilled I found your weblog, I really
found you by accident, while I was researching on Google
for something else, Anyways I am here now and would just like to say thank you for a tremendous
post and a all round entertaining blog (I also love the theme/design),
I don’t have time to go through it all at the moment but I have book-marked it
and also added in your RSS feeds, so when I have time I will
be back to read a lot more, Please do keep up the excellent jo.
1390/10/15 16:06
سلام
من آرمینم
مطالبتون خیلی قشنگ بود
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر