Stored Procedure

Syntax to create Stored Procedure.

CREATE PROCEDURE
-- Add the parameters for the stored procedure here
<@Param1, sysname, @p1> = ,
<@Param2, sysname, @p2> =
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END


Example :
Suppose there is a table StudentMast Having three fields Roll,Name,Address. I want to make an SP(i.e stored procedure) which will take one parameter and finds records which have name = the parameter.


CREATE PROCEDURE Find_Student_By_Name
@Name Varchar(50) ---This is a parameter
AS

BEGIN
Select *
From StudentMast
Where Name=@Name
END

SQL SERVER 2005 KEY WORDS

ABS
ABS
ACOS
ACTION
ADD
AGGREGATE
ALL
ALTER
AND
ANY
AS
ASC
ASCII
ASIN
ATAN
AUTHORIZATION
AVG
BACKUP
BEGIN
BETWEEN
BIGINT
BINARY
BINDING
BIT
BREAK
BROWSE
BULK
BY
CASCADE
CASE
CAST
CATALOG
CEILING
CHAR
CHARACTER
CHECK
CHECKPOINT
CLOSE
CLUSTERED
COALESCE
COLLATE
COLLECTION
COLUMN
COMMIT
COMPUTE
CONSTRAINT
CONTAINS
CONTAINSTABLE
CONTINUE
CONVERT
COS
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
DATABASE
DATETIME
DAY
DBCC
DEALLOCATE
DECIMAL
DECLARE
DEFAULT
DEGREES
DELETE
DENY
DESC
DISABLE
DISK
DISTINCT
DISTRIBUTED
DOUBLE
DROP
DUMMY
DUMP
ELSE
ENABLE
END
END-EXEC
ERRLVL
ESCAPE
EXCEPT
EXEC
EXECUTE
EXISTS
EXIT
EXP
EXPLICIT
EXTERNAL
FETCH
FILE
FILLFACTOR
FLOAT
FLOOR
FLUSH
FOR
FOREIGN
FREETEXT
FREETEXTTABLE
FROM
FULL
FUNCTION
GET
GO
GOTO
GRANT
GROUP BY
GROUPING
HAVING
HOLDLOCK
IDENTITY
IDENTITYCOL
IF
IN
INCLUDE
INDEX
INNER
INSERT
INT
INTERSECT
INTO
IS
ISOLATION
JOIN
KEY
KILL
LANGUAGE
LEFT
LEVEL
LIKE
LINENO
LOAD
LOG
LOWER
LTRIM
MANUAL
MAX
MESSAGE
MIN
MONEY
MONTH
MOVE
NATIONAL
NCHAR
NO
NOCHECK
NONCLUSTERED
NOT
NULL
NULLIF
NUMERIC
OF
OFF
OFFSETS
ON
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPTION
OR
ORDER
OUTER
OUTPUT
OVER
PATH
PERCENT
PI
PLAN
POWER
PRECISION
PRIMARY
PRINT
PROC
PROCEDURE
PROFILE
PUBLIC
RADIANS
RAISERROR
RAND
RANGE
RAW
READ
READTEXT
REAL
RECONFIGURE
REFERENCES
REPLACE
REPLICATE
REPLICATION
RESTORE
RESTRICT
RETURN
RETURNS
REUSE
REVOKE
RIGHT
ROLE
ROLLBACK
ROWCOUNT
ROWGUIDCOL
RTRIM
RULE
SAVE
SCHEMA
SELECT
SERVICE
SESSION_USER
SET
SETUSER
SIN
SIGN
SHUTDOWN
SETUSER
SIZE
SMALLINT
SOME
SORT
SOUNDEX
SPACE
SQRT
STATISTICS
SUBSTRING
SUM
SYSTEM_USER
SYNONYM
TABLE
TAN
TEXTSIZE
THEN
TIME
TIMESTAMP
TINYINT
TO
TOP
TRAN
TRANSACTION
TRIGGER
TRUNCATE
TSEQUAL
TYPE
UNION
UNIQUE
UNNEST
UPDATE
UPDATETEXT
UPPER
USE
USER
VALUE
VALUES
VARBINARY
VARCHAR
VARYING
VIEW
WAITFOR
WHEN
WHERE
WHILE
WITH
WRITETEXT
YEAR

How to select an item in DropDownList In Asp.net ?

ddl_Vehicle.ClearSelection();
ddl_Vehicle.Items.FindByText("Bus").Selected = true;

Reading XML FIle In Asp.Net

//Here I am giving function to read xml file
public DataTable ReadXmlFile()
{
try
{
ReadXmlFs = new FileStream (

HttpContext.Current.Server.MapPath("~/test.xml"), FileMode.Open);
XmlTextReader rdXml = new XmlTextReader(ReadXmlFs);

ds.ReadXml(rdXml);

ReadXmlFs.Close();
return ds.Tables[0];
}
catch (Exception ex)
{
DataTable dTbl = new DataTable();
return dTbl;
}
}

Exception / Error Handling In Javascript

< script language = "JavaScript" >
try
{
var I = 10;
var J = 0;
var K = I/J;
}
catch ( e )
{
alert("An exception occurred in the script. Error name: " + e.name
+ ". Error message: " + e.message);
}
< / script >