تبلیغات
یادداشتهای علی سالخورده حقیقی - 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/03/20 01:31
Thankfulness to my father who informed me on the topic of this website, this web site is in fact awesome.
1397/03/16 14:12
Whʏ people still use to read nsws papers when inn this technological world all is
availɑble on net?
1397/03/13 05:02
Just want to say your article is as surprising. The clarity for your put up is simply excellent and
that i could assume you're knowledgeable on this subject.
Fine with your permission allow me to seize your RSS feed to stay up to date
with drawing close post. Thanks a million and please continue the enjoyable work.
1397/03/13 04:17
I am really pleased to read this website posts which consists of tons of valuable
information, thanks for providing these information.
1397/03/12 17:42
Incredible points. Great arguments. Keep up the amazing spirit.
1397/03/2 06:26
Pretty portion of content. I just stumbled upon your website and in accession capital to say that I acquire actually loved account your blog
posts. Any way I'll be subscribing on your
augment and even I success you get entry to persistently rapidly.
1397/02/31 02:25
My spouse and I stumbled over here coming from a different web address and
thought I might check things out. I like what I see so now
i am following you. Look forward to looking at your web page yet again.
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!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر


نمایش نظرات 1 تا 30