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

SQL SERVER 2005 ´æ´¢¹ý³Ì

USE AdventureWorks
GO
CREATE PROC spEmployee
AS
SELECT * from Humanresources.Employee
EXEC spEmployee
ALTER PROC spEmployee
AS SELECT EmployeeID from Humanresources.Employee
drop proc spEmployee
ALTER PROC spEmployee
@LastName nvarchar(50) = NULL
AS
IF @LastName IS NULL
SELECT * from HumanResources.Employee
ELSE
SELECT c.LastName,c.FirstName,e.*
from Person.Contact c
INNER JOIN HumanResources.Employee e
ON c.ContactID = e.ContactID
WHERE c.LastName LIKE @LastName + '%'
EXEC spEmployee
BEGIN TRY
CREATE TABLE OurIFTest
(
COL INT PRIMARY KEY
)
END TRY
BEGIN CATCH
DECLARE @MyOutParameter int
IF ERROR_NUMBER() = 2714
BEGIN
PRINT 'WARNING SHIPPING CREATE AS TABLE ALREADY EXISTS'
EXEC dbo.uspLogError @ErrorLogID = @MyOutParameter OUTPUT
PRINT 'A ERROR WAS LOGGED.THE ERROR ID WAS ' + CAST(@MyOutParameter AS VARCHAR)
END
ELSE
RAISERROR('SOMETHINGS NOT GOOD HAPPENED THIS AROUND',16,1)
END CATCH
DROP TABLE OurIFTest
CREATE TABLE OurIFTest
(
COL INT PRIMARY KEY
)
IF @@ERROR != 0
PRINT 'PROBLEM'
ELSE
PRINT 'EVERYTHING ID OK !'
CREATE PROC spTestRETURN
AS
DECLARE @MyMessage varchar(50)
DECLARE @MyOtherMessage varchar(50)
SELECT @MyMessage = 'HI,IT''S THAT LINE BEFOR THE RETURN'
PRINT @MyMessage
RETURN
SELECT @MyOtherMessage = 'SORRY,BUT WE WON''T GET THIS FAR'
RETURN @MyOtherMessage
RETURN
ALTER PROC spTestRETURN
AS
DECLARE @MyMessage varchar(50)
DECLARE @MyOtherMessage varchar(50)
SELECT @MyMessage = 'HI,IT''S THAT LINE BEFOR THE RETURN'
PRINT @MyMessage
RETURN 100
SELECT @MyOtherMessage = 'SORRY,BUT WE WON''T GET THIS FAR'
PRINT @MyOtherMessage
RETURN
DECLARE @ReturnVal int
EXEC @ReturnVal = spTestRETURN
SELECT @ReturnVal
DECLARE @Error int
INSERT INTO Sales.Individual
(CustomerID,ContactID)
VALUES
(0,0)
SELECT @Error = @@ERROR
PRINT ''
PRINT 'THE VALUE OF ERROR IS ' + CONVERT(VARCHAR,@Error)
PRINT 'THE VALUE OF @@ERROR IS ' + CONVERT(VARCHAR


Ïà¹ØÎĵµ£º

µÚ10Õ£ºSQLºÍTQuery¶ÔÏó

±¾ÕÂÊǹØÓÚ²éѯ¡£ÕâÊÇÒ»¸öÖ÷Ì⣬ÔÚºËÐĵĿͻ§/·þÎñÆ÷±à³Ì£¬Òò´ËÕâÊDZ¾Êé¸üÖØÒªµÄƪÕÂÖ®Ò»¡£
¸Ã²ÄÁϽ«±»·Ö³ÉÒÔÏÂÖ÷Òª²¿·Ö£º
ʹÓÃTQuery¶ÔÏó
ʹÓñ¾µØºÍÔ¶³Ì·þÎñÆ÷µÄSQLÀ´Ñ¡Ôñ£¬¸üУ¬É¾³ýºÍ²åÈë¼Ç¼
ʹÓÃSQLÓï¾äÀ´´´½¨Á¬½Ó£¬ÁªÏµÓαêºÍ³ÌÐò£¬ËÑË÷µ¥¸ö¼Ç¼
Õâ¸öËõд´ú±íµÄSQL½á¹¹»¯²éѯÓïÑÔ£¬Í¨³£ÊÇÃ÷ÏÔµÄÐø¼¯»ò˵à ......

phpmyadmin ÐÞ¸ÄÖ´ÐÐsqlÎļþ´óСÏÞÖÆ

phpmyadmin ÐÞ¸ÄÖ´ÐÐsqlÎļþ´óСÏÞÖÆ
´ò¿ªphp.ini
post_max_size = 100M       ; ±íµ¥Ìá½»Îļþ´óСÉÏÏÞ
memory_limit = 128M    ; ÄÚ´æÉÏÏÞ
upload_max_filesize = 100M ; ÉÏ´«Îļþ´óСÉÏÏÞ
ÐÞ¸ÄÒÔÉÏÈýÏ¾Í¿ÉÒÔ½â¾ö¡£ µ«ÊÇ´ËʱPHPMYADMINÖÐ×î´óÏÞÖÆ£º22,528 KB£¬ ......

SQL 2005ת»»³É2000 (SQL Server)


Ö±½Órestore»ò¸½¼ÓÓ¦¸ÃÊDz»ÐеÄ, Óýű¾+µ¼Êý¾Ý¿Ï¶¨Ã»ÓÐÎÊÌâ¡£
2005תµ½2000µÄ²½Öè
1. Éú³Éfor 2000°æ±¾µÄÊý¾Ý¿â½Å±¾
2005 µÄmanger studio
-- ´ò¿ª"¶ÔÏó×ÊÔ´¹ÜÀíÆ÷"(ûÓеϰ°´F8), Á¬½Óµ½ÄãµÄʵÀý
-- ÓÒ¼üҪתµ½2000µÄ¿â
-- ÈÎÎñ
-- Éú³É½Å±¾
-- ÔÚ"½Å±¾Ïòµ¼"µÄ"Ñ¡ÔñÊý¾Ý¿â"ÖÐ, ......

¹ØÓÚmysqlÖд¥·¢Æ÷Ö´Ðж¯Ì¬sqlµÄÎÊÌâ

    Õ⼸ÌìÊÖÍ·¿ª·¢µÄϵͳҪ×öÒ»¸öÀàËÆwindowsÕË»§µ½ÆÚʱ¼äµÄ¹¦ÄÜ£¬¿¼ÂÇÁ˰ëÌìÏë³öÁËÒ»¸ö¼¼ÊõÉϺÍÂß¼­É϶¼»¹ÄÜʵÏֵĽâ¾ö·½°¸£º
´´½¨Ò»¸öÓû§´æÈëÊý¾Ý¿âµÄʱºò¶¼´´½¨Ò»¸öʼþµ÷¶ÈÆ÷À´¿ØÖÆÓû§µÄµ½ÆÚʱ¼ä£¨mysqlµÄʱ¼äµ÷¶ÈÆ÷ȷʵºÜ·½±ã£©¡£ÏëÆðÀ´ÊǺܼòµ¥£¬µ«ÊÇ×öÆðÀ´ÎÊÌâȷʵһ²¨½ÓÒ»²¨...
һЩСÎÊÌâ¾Í²» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ