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,ʱ¼äÈÕÆÚ,
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
À ......
ÔÚ¼ÆËã»úÖÐÊý¾ÝÓÐÁ½ÖÖÌØÕ÷£ºÀàÐͺͳ¤¶È¡£ËùνÊý¾ÝÀàÐ;ÍÊÇÒÔÊý¾ÝµÄ±íÏÖ·½Ê½ºÍ´æ´¢·½Ê½À´»®·ÖµÄÊý¾ÝµÄÖÖÀà¡£
ÔÚSQL Server ÖÐÿ¸ö±äÁ¿¡¢²ÎÊý¡¢±í´ïʽµÈ¶¼ÓÐÊý¾ÝÀàÐÍ¡£ÏµÍ³ÌṩµÄÊý¾ÝÀàÐÍ·ÖΪ¼¸´óÀ࣬Èç±í4-2 Ëùʾ¡£
ÆäÖУ¬BIGINT¡¢ SQL_VARIANT ºÍTABLE ÊÇSQL Server 2 ......
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 ......
ojdbc14.jarÓëclasses12.jarÓÐÊ²Ã´Çø±ð??
×î½üÓÃclasses12.jar£¬hibernate3.1ÀÏÊdzöÎÊÌ⣿
ÎÒµÄoracle9.2.0.10!
ÔÚÍøÉÏÕÒ£¬·¢ÏÖÓÐÈËÓÃojdbc14.jar¿ª·¢£¬Ã»ÓÐÓùýÄØ£¿¿´oracleµÄreadme.txtҲûÓп´Ê²Ã´ÄØ£¿
ÄÇλ´ó¸çÖªµÀ˵һÏ£¡Ê®·Ö¸Ðл£¡
------------------------------------------------------------------------- ......
È«¾Ö±äÁ¿ÊÇSQL ServerϵͳÄÚ²¿ÊÂÏȶ¨ÒåºÃµÄ±äÁ¿£¬²»ÓÃÓû§²ÎÓ붨Ò壬¶ÔÓû§¶øÑÔ£¬Æä×÷Ó÷¶Î§²¢²»¾ÖÏÞÓÚijһ³ÌÐò£¬¶øÊÇÈκγÌÐò¾ù¿ÉËæÊ±µ÷Óá£È«¾Ö±äÁ¿Í¨³£ÓÃÓڴ洢һЩSQL ServerµÄÅäÖÃÉ趨ֵºÍЧÄÜͳ¼ÆÊý¾Ý¡£
SQL ServerÒ»¹²ÌṩÁË30¶à¸öÈ«¾Ö±äÁ¿£¬±¾½ÚÖ»¶ÔһЩ³£ÓñäÁ¿µÄ¹¦ÄܺÍʹÓ÷½·¨½øÐнéÉÜ¡£È«¾Ö±äÁ¿µÄÃû³Æ¶¼ÊÇÒÔ ......