Gettin Table Name using SP name
June 17, 2009 at 4:14 pm | In SQL | Leave a CommentHi all its really fun working on queries.. I have been updating my blog with queries as i learn them.. Today i was in need of a query to find the tables from the sp name. Atlast i got it. Here it is… The first one list the tables and stored procedures linked withthe sp name we give. The later one lists the table name alone.
Query 1:
select name from sysobjects
where id in (select sd.depid from sysobjects so, sysdepends sd
where so.name = ‘InsertWorkflowCompany’ and
sd.id = so.id )
Query 2:
select name from sysobjects
where id in (select sd.depid from sysobjects so, sysdepends sd
where so.name = ‘InsertWorkflowCompany’ and
sd.id = so.id) and type =’U‘
In the second query type = ‘p’ can be used to list the stored procedures linked.
Happy Querying !!
Cheers !!
To Get SP Details
May 22, 2009 at 7:30 pm | In SQL | Leave a CommentHi
These are the 2 queries to get the Sored Procedure details related to a Particular Database and Particular Table.
use db name
Select * From sys.sysobjects where type=’p’
SELECT * from sys.sysobjects so
inner join sys.syscomments sc
on so.id=sc.id
where type=’p’ and sc.text like ‘%TableName%’
where p stands for the sproc.
My Thoughts
March 12, 2009 at 4:10 pm | In Self Expressions | 1 CommentHey m surprised !!!! B4 my excitement subsides
i wanted to write this blog..
As usual i was vetti without work, n suddenly some
thoughts came to my mind and before they overflow
i decided to put them here 
…
Lonely Night !
A night lonely spent ,
knowing theres a pent
yet undergoing torment,
a night i lonely spent.
Hard Experience
There is no word as such as hard experience; everything thats
experienced should have been hard. Either u wud have
had hard time b4 experienceing or faced hard effects of
it..
Do put in ur comments !!!
Have a great Day!!!!
In-Built Game in Open Office
January 22, 2009 at 6:00 pm | In General | Leave a CommentTags: Calc game, Game, Open Office Calc, Open Office Calc game, shooting, shooting game
Hi All,
As i was looking out for developing some games with openoffiice calc, I jus found this.
Type this in Open Office calc: Good Shooting game gets opened.
Motivating Lines…
December 4, 2008 at 3:47 pm | In Uncategorized | 1 CommentThe essence of Gita is summarized below:
1. Why do you worry? Who are you afraid of? Whatever has happened has happened for the good. What is happening is also happening for the good. Whatever will happen, will be for good also. Do not repent over the past, or worry for the future. Do your duty selflessly—and to the best of your abilities—in the present only.
2. What have you lost for which you cry? You did not bring anything to this world when you were born. You are unnecessarily attached to your possessions. This attachment is the root cause of all your sufferings. Treat all your possessions as a trust property given to you by the God. Let the thoughts of ‘I’ and ‘my’ be completely wiped of your mind. Practice detached attachment. Always remember the creator, and surrender to the will of the Lord.
3. Why worry about the unavoidable death? Change is the law of nature. Atmaa (Spirit) is the abode of body, and the body is an abode for the individual soul (Jeev). This physical body was not here in the past, nor will it remain here for ever. But, the Atmaa is immortal. It neither takes birth nor dies. Atmaa only changes its bodies as you change your garments.
Useful Links
June 12, 2008 at 2:04 pm | In .net | Leave a CommentTags: .net questions, interview questions, links, usseful links, websites
Hi All !
Here i have listed few links which i felt worth sharing 
http://www.techinterviews.com/?p=249
http://www.toqc.com/entropy/TheAnswers1.html
http://nazish.blog.com/1004695/
http://www.codeproject.com/KB/miscctrl/tips.aspx#tip1.1
Our Smart Traffic Police Dept
June 3, 2008 at 6:55 pm | In General | Leave a CommentTags: directions, maps, routes, traffic
ITS REALLY GREAT
A new web portal to get live information on traffic status, directions and auto fares for cities Bangalore, Hyderabad and Chennai. The traffic police have launched a live traffic portal (Transport Information System) where you can find
1. Optimal routes between any two places in the city…
2. Auto-fares
3. Bus routes and stops, etc.
Check ->
http://www.dtis.in/ for Delhi
http://www.chennaitraffic.in/ for Chennai
http://www.btis.in/directions.htm for Bangalore
http://www.htis.in/directions.htm for Hyderabad
http://www.ptis.in/ for Pune
Inserting Multiple Rows using single SQL statement !!!
February 25, 2008 at 9:12 pm | In SQL | 4 CommentsTags: Single Insert Statement, SQL Insert Query
I was surprised when i came to know that there is single SQL statement available to insert more than one row at a time. So i decided to write a post on this , inorder to share it with others.
How we generally do :
INSERT INTO TableName(Id,Name)
VALUES (1,'Name1')
INSERT INTO TableName(Id,Name)
VALUES (2,'Name2')
The other way is
INSERT INTO TableName(Id,Name)
SELECT 1,'Name1'
UNION ALL
SELECT 2,'Name2'
UNION ALL
SELECT 3,'Name3'
Cool!!!! Isnt It?????
ANYWAY !!!
December 28, 2007 at 6:25 pm | In Inspiring | 1 CommentTags: Anyway Poem
Anyway
People are often unreasonable, illogical and self centered;
Forgive them anyway.If you are kind, people may accuse you of selfish, ulterior motives;
Be kind anyway.If you are successful, you will win some false friends and some true enemies;
Succeed anyway.If you are honest and frank, people may cheat you;
Be honest and frank anyway.What you spend years building, someone could destroy overnight;
Build anyway.If you find serenity and happiness, they may be jealous;
Be happy anyway.The good you do today, people will often forget tomorrow;
Do good anyway.Give the world the best you have, and it may never be enough;
Give the world the best you’ve got anyway.You see, in the final analysis, it is between you and your God;
It was never between you and them anyway.- Mother Theresa
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
