Select trigger,procedure,view,table etc... in MS SQL

1.Trigger:
SELECT name FROM sysobjects WHERE xtype='TR'
2.Procedure:
SELECT Name FROM sysobjects WHERE xtype='P'
3.Table:
SELECT Name FROM sysobjects WHERE xtype='U'
4.View:
SELECT Name FROM sysobjects WHERE xtype='V'
5.Foreign Key:
SELECT Name FROM sysobjects WHERE xtype='F'
6.Primary Key:
SELECT Name FROM sysobjects WHERE xtype='PK'
7.Function:
SELECT Name FROM sysobjects WHERE xtype='FN'

N.B.: see the following..............................................
C: Check constraint
D: Default constraint
F: Foreign Key constraint
L: Log
P: Stored procedure
PK: Primary Key constraint
RF: Replication Filter stored procedure
S: System table
TR: Trigger
U: User table
UQ: Unique constraint
V: View
X: Extended stored procedure

Case sensitive filtering in SQL server

For case sensitive:
put COLLATE SQL_Latin1_General_CP1_CS_AS after filer........
For Case incensitive:
put COLLATE SQL_Latin1_General_CP1_CI_AS after filer........


Example: select * from tablename where upper(columnNmae1)!=columnNmae1 COLLATE SQL_Latin1_General_CP1_CS_AS

Alert box with line breaks

function disp_alert()
{
alert("Hello again! This is how we" + '\n' + "add line breaks to an alert box!");
}