Using semi-colon in SQL statement in SQL server 2000

[Khaled]

Hi everybody...:)
Can any one tell me any information about using semi-colon in SQL statement in SQL server 2000.
Thank you for any help.

[Spudhead]

Well.. what do you want to know about it? It's a semicolon - you use them to seperate SQL statements. Like:

SET NOCOUNT ON; INSERT INTO table(field) VALUES (thing); SELECT field FROM table

[Malith]

hi
when u use semi-colon in SQL statement it is indicate a end of the statement.

cheers

Malith