Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SqlserverÓï¾ä´óÈ«

 --Óï ¾ä¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹¦ ÄÜ 
--Êý¾Ý²Ù×÷ 
SELECT¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁР
INSERT¡¡¡¡¡¡--ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐР
DELETE¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐР
UPDATE¡¡¡¡¡¡--¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý 
--Êý¾Ý¶¨Òå 
CREATE TABLE¡¡¡¡--´´½¨Ò»¸öÊý¾Ý¿â±í 
DROP TABLE¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ý±í 
ALTER TABLE¡¡¡¡ --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹ 
CREATE VIEW¡¡¡¡ --´´½¨Ò»¸öÊÓͼ      
DROP VIEW¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ýÊÓͼ  
CREATE INDEX¡¡¡¡--ΪÊý¾Ý¿â±í´´½¨Ò»¸öË÷Òý  
DROP INDEX¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ýË÷Òý  
CREATE PROCEDURE¡¡ --´´½¨Ò»¸ö´æ´¢¹ý³Ì  
DROP PROCEDURE¡¡¡¡--´ÓÊý¾Ý¿âÖÐɾ³ý´æ´¢¹ý³Ì  
CREATE TRIGGER¡¡¡¡--´´½¨Ò»¸ö´¥·¢Æ÷    
DROP TRIGGER¡¡¡¡--´ÓÊý¾Ý¿âÖÐɾ³ý´¥·¢Æ÷  
CREATE SCHEMA¡¡¡¡--ÏòÊý¾Ý¿âÌí¼ÓÒ»¸öÐÂģʽ  
DROP SCHEMA¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸öģʽ  
CREATE DOMAIN¡¡¡¡--´´½¨Ò»¸öÊý¾ÝÖµÓò 
ALTER DOMAIN¡¡¡¡--¸Ä±äÓò¶¨Òå  
DROP DOMAIN¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ýÒ»¸öÓò 
--Êý¾Ý¿ØÖÆ 
GRANT¡¡¡¡¡¡--ÊÚÓèÓû§·ÃÎÊȨÏÞ 
DENY¡¡¡¡¡¡--¾Ü¾øÓû§·ÃÎÊ  
REVOKE¡¡¡¡¡¡--½â³ýÓû§·ÃÎÊȨÏÞ  
--ÊÂÎñ¿ØÖÆ 
COMMIT¡¡¡¡¡¡--½áÊøµ±Ç°ÊÂÎñ  
ROLLBACK¡¡¡¡ --ÖÐÖ¹µ±Ç°ÊÂÎñ  
SET TRANSACTION¡¡¡¡--¶¨Ò嵱ǰÊÂÎñÊý¾Ý·ÃÎÊÌØÕ÷  
--³ÌÐò»¯SQL 
DECLARE¡¡¡¡¡¡--Ϊ²éѯÉ趨Óαꠠ
EXPLAN¡¡¡¡¡¡--Ϊ²éѯÃèÊöÊý¾Ý·ÃÎʼƻ® 
OPEN¡¡¡¡¡¡--¼ìË÷²éѯ½á¹û´ò¿ªÒ»¸öÓαê 
FETCH¡¡¡¡¡¡--¼ìË÷Ò»Ðвéѯ½á¹û  
CLOSE¡¡¡¡¡¡--¹Ø±ÕÓÎ±ê  close 
PREPARE¡¡¡¡¡¡--Ϊ¶¯Ì¬Ö´ÐÐ×¼±¸SQL Óï¾ä  
EXECUTE¡¡¡¡¡¡--¶¯Ì¬µØÖ´ÐÐSQL Óï¾ä 
DESCRIBE¡¡¡¡ --ÃèÊö×¼±¸ºÃµÄ²éѯ  
---¾Ö²¿±äÁ¿ 
declare @id char(10) 
--set @id = ’10010001’ 
select @id = ’10010001’ 
---È«¾Ö±äÁ¿ 
---±ØÐëÒÔ@@¿ªÍ· 
--IF ELSE 
declare @x int @y int @z int 
select @x = 1 @y = 2 @z=3 
if @x > @y 


Ïà¹ØÎĵµ£º

SQLServerʱ¼äÈÕÆÚº¯ÊýÏê½â,SQLServer,ʱ¼äÈÕÆÚ,


SQLServerʱ¼äÈÕÆÚº¯ÊýÏê½â,SQLServer,ʱ¼äÈÕÆÚ,
1.      µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
        select getdate()
2. dateadd      ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
       À ......

sqlserverÊý¾ÝÀàÐÍ×ܽá

ÔÚ¼ÆËã»úÖÐÊý¾ÝÓÐÁ½ÖÖÌØÕ÷£ºÀàÐͺͳ¤¶È¡£ËùνÊý¾ÝÀàÐ;ÍÊÇÒÔÊý¾ÝµÄ±íÏÖ·½Ê½ºÍ´æ´¢·½Ê½À´»®·ÖµÄÊý¾ÝµÄÖÖÀà¡£
     ÔÚSQL Server ÖÐÿ¸ö±äÁ¿¡¢²ÎÊý¡¢±í´ïʽµÈ¶¼ÓÐÊý¾ÝÀàÐÍ¡£ÏµÍ³ÌṩµÄÊý¾ÝÀàÐÍ·ÖΪ¼¸´óÀ࣬Èç±í4-2 Ëùʾ¡£
     ÆäÖУ¬BIGINT¡¢ SQL_VARIANT ºÍTABLE ÊÇSQL Server 2 ......

SQLServer DBA³£見問題

In the latest installment of the SQL Server interview questions, we will outline questions suitable for a DBA interview to assess the candidates skills related to SQL Server system databases. In this tip, the questions are there to read, but the answers are intentionally hidden to really test your s ......

jdbc sqlserver oracle Çý¶¯ÎÊÌ⼯½õ

ojdbc14.jarÓëclasses12.jarÓÐÊ²Ã´Çø±ð??
×î½üÓÃclasses12.jar£¬hibernate3.1ÀÏÊdzöÎÊÌ⣿
ÎÒµÄoracle9.2.0.10!
ÔÚÍøÉÏÕÒ£¬·¢ÏÖÓÐÈËÓÃojdbc14.jar¿ª·¢£¬Ã»ÓÐÓùýÄØ£¿¿´oracleµÄreadme.txtҲûÓп´Ê²Ã´ÄØ£¿
ÄÇλ´ó¸çÖªµÀ˵һÏ£¡Ê®·Ö¸Ðл£¡
------------------------------------------------------------------------- ......

SqlServerÈ«¾Ö±äÁ¿±¸Íü


È«¾Ö±äÁ¿ÊÇSQL ServerϵͳÄÚ²¿ÊÂÏȶ¨ÒåºÃµÄ±äÁ¿£¬²»ÓÃÓû§²ÎÓ붨Ò壬¶ÔÓû§¶øÑÔ£¬Æä×÷Ó÷¶Î§²¢²»¾ÖÏÞÓÚijһ³ÌÐò£¬¶øÊÇÈκγÌÐò¾ù¿ÉËæÊ±µ÷Óá£È«¾Ö±äÁ¿Í¨³£ÓÃÓڴ洢һЩSQL ServerµÄÅäÖÃÉ趨ֵºÍЧÄÜͳ¼ÆÊý¾Ý¡£
SQL ServerÒ»¹²ÌṩÁË30¶à¸öÈ«¾Ö±äÁ¿£¬±¾½ÚÖ»¶ÔһЩ³£ÓñäÁ¿µÄ¹¦ÄܺÍʹÓ÷½·¨½øÐнéÉÜ¡£È«¾Ö±äÁ¿µÄÃû³Æ¶¼ÊÇÒÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ