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

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

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

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:

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

Concatenation Operators

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

Operator	Use
+	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:

Operator	Use
=	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:

Operator	Use
Not	Negation
And	Conjunction
AndAlso	Conjunction
Or	Disjunction
OrElse	Disjunction
Xor	Disjunction

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

= 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

SQL SERVER Replace Query

SQL SERVER Replace Query/

Using REPLACE in an UPDATE statement

SELECT Replace('SQLTeam.com Rocks!', 'Rocks', 'Rolls')

Combining JavaScript with ASP.NET

A powerful combination

JavaScript is the de facto standard for client-side Web development. Combining it with ASP.NET Web forms provides the developer with a powerful set of tools for building robust applications that consider performance a key ingredient.

Private btnSearch_Click (sender As Object, e As System.EventArgs)

Response.Write("Search")

<>

End Sub


Private Page_Load(sender As Object, e As System.EventArgs)

btnSubmit.Attributes.Add("onClick", "return valSubmit();")

End Sub



-------------------------------------------

SQL SERVER SELECT IS NOT NULL

SQL SERVER SELECT IS NOT NULL

ID name salary start_date city region
------ ---------- ----------- ----------------------- ---------- ------
1 Jason 40420 1994-02-01 00:00:00.000 New York W
2 Robert 14420 1995-01-02 00:00:00.000 Vancouver N
3 Celia 24020 1996-12-03 00:00:00.000 Toronto W
4 Linda 40620 1997-11-04 00:00:00.000 New York N
5 null 80026 1998-10-05 00:00:00.000 Vancouver W
6 null 70060 1999-09-06 00:00:00.000 Toronto N
7 null 90620 2000-08-07 00:00:00.000 New York W
8 Chris 26020 2001-07-08 00:00:00.000 Vancouver N
9 Mary 60020 2002-06-09 00:00:00.000 Toronto W

1>
2> SELECT City, Region, COUNT(*) 'Employees'
3> FROM Employee
4> WHERE Name IS NOT NULL

ID name salary start_date city region
----------- ---------- ----------- ----------------------- ---------- ------
1 Jason 40420 1994-02-01 00:00:00.000 New York W
2 Robert 14420 1995-01-02 00:00:00.000 Vancouver N
3 Celia 24020 1996-12-03 00:00:00.000 Toronto W
4 Linda 40620 1997-11-04 00:00:00.000 New York N
5 David 80026 1998-10-05 00:00:00.000 Vancouver W
6 James 70060 1999-09-06 00:00:00.000 Toronto N
7 Alison 90620 2000-08-07 00:00:00.000 New York W
8 Chris 26020 2001-07-08 00:00:00.000 Vancouver N
9 Mary 60020 2002-06-09 00:00:00.000 Toronto W