?处为SQL命令，请问各位大神这些个命令是什么
SQL\u547d\u4ee4\u662f\u4ec0\u4e48\u610f\u601d\u5440\uff1f \u672c\u4eba\u83dc\u9e1f\uff0c\u8bf7\u9ad8\u624b\u5c3d\u91cf\u8bf4\u901a\u4fd7\u70b9\uff0c\u8c22\u8c22\uff01\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00(Structured Query Language)\u7b80\u79f0SQL\uff0c\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\u662f\u4e00\u79cd\u6570\u636e\u5e93\u67e5\u8be2\u548c\u7a0b\u5e8f\u8bbe\u8ba1\u8bed\u8a00\uff0c\u7528\u4e8e\u5b58\u53d6\u6570\u636e\u4ee5\u53ca\u67e5\u8be2\u3001\u66f4\u65b0\u548c\u7ba1\u7406\u5173\u7cfb\u6570\u636e\u5e93\u7cfb\u7edf\uff1b\u540c\u65f6\u4e5f\u662f\u6570\u636e\u5e93\u811a\u672c\u6587\u4ef6\u7684\u6269\u5c55\u540d\u3002\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\u662f\u9ad8\u7ea7\u7684\u975e\u8fc7\u7a0b\u5316\u7f16\u7a0b\u8bed\u8a00\uff0c\u5141\u8bb8\u7528\u6237\u5728\u9ad8\u5c42\u6570\u636e\u7ed3\u6784\u4e0a\u5de5\u4f5c\u3002\u5b83\u4e0d\u8981\u6c42\u7528\u6237\u6307\u5b9a\u5bf9\u6570\u636e\u7684\u5b58\u653e\u65b9\u6cd5\uff0c\u4e5f\u4e0d\u9700\u8981\u7528\u6237\u4e86\u89e3\u5177\u4f53\u7684\u6570\u636e\u5b58\u653e\u65b9\u5f0f\uff0c\u6240\u4ee5\u5177\u6709\u5b8c\u5168\u4e0d\u540c\u5e95\u5c42\u7ed3\u6784\u7684\u4e0d\u540c\u6570\u636e\u5e93\u7cfb\u7edf\u53ef\u4ee5\u4f7f\u7528\u76f8\u540c\u7684\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\u8bed\u8a00\u4f5c\u4e3a\u6570\u636e\u8f93\u5165\u4e0e\u7ba1\u7406\u7684\u63a5\u53e3\u3002\u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00\u8bed\u53e5\u53ef\u4ee5\u5d4c\u5957\uff0c\u8fd9\u4f7f\u4ed6\u5177\u6709\u6781\u5927\u7684\u7075\u6d3b\u6027\u548c\u5f3a\u5927\u7684\u529f\u80fd\u3002
\u4f60\u597d.
\u521a\u5b8c\u6210\u7684\u5168\u5e93\u68c0\u7d22.
\u4f60\u8bd5\u4e0b\u770b\u55bd:
SET nocount ON
DECLARE @sql VARCHAR(max) -- \u8fd9\u91cc\u5199\u4f60\u8981\u67e5\u627e\u7684\u5b57\u7b26\u4e32
,@findtext VARCHAR(max)='abc'
DECLARE cursor1 CURSOR FOR
SELECT 'if( select count(1) from ' + Object_name(id) + ' where ' + name + ' like ''' + @findtext + ''')>0 select ''
select * from ' + Object_name(id) + ' where ' + name + ' like ''''%' + @findtext + '%''''
'''
FROM sys.syscolumns c
WHERE Object_schema_name(id) = 'dbo'
OPEN cursor1
FETCH next FROM cursor1 INTO @sql
WHILE @@FETCH_STATUS = 0 --\u5224\u65ad\u662f\u5426\u6210\u529f\u83b7\u53d6\u6570\u636e BEGIN
EXEC (@sql)
IF( @@ROWCOUNT > 0 ) BEGIN
BREAK
END
FETCH next FROM cursor1 INTO @sql --\u5c06\u6e38\u6807\u5411\u4e0b\u79fb\u884c END
CLOSE cursor1 --\u5173\u95ed\u6e38\u6807DEALLOCATE cursor1
SET nocount OFF
\u5e0c\u671b\u5bf9\u4f60\u6709\u6240\u5e2e\u52a9\u54c8,\u795d\u597d\u8fd0~~
--user不能作为表名
create table user1
(
uid int not null,
name char(5),
sex char(2) default('男')
)
--b
alter table user1
alter column uid char(5);
alter table user1
add constraint PK_uid primary key (uid); --定义主键失败,要先在表中插入一组uid不为null的数据
--c
alter table user1
add brithday datetime default(1992-01-01)
--d
drop column brithday
--e
add brithday datetime
--f
insert from user1(001,'zs','男',1990-01-01)
--就会第一个= =
--g
update user1 set uid = 1xxx
where sex = '男'
--h
delete from user1 where sex = '男'
--3
--a
create table cosum
(
cid char(5),
uid char(5) foreign key references user1(uid),
money int, --实在不知道Y是什么数据类型啊= =
day1 datetime
)--新人求采纳
这些题目后面下一层都加了一个? 就是问你怎么写的意思.
绛旓細--a --user涓嶈兘浣滀负琛ㄥ悕 create table user1 (uid int not null,name char(5),sex char(2) default('鐢'))--b alter table user1 alter column uid char(5);alter table user1 add constraint PK_uid primary key (uid); --瀹氫箟涓婚敭澶辫触,瑕佸厛鍦ㄨ〃涓彃鍏ヤ竴缁剈id涓嶄负null鐨勬暟鎹 --c...
绛旓細1銆佺粺璁℃瘡闂ㄨ绋嬬殑瀛︾敓閫変慨浜烘暟(缁熻10浜轰互涓婄殑璇剧▼)锛岃姹傝緭鍑鸿绋嬪彿銆佽绋嬪悕绉般侀変慨浜烘暟锛屾寜浜烘暟闄嶅簭鎺掑垪锛屽鏋滀汉鏁扮浉鍚岋紝鎸夎绋嬪彿鍗囧簭鎺掑垪 SELECT C.CNO, C.CNAME, COUNT(SC.SNO)FROM C LEFT JOIN SC ON C.CNO = SC.CNO GROUP BY C.CNO,C.CNAME HAVING COUNT(SNO) > 10 ORDER BY COUNT...
绛旓細妫绱㈠嚭鍚戜緵搴斿晢S3鍙戣繃璁㈣喘鍗曠殑鑱屽伐鐨勮亴宸ュ彿鍜屼粨搴撳彿 select 鑱屽伐鍙,浠撳簱鍙 from 渚涘簲鍟嗚〃 where 鍚嶇О='S3'妫绱㈠嚭鍜岃亴宸1銆丒3閮芥湁鑱旂郴鐨勫寳浜殑渚涘簲鍟嗕俊鎭 select * from 渚涘簲鍟嗚〃 where 鑱屽伐鍙='E1' or 鑱屽伐鍙='E3'妫绱㈠嚭鍚慡4渚涘簲鍟嗗彂鍑鸿璐崟鐨勪粨搴撴墍鍦ㄧ殑鍩庡競 select 鍩庡競鍚嶇О from 浠撳簱琛 w...
绛旓細sql="update 鏁版嵁琛 set 瀛楁1=鍊1,瀛楁2=鍊2 鈥︹ 瀛楁n=鍊糿 where 鏉′欢琛ㄨ揪寮"(3) 鍒犻櫎鏁版嵁璁板綍锛歴ql="delete from 鏁版嵁琛 where 鏉′欢琛ㄨ揪寮"sql="delete from 鏁版嵁琛" (灏嗘暟鎹〃鎵鏈夎褰曞垹闄)(4) 娣诲姞鏁版嵁璁板綍锛歴ql="insert into 鏁版嵁琛 (瀛楁1,瀛楁2,瀛楁3 鈥) values (鍊1,鍊2,...
绛旓細1銆 鏌ョ湅鏁版嵁搴撲腑鐨勮〃鎴栨煡璇㈡暟鎹簱锛泂how tables/databases锛2銆 鏌ョ湅鏁版嵁搴撲腑鎵鏈夌殑琛細show tables锛涳紙鍓嶆彁鏄娇鐢╱se database 鏁版嵁搴擄紱锛3銆 鏌ョ湅鏁版嵁琛ㄧ粨鏋 describe 琛ㄥ悕锛4銆 鍒涘缓鏁版嵁搴 CARATE DATABASE 鏁版嵁搴撳悕锛沜reate database studentoa锛5銆 鍒犻櫎鏁版嵁搴 DROP DATABASE 鏁版嵁搴撳悕锛汥rop ...
绛旓細SQL璇彞锛氶氳繃SQL璇彞鍙互瀹屾垚瀵规暟鎹簱銆佽〃銆佹暟鎹殑鎿嶄綔锛屼篃灏鏄鎴戜滑鏈暀绋嬭瀛︿範鐨勪富瑕佸唴瀹广備竴鏉QL璇彞绫讳技杩欐牱锛屽畠鐨勫惈涔夋槸锛氫粠Users琛ㄤ腑鍙栧嚭鍒楀悕涓篣serName鐨勬暟鎹備竴浜涢噸瑕佺殑SQL鍛戒护锛歋ELECT 鈥 浠庢暟鎹簱涓彁鍙栨暟鎹 UPDATE 鈥 鏇存柊鏁版嵁搴撲腑鐨勬暟鎹 DELETE 鈥 浠庢暟鎹簱涓垹闄ゆ暟鎹 INSERT INTO 鈥 鍚...
绛旓細缁撴瀯鍖栨煡璇㈣瑷(Structured Query Language)绠绉SQL锛岀粨鏋勫寲鏌ヨ璇█鏄涓绉嶆暟鎹簱鏌ヨ鍜岀▼搴忚璁¤瑷锛岀敤浜庡瓨鍙栨暟鎹互鍙婃煡璇佹洿鏂板拰绠＄悊鍏崇郴鏁版嵁搴撶郴缁燂紱鍚屾椂涔熸槸鏁版嵁搴撹剼鏈枃浠剁殑鎵╁睍鍚嶃傜粨鏋勫寲鏌ヨ璇█鏄珮绾х殑闈炶繃绋嬪寲缂栫▼璇█锛屽厑璁哥敤鎴峰湪楂樺眰鏁版嵁缁撴瀯涓婂伐浣溿傚畠涓嶈姹傜敤鎴锋寚瀹氬鏁版嵁鐨勫瓨鏀炬柟娉曪紝涔熶笉闇瑕...
绛旓細--SQL鍩烘湰鍛戒护 --鏁版嵁瀹氫箟璇█ Create(鍒涘缓)Alter(鏇存敼)Drop(鍒犻櫎)--鏁版嵁鎿嶇旱璇█ Insert(鎻掑叆)select(閫夋嫨)delete(鍒犻櫎)update(鏇存柊)--浜嬪姟鎺у埗璇█ commit(鎻愪氦)savepoint(淇濆瓨鐐)rollback(鍥炴粴)--鏁版嵁鎺у埗璇█ Grant(鎺堟潈)Revoke(鍥炴敹)--Orcale鏁版嵁绫诲瀷 --瀛楃鏁版嵁绫诲瀷 char杩欑鏁版嵁绫诲瀷鐨勫垪闀垮害鍙互...
绛旓細鐢鍛戒护鍒涘缓涓婚敭涓庡閿柟娉曞涓嬶細--鐢ㄥ懡浠ゅ垱寤轰富閿笌澶栭敭.--浣跨敤SQL璇彞鍒涘缓涓婚敭绾︽潫鍙互鍦ㄥ垱寤鸿〃锛圕reateTable锛夋垨淇敼琛紙AlterTable锛夋椂杩涜 鍒涘缓銆--渚嬪垱寤鸿〃鏃 createtabletablename (idint(CONSTRAINTpk_id)PRIMARYKEY )--渚嬩慨鏀硅〃鏃 ALTERTABLEtablename --淇敼琛 ADD CONSTRAINTtb_PRIMARY PRIMAR...
绛旓細--SQL鍛戒护 --鈥滃鐢熲濇暟鎹簱涓湁 鈥滃鐢熻〃鈥濄佲滆绋嬭〃鈥濆拰 鈥滄垚缁╄〃鈥濄--鈥滃鐢熻〃鈥濅腑鍖呭惈瀛﹀彿銆佸鍚嶃佹у埆銆佷笓涓氬拰鐝骇浜斾釜瀛楁銆--鈥滆绋嬭〃鈥濅腑鍖呭惈鏈夎绋嬬紪鍙枫佽绋嬪悕鍜屼换璇炬暀甯堜笁涓瓧娈碉紝鈥滄垚缁╄〃鈥濅腑鍖呭惈鏈夊鍙枫佽绋嬬紪鍙峰拰鎴愮哗涓変釜瀛楁銆侰REATE TABLE 瀛︾敓琛 (瀛﹀彿 CHAR(8) PRIMARY ...
