You are browsing the archive for Books & Literature.

Discover the power of Microsoft SQL Server with sql server business intelligence

January 13, 2012 in Books & Literature, Education

SQL 2005 or 2008, how do you configure security to allow a user to SELECT data from a table but not view the table definition? I tried GRANT SELECT on both the table and schema, but that also allows viewing table definition. Executing REVOKE VIEW DEFINITION on either the table or the schema does not do it. Below are most usable functions while using SQL.

sql select

A database stores data in table (fields and rows). You can communicate with database using SQL and in order to retrieve data (rows) from one or more tables and one or more fields you can use SQL Select statement. A common requirement when working with data, irrespective of its source is to be able to add additional columns to the result set ‘on the fly’. this is pretty straightforward if you simply want a new, blank column, just define it directly in the query using the space() function.

sql select statement and sql select statement syntax

The select statement is used in SQL to specify what data you would like returned when querying the MySQL database. An asterisks [*] will return all data, or you can choose specific data. The SQL SELECT statement queries data from tables in the database. The statement begins with the SELECT keyword. The basic SELECT statement has 3 clauses.

SQL Update Statement and SQL Update Syntax

SQL Update is used to update one table columns with specified values. You can update one or multiple columns at the same time. SQL Update syntax which should work in most cases but there are more complicated syntaxes. Remember you can only update one table at a time but you can update multiple fields at the same time by separating them using commas.

Alter table add column and alter table modify column

The ALTER TABLE ADD COLUMN command modifies the definition of an existing table and adds new columns. Only the table owner, a DBA, or a user with the ALTER privilege for that table may execute the command. To specify a column definition, provide a column name and a data type or domain. Optionally add multiple columns in a single command, provided the total number of columns in the table after executing the command does not exceed the maximum number of columns permitted in a table.

SQL WHERE and SQL GROUP BY

The part of an SQL SELECT statement that specifies conditions used to determine which rows are in the query results. Clarify condition in where clause. Condition is evaluated to either TRUE or FALSE. So when you retrieve the data SQL will evaluate condition and it will include only rows where condition is TRUE. The GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results by one or more columns.

SQL Update Join and SQL Update

SQL Update the most common task is to specify correct filter (or join) so we update only the rows with values we want to affect. SQL joins are used to query data from two or more tables, based on a relationship between certain columns in the tables.

Check Out also for sql queries interview questions, sql tutorial and sql server interview questions

Thought Process Changed

January 30, 2011 in Books & Literature

Might You Live In Fascinating Instances

As I was reviewing numerous web sites and blogs Could possibly You Live In Fascinating Instances popped into my head. It appears to get a lot more than 1 which means however the preferred concept is the fact that it’s a Chinese curse suggesting the coming instances may possibly not bode effectively for you personally, or in the least there will likely be an alter bringing a particular quantity of strife.

In searching by means of the every day information it’s apparent the concerns becoming made inside the globe appear to become bigger than the structures created to contain them. For instance the globe monetary programs are manipulated towards the stage that no one understands how it’ll all play out, however the excesses will ultimately be compensated for by some if not all of us. The political scenes have morphed into this sort of polarization the prevalent great seems much like the previous garment in a very Macy’s discount basement sale becoming ripped apart by desperate shoppers. The relevance and or efficiency of increased schooling as supplied via the college method at shut to $200, 000 to get a 4 yr pop is critically becoming questioned about dinner and breakfast tables. The atmosphere is deteriorating at a bewildering speed. As 1 youthful lady whom I was possessing dinner using the other evening stated, ” My university graduate buddies are just shifting back again residence to “ride it out.” These are in fact confusing and challenging occasions and but simply because poor information sells, the brighter aspect of your ledger is all but masked.

How does 1 proceed?

I stumbled across “wikiHow” along with the write-up, “How to Believe Like Leonardo Da Vinci.” In it the especially very first level was produced that Da Vinci had an insatiable curiosity. Fantastic minds it really is mentioned possess 1 characteristic in typical: they’re in the state of perpetually asking questions. Or you may possibly say they’re in a very constant state of demanding through the universe answers. That’s they’ve engaged not just their aware thoughts about the duties but their unconscious thoughts also. If you’re inside a state of relative unresourcefulness start by asking strongly or “demanding” a state of peace of thoughts and calmness. Then see if this doesn’t start to occur. Since it does other extra instant solutions can have a very powerful base on which to create. Also the much more extreme one’s want to acquire a constructive path, the additional most likely you’re to attract the synchronicities each good and destructive to manual you along. Your urgency will produce much more action. You could wish to journal this workout and note carefully what occurs for and when.

To become a better thinker, to add more creativity to your life read more at thinking today!

Thought Process

January 30, 2011 in Books & Literature

The Fine Line Between Intuition And Insanity

I was having one of those work really hard type of dreams last night. It seemed like I and a few associates were employed in this organization where we were given more and more to do before we could leave work in the evening. Our little group was also housed in an old two story house with a few bedrooms upstairs and a few downstairs. Maybe only one bathroom. In the dream other people were continuously being moved into the house. It was becoming increasingly overcrowded. I had to go pick up a friend who had come to visit and on the way back to the house was wondering how I was going to put him up. It was frustrating. Then it occurred to me I would give him my bed and I would camp out in the yard. I began to wonder exactly what was going on. Why was this company I worked for giving us so much to do and then why were they moving all of these people in with us, literally to the bursting point? Would we get angry? Or was this a test to see what we would do next? Or was this company losing its own grip and had no idea how to handle anything?

Years ago I had the good fortune of spending a week with Peter Caddy at my house in Hawaii. Peter had been a co-founder of the magical Findhorn Gardens in Scotland. Over a cold Heineken beer I asked him what his trip was. He said that since he had left Eileen his wife, and Co-founder of Findhorn, he had been penniless and was living completely on intuition. I asked him how it was going. He said it was maddening. He was always on the edge. Each moment was huge. In the recent past he had constantly visited psychics to get a check on his reality. He said he frequently couldn’t tell the difference between his imagination and his intuition, and he needed to be more certain. While he had been married to Eileen, he had lived on her intuition and as dicey as it might seem at the time it always worked out. He just trusted in her. And now he was having to trust in himself with little or nothing to fall back on.

My reason for writing about the dream was to say that like my dream many people are now confronting instability they have never witnessed or experienced: job losses, investments going sour, institutions counted upon in the past (like rating agencies such as Moody’s) becoming questionable. How do we respond? Who do we turn to? How do we keep our cool?

I have been writing about how learning to trust our intuition is becoming essential. Technology is stealing time. Institutions we depend upon seem to be crumbling. The environment and climate are changing rapidly. Just being smart doesn’t seem to be good enough. Yet, there also seems to be time, time to learn about out intuition, practice using it for small things, and get feedback. By doing this we will trust the results with more certainty. It will be easier.

So just how do we do this? Psychiatrist, Dr. Kerry Monick, says your intuition is something you literally have, but have no idea how. The information is just there. The trick is to train that capacity. So you set aside time to practice ( like piano or tennis) Note down your results such as getting the parking spot or elevator door opening, or knowing the person calling on the phone before you pick it up. Remember how you feel when you get this right. Then try to retrieve that feeling by practicing more. . By using everyday activities you are more likely to tune in. Date your journal so you can look back and compare. Keep notes in order to follow progress.

If we wait however too long to hone this skill, it may become more dramatic or as Peter referred to it, maddening!

To become a better thinker, to add more creativity to your life read more at Creative today!

Frank Lloyd Wright

January 30, 2011 in Books & Literature

Just How Happy Am I Going To Be?

In the early part of life my pre-occupation was around figuring out “What am I going to do and how is that going to take care of me?” And of course there was the nagging doubt as to whether I could get it together enough to be an entrepreneur. At that time I don’t think happiness ever entered that equation. It was more of an imagined by-product of things going well. Of course the “Pursuit of happiness” was considered so important that it became a guiding principle for the Founding Fathers of America. But who is really going to be happy…?

There is some very good news for virtually everyone. The December 18th Economist ran an article called the U-Bend of Life.It is a graph which matches age on one axis with happiness on the other axis. It goes like this: as people begin adult life they are pretty sanguine then there is the long down hill of happiness until they reach the midlife crisis. But then something surprising happens: people begin to lose vitaility, mental acuity and looks; but they seem to gain what they have been pursuing all their life-happiness. If you ask a group of 30 year olds and a group of 70 year olds to rate their happiness it seems the 70 year olds are the happier bunch. Things seem to get better and better.

Much of this of course can attributed to the fact that the 30 year olds are facing life, testing themselves, seeing if they can accomplish life’s challenges. The 70 year olds are looking back and realizing that whatever they did or did not do it doesn’t matter so much now.

I would like to propose that this paradigm should and can change. It is possible to be happy all the way through no matter what the challenges. But how do you do this?

Ken Dychtwald, gerontologist, in an observation years ago noted that the younger generations saw that the idea of the golden years their parents had so sought did not necessarily deliver. Yes, they might be into acceptance about their stage in life, but the idea that retirement would be an estatic state of perpetual play and joy simply did not occur for many. Just how much golf or fishing or road trips could one take before it got boring? Instead Dychtwald predicted that the younger generation would not stand for lousy working conditions and would go where they were happiest. They would perhaps have seven or eight careers in their life separated by periods of education, travel, and reinvention. This process might simply be a continuous journey until one expired. This indeed has happened to the corporate world as people come and go and the idea of life time employment at one company becomes a thing of the past.

If one pursues the passions of one’s dreams this might straighten out the U-Bend curve to perhaps more of a straight line, which might dip at times in one’s life, but be more of an upward slope as happiness forms a feedback mechanism.I believe we will see more and more of the articles such as Roger Fransecky’s Goal for 2011, Don’t Postpone Your Life.

To become a better thinker, to add more creativity to your life read more at Frank Lloyd Wright today!

James Van Praagh – Psychic, Medium, and Best Selling Author

July 8, 2008 in Arts, Books & Literature, Celeberties, Performing Arts, Religion, Television

James Van Praagh (b. August 23, 1958, Bayside, New York) is a best-selling author, who performs as a psychic and medium. He has written several books dealing with spirituality and spirit communication. From 2002 to 2003, he hosted a syndicated daytime talk show entitled “Beyond With James Van Praagh.” He subsequently partnered with CBS to produce several TV-movies and mini-series based on his books, including “Living With The Dead” and “The Dead Will Tell.” He is currently the co-Executive Producer of the television series Ghost Whisperer on CBS.

Read the rest of this entry →