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 ...
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
(#换成@)。