Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 help

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-14 : 08:48:49
sudhakar.N writes "Hi,


how to work in MS SQL 2005 server?

how to create database?
how to insert values,?
how to execute the result?

i need the guide to work in MS SQL 2005 server ,it is new one to me.

kindly help me to improve my knowledge in MS SQL 2005 server.

Thanks & Regards,
N.Sudhakar"

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-14 : 08:58:16
>>how to create database?
create database mydatabase

how to insert values,?
create table x (i int, s varchar(10))
go
insert x (i,s) select 1, 'hello'
insert x (i,s) select 2, 'goodbye'

how to execute the result?
????
what do you mean?
maybe
select * from x


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-14 : 09:05:22
Also refer these
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -