System Object
-
Hello Sql,
The system objects, memeber, ect.. in the database, is that something that i should begin to focus on, (as a newbie) is that something that is for more developed database developers.
The reason that i am asking is because i was reading a post in a fourm and a MS Team memeber answerd a ADO.NET question by posting a sample code for adding a column to an existing table, via querry,, and in his querry he referenced the systemObjects...
==================================
select sc.name
from syscolumns sc, sysobjects so
where sc.id = so.id
and so.name = 'tablename'
and sc.name = 'columnname'
This way it will return either 1 row (the column exists) or 0 rows (the
column doesn't exist).
==========================
I AM not familuar with referencing the system objects in the database, (other than the ones that i have created)
Erik...
Dam again!
-
Erik - I don't think you need to focus too much on it right now...usually (eg
if you're creating a table and you're not sure if a table by the same name exists already or not...you would first check the sysobjects to make sure...if you're creating objects directly in the database (which is usually the case) then you don't need to look at this table just yet.....just my opinion -
**ASCII stupid question, get a stupid ANSI !!!** -
Just one of those questions that i needed to know,DIDN'T WANT TO BE LEFT OUT, you know...
Dam again!
-
Erik - something I've been meaning to tell you - there was once a post called "My favourite SSCer"...and who one would vote for if they had to pick a favourite...
you have my vote for the "sheer enthusiasm & good humour" category...
**ASCII stupid question, get a stupid ANSI !!!** -
Knowing your background I'd just say, stay as far away as possible for now... You have way too much to learn before going into administration.
-
That is exactly what i wanted to make sure of. That it is not necessery to be poking around in that area.
Learning process is at a steady pase now, and i do focus alot more in the vb.net department; however, i am a over achiever and i can see myself neck deep in sql 5 years from now.
Thankfully for this fourm or i would not be as far as i am, at least here i am still getting solid answers,, Programmers seem to be more aggressive in the quick to judge department, and less patient,, I am under the impression that most of the fourms or for hard core programmers, and not to much on newbies. The way i look at it is, if a programmer is really that good, why would they go to a fourm, and why have a fourm if your not going to help someone (...with in reason, i do understand this...) And when i say help,, help to me is a url with someones how to, the is by far enough help in my book(Also that the url given to me was given to me by someone who knows that the url that they are given out is valueable and not missleading). Anyway, i am approching 8 months in the programming world and just now starting to make things happen. If it was not for the fourms i am positive that what i know now would have taken well over a year. Just like the last one i asked about the system object,, that one has been bugging me for a while,, and i just had to break down and get a solid answer.
Thanks!
Erik..
Dam again!
-
Erik, I once had a Professor who told me that trying to know everything about programming or a programming language is impossible! The trick to being considered a good programmer is knowing how and where to get answers to your questions!
And this site does rank at the top for almost any programmatic question (especially SQL)!
And sushila is right - you are a very considerate and enthusiastic poster - keep in touch with us as you grow in your knowledge!!!
Good luck,
Darrell
-
I will admit when i first started this venture i way underestimated developing web applications. I never knew that it is concederd software.I was one of those people that was, Just so call going to do it,, yea right... what a joke..
One of the first signs to me that i was in way over my head when i first started was when i bought a combo pack of cd's from cbtnuggets.. I am not sure if ya;'ll know them or not but they have classes on cd. Anyway, i put the cd in the cd drive and proceeded to watch my first lesson, before i clicked on the first video (when the cd fires up it displays different parts of lessons to watch, just click one on the LEFT hand side and the video will start) Before i started i noticed a little video on the RIGHT hand side, and this had the caption of "Meet the teacher" ,,Or something to that extent. So i clicked on the video and this man was explaning how he got started in the programming business and went on about when he was a kid he was programming and so on, bla, bla.. So at this time i was aware that this man had many many years of programming knowledge,, and at the same time i noticed (When the video was playing of him they had the camera focused on him in a way that taped him at his desk,, WITH a bookshelf behind him) a bookself behind him with a about 300 or more books,, so i started to add all of this up,,, OK if this guy has been programming (supposely since birth :tongue
and he has 300 or more books at arms reach ( i am assuming for reference),, what I THE H_ _ do i think i am doing... At that point, I knew i was in trouble.. So i have been 7 days a week for almost 8 months. And am now finally to the point that i can make a little since out of this...Like you said asking the right question at the right place to the right person at the right time.
Erik..
Dam again!
-
You can be too proud or too ignorant to ask questions in a forum, but you can never be too good to ask questions. Even if you end up posting more answers than questions, you will always have questions. Our industry is constantly changing and therefore there is a constant supply of new problems we have to solve.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
I completly understand. I have been in the building industry for 20 years (next year will make 20) and every day is a new journey. The consumer, as a whole, when talking to me about the services that i offer, exspect me to know all of the answers, and i conceder myself to be one of the most well rounded in my industry.And the fact of the matter is that every project that i work, i always have to get a referece, eaither from my collection, or ask someone that is at least as knowledgeable as i am in the industry.
And from what i can see about programming the more i learn, the more that i realize that i do know. So i have learned to focus on what i need at that time. Exspecially, since vb.net has like some odd 1000's of classes..
So i hope that i did not offend you.
Erik...
Dam again!
-
As far as I remember, the first .net add something like 70k methods/functions. You'll never learn 'em all
. -
IIR ??????
If I could only recognize all the acronyms you use remi I'll be content and not fuss about not knowing all/any of - the .net classes!
If I recall ????
Immediate Impulse Response ????
Guess with the number of words you type per minute you can use all the help you can get with brevity, NSP ?!?!
**ASCII stupid question, get a stupid ANSI !!!** -
Better now?
Which version of NSP are you reffering to?
-
Better now?.........huh ?!?! why should it/I be ?!?!
Which version of NSP are you reffering to?..............LOL...that is SO funny!
I was referring to the n'est-ce-pas version....it was in allcaps because I was getting frustrated with trying to figure out what your acronyms expanded to...
**ASCII stupid question, get a stupid ANSI !!!** -
Corrected the main post...
Also I never used NSP, in any language and there was like 50 possible meaning.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply