sqlserver2008添加数据

① SQL Server2008 R2濡备綍鏂板缓鏁版嵁搴

SQL Server 2008 R2涓濡备綍鏂板缓鏁版嵁搴撱傚皬缂栫粰澶у跺啓鍑轰袱绉嶆柟寮忥纴甯屾湜鍙浠ュ府鍒板ぇ瀹躲

鏂规硶涓锛 棣栧厛锻锛屾墦寮鎴戜滑镄勬暟鎹搴揝QL Server 2008 R2鎴戜滑鍙浠ョ湅鍒板湪宸﹁竟镄勬爲鐘跺浘涓鎴戜滑鍙浠ョ湅鍒版暟鎹搴撹繖鍑犱釜瀛楋纴铹跺悗锻㈡垜浠鍦ㄦ暟鎹搴撹繖鍑犱釜瀛椾笂闱锛岀敤榧犳爣鍙冲嚮阃夋嫨閲岄溃镄勬柊寤烘暟鎹搴撹繖涓阃夐”

绱ф帴镌寮瑰嚭濡备笅锲句腑镓绀虹殑涓涓鐣岄溃锛屽湪杩欎釜鐣岄溃涓鎴戜滑杩涜屾坊锷犳暟鎹搴撶殑钖嶅瓧鍜屽瓨鏀句綅缃

濡备笅锲句腑镓绀猴纴娣诲姞鏁版嵁搴撶殑钖嶅瓧锛屽苟涓旈夋嫨涓涓嬫暟鎹搴撶殑瀛樻斁浣岖疆

濡备笅锲句腑镓绀猴纴阃夋嫨涓涓鏁版嵁搴撶殑镙圭洰褰曪纴杩涜屽瓨鏀炬柊寤虹殑鏁版嵁搴

阃夋嫨瀹屾瘯涔嫔悗锛屾垜浠镣瑰嚮纭瀹氾纴铹跺悗鍦ㄧ晫闱㈢殑宸︿晶涓灏卞彲浠ョ湅鍒版垜浠鏂板缓镄勬暟鎹搴扑简

鏂规硶浜岋细 鍦ㄦ暟鎹搴撶殑宸︿笂瑙掓垜浠鍙浠ョ湅鍒颁竴涓鏂板缓镆ヨ㈢殑锲炬爣锛岄夋嫨镓揿紑锛屽脊鍑哄备笅镄勭晫闱

杩欓噷鎴戜滑閲囩敤浠ｇ爜涔﹀啓镄勬柟寮忔潵杩涜屾暟鎹搴撶殑娣诲姞锛 鍦ㄤ唬镰佸潡濉鍐欙细 --鍒涘缓涓涓鏁版嵁搴 钖嶅瓧涓猴细School create database School on primary ( --鏁版嵁鏂囦欢镄勫叿浣撴弿杩 name='School_data',             --涓绘暟鎹鏂囦欢镄勫叿浣撴弿杩 filename='E:projectSchool_data.mdf',   --涓绘暟鎹鏂囦欢镄勭墿鐞嗗悕绉 size=5mb,                  --涓绘暟鎹鏂囦欢镄勫埯濮嫔ぇ灏 maxsize=100mb,               --涓绘暟鎹鏂囦欢澧炲ぇ镄勬渶澶у filegrowth=15%               --涓绘暟鎹鏂囦欢镄勫为暱鐜 ) log on ( --镞ュ织鏂囦欢镄勫叿浣撴弿杩帮纴涓鍙傛暟钖涔夊悓涓 name='School_log', filename='E:projectSchool_log.ldf', size=2mb, filegrowth=1mb ) go

濉鍐椤畬姣曚箣钖庨夋嫨 镓ц岋纸鍦ㄦ秷鎭妗嗕腑鍑虹幇锛屽懡浠ゅ凡鎴愬姛瀹屾垚锛

濡傛灉镓ц屽畬姣曚箣钖庢垜浠镄勫乏渚т腑杩樻槸娌℃湁鍑虹幇鎴戜滑镄勬暟鎹搴掳纴杩欓噷鎴戜滑鍙冲嚮阃夋嫨鍒锋柊锛埚备笅锲炬墍绀猴级

杩欐牱鎴戜滑镄勬暟鎹搴揿氨鍙浠ユ樉绀哄嚭𨱒ヤ简

鍦ㄦ墦寮鎴戜滑镄勬枃浠跺瓨鏀剧洰褰曟煡鐪嫔凡缁忓缓绔嫔畬姣旷殑鏁版嵁搴

杩欓噷澶у舵敞镒忎简锛屽湪鏂规硶浜屼腑镄勬暟鎹搴揿瓨鏀句綅缃涓锛屾垜浠蹇呴’瑕佷缭璇佹墍鍐欑殑鏂囦欢澶瑰湪鐩褰曚腑鍙浠ユ垒鍒帮纴涓岖劧浼氩嚭鐜板缓绔嫔け璐ョ殑阌栾鎻愮ず~ 浠ヤ笂鏂瑰纺甯屾湜鍙浠ュ府锷╁埌鍒氩紑濮嬫帴瑙︽暟鎹搴撶殑灏忎紮浼翠滑銆傚枩娆㈢殑鍙浠ュ叧娉ㄦ垜锛屾垜浼氱粰澶у跺垎浜镟村氩叧浜庢暟鎹搴撶殑鍐呭广