Tuesday, March 30, 2010

SQL SERVER – 2005 – List All Stored Procedure in Database

Run following simple script on SQL Server 2005 to retrieve all stored procedure in database.

SELECT
*
FROM sys.procedures;

This will ONLY work with SQL Server 2005.



sp_helptext @sp_spname

Wednesday, March 17, 2010

SQL SERVER SELECT ALL TABLES FROM DATABASE

SAL SERVER SELECT QUERY FOR ALL TABLES.


select * from information_schema.tables


THIS QUERY WILL HELP YOU TO SHOW ALL TABLES FROM THE DATABASE.
FOR FIND ANY TABLE YOU CAN SELECT QUERY LIKE THIS


select * from information_schema.tables WHERE TABLE_NAME LIKE
'%_NANE%


FROM THIS QUERY YOU CAN EASILY SEARCH THE TABLE FROM YOUR DATABASE

Monday, March 15, 2010

Zindagi Ke Safar Mein

Zindagi Ke Safar Mein





Mera kuch saamaan tumhare paas pada hai

Mera kuch saamaan tumhare paas pada hai 
o o o ! saavan ke kuch bheege bheege din rakhe hain
aur mere ik khat main lipti raat padi hai
vo raat bhulaa do, mera vo saamaan lauta do -
mera kuch saamaan tumhaare paas pada hai 

patjhad hai kcuh ... hai na ?
o ! patjhas main kuch patton ke girne kee aahat
kaanon main ek baar pahan ke laut aai thee
patajhad kee vo saakh abhi tak kaanp rahi hai
vo saakh gira do, mera vo saamaan lauta do 

ek akeli chhataree main jab aadhe aadhe bheeg rahe the 
aadhe sookhe aadhe geele, sukha to main le aaye thee
geela man shayad bistar ke paas pada ho
vo bhijwa do, mera vo saamaan lauta do

ek so sola chaand ki ratain ek tumhare kaandhe ka til 
geeli mahendi ki khushbu, jhoot mooth ke shikwe kuch
jhooth mooth ke wade sab yaad karaa do
sab bhijwa do, mera vo saamaan lauta do

ek ijaazat de do bas, jab isako dafanaaungee
main bhi vaheen so jaungee
main bhi vaheen so jaungee

Baareeshon Kee Paanee Se

Chhoti Si Kahani Se

Chhotee See Kahaanee Se,
Baareeshon Kee Paanee Se
Saaree Waadee Bhar Gayee,
Naa Jaane Kyo, Dil Bhar Gayaa,
Naa Jaane Kyo, Aankh Bhar Gayee

Shaakho Pe Patte The,patton Pe Boonde Thee
Boondo Mein Paanee Thaa,paanee Mein Aansoo The

Dil Mein Geele Bhee The,pahale Mile Bhee The
Milake Paraaye The,do Humasaaye The










Sunday, March 07, 2010

VB.Net Operators ( And / OR ....)

VB.Net Operators

Visual Basic comes with many built-in operators that allow us to manipulate data. An operator performs a function on one or more operands. For example, we add two variables with the "+" addition operator and store the result in a third variable with the "=" assignment operator like this: int x + int y = int z. The two variables (x ,y) are called operands. There are different types of operators in Visual Basic and they are described below in the order of their precedence.

Arithmetic Operators

Arithmetic operators are used to perform arithmetic operations that involve calculation of numeric values. The table below summarizes them:

OperatorUse
^Exponentiation
-Negation (used to reverse the sign of the given value, exp -intValue)
*Multiplication
/Division
\Integer Division
ModModulus Arithmetic
+Addition
-Subtraction

Concatenation Operators

Concatenation operators join multiple strings into a single string. There are two concatenation operators, + and & as summarized below:

OperatorUse
+String Concatenation
&String Concatenation

Comparison Operators

A comparison operator compares operands and returns a logical value based on whether the comparison is true or not. The table below summarizes them:

OperatorUse
= Equality
<>Inequality
<Less than
>Greater than
>=Greater than or equal to
<=Less than or equal to

Logical / Bitwise Operators

The logical operators compare Boolean expressions and return a Boolean result. In short, logical operators are expressions which return a true or false result over a conditional expression. The table below summarizes them:

OperatorUse
Not Negation
AndConjunction
AndAlsoConjunction
Or Disjunction
OrElse Disjunction
Xor Disjunction






VB.Net Operators OR / And / Not Equal ....

HTML clipboard= Tests whether two values are equal.

<> Tests whether two values are not equal.

< Tests whether the first value is less than the second value.

> Tests whether the first value is greater than the second value.

<= Tests whether the first value is less than or equal to the second value.

>= Tests whether the first value is greater than or equal to the second value.
Daniel Powter's BAD DAY
Song: Bad Day...
by
Daniel