你的位置:首页 > 软件开发 > 数据库 > SSMS For Beginner Part 1 to 17

SSMS For Beginner Part 1 to 17

发布时间:2015-09-14 01:00:17
Part 1 Connecting to SQL Server using SSMSnote that,SSMS is a client tool and not the server by itself,it is a developer machines connects t ...

SSMS For Beginner Part 1 to 17

Part 1 Connecting to SQL Server using SSMS

note that,SSMS is a client tool and not the server by itself,it is a developer machines connects to SQL Server.

Part 2 Creating altering and dropping a database

you cannot drop a database , if it is currently in use you will get an error stating. so , if other users are connected, you need to put the database in single user node and then drop the database.system database cannot be dropped.

Part 3 Creating and working with tables

for example:add a foreignkey relation.

table:Student:ID,GenderID;

        Gender:ID,StudentID;

Alter table Student Add Constraint Student_GenderID_FKFOREIGN KEY (GenderID) references Gender (ID)

原标题:SSMS For Beginner Part 1 to 17

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

可能感兴趣文章

我的浏览记录