|
Home > Archive > MS SQL Server MSEQ > August 2005 > Starting SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| HI,
How do you start in SQL What do u type in first at the top of the SQL Query
analyzer
Thanks
tye
| |
| Hari Prasad 2005-07-30, 9:23 am |
| Hi,
How do you start in SQL? Did you meant to start sql server service
Go to Control Panel -- Administartive tools -- Services -- Select MSSQL
Server -- mouse right click and start.
What do u type in first at the top of the SQL Query analyzer?
You can execute any TSQL command which includes DDL, DML , Permission
commands, Admin commands ...)
Eg:-
Create table, Create View, Create Index, Create procedure ,....
INSERT , UPDATE, DELETE
SELECT
GRANT
BEGIN TRAN, COMMIT TRAN, ROLLBACK TRAN
Backup database, Backup Log, Restore database, Restore Log ...
See more information about this commands in SQL Server Books online.
Thanks
Hari
SQL Server MVP
"TYE" <TYE@discussions.microsoft.com> wrote in message
news:E789F7E3-AE1C-44D9-8C03- 18E4729FA6E9@microso
ft.com...
> HI,
>
> How do you start in SQL What do u type in first at the top of the SQL
> Query
> analyzer
>
>
> Thanks
> tye
| |
| priya.H.Gupta@lntinfotech.com 2005-08-01, 3:25 am |
| Database name on whcih you want to perform the operations.
use <database name>
"Hari Prasad" ने लिखा:
> Hi,
>
> How do you start in SQL? Did you meant to start sql server service
>
> Go to Control Panel -- Administartive tools -- Services -- Select MSSQL
> Server -- mouse right click and start.
>
> What do u type in first at the top of the SQL Query analyzer?
>
> You can execute any TSQL command which includes DDL, DML , Permission
> commands, Admin commands ...)
>
> Eg:-
>
> Create table, Create View, Create Index, Create procedure ,....
>
> INSERT , UPDATE, DELETE
>
> SELECT
>
> GRANT
>
> BEGIN TRAN, COMMIT TRAN, ROLLBACK TRAN
>
> Backup database, Backup Log, Restore database, Restore Log ...
>
> See more information about this commands in SQL Server Books online.
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
> "TYE" <TYE@discussions.microsoft.com> wrote in message
> news:E789F7E3-AE1C-44D9-8C03- 18E4729FA6E9@microso
ft.com...
>
>
>
|
|
|
|
|