MSSQL USE

[MsmVc]

Hi All Question move from C/C++/MFC Message Board to here. I have a problem to use syntax of MSSQL.I use this syntax

use databasename

it is not working for me.I check out through this code

SELECT db_name()

then result show MASTER. Can any one give me tips where i wrong to use syntax. Plz help me

[Niladri_Biswas]

If you write

use databasename

it will throw error Msg 207, Level 16, State 1, Line 1 Invalid column name 'databasename'. But if you write

use master

it will say Command(s) completed successfully. :)

Niladri Biswas

[MsmVc]

if i use

use master

And i want to create some table in different database then what i will do?