²½²½ÎªÓª .NETÈý²ã¼Ü¹¹½âÎö ¶þ¡¢Êý¾Ý¿âÉè¼Æ
Òª¿ª·¢Óû§¹ÜÀíϵͳ,ÎÒÃÇÊ×ÏÈÒªÁ˽âÐèÇó,ÏÖÔھ;ÙÒ»¸ö¼òµ¥ÐèÇó,Óû§±í,¼ÙÉèÓÐÁ½ÖÖ½ÇÉ«ÓÃÒ»¸ö×Ö¶ÎdepartIDÀ´ÅжÏ,¹ÜÀíÔ±ºÍÔ±¹¤,
ÎÒÃÇÒªÏȽ¨Ò»¸öÓû§±ícustomºÍÒ»¸ö²¿Ãűídepartment:
CREATE TABLE [dbo].[custom]( [id] [int] IDENTITY(1,1) NOT NULL, [cname] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [departID] [int] NOT NULL, [age] [int] NOT NULL, [ename] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [password] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_custom] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]; CREATE TABLE [dbo].[department]( [id] [int] IDENTITY(1,1) NOT NULL, [departname] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [description] [nchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_department] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]½¨ÍêÊý¾Ý¿â±íºó,¿ªÊ¼Ð´´æ´¢¹ý³Ì,²åÈëÒ»ÌõÊý¾Ý:
CREATE PROCEDURE [dbo].[spInsertCustom] @cname nvarchar(50), @ename nvarchar(50), @age int, @departID int, @password nvarchar(50) AS BEGIN insert into custom(cname,departID,age,ename,password) values (@cname,@departID,@age,@ename,@password) END RETURN @@IdentityÏÖ½¨Á½¸ö¸üÐÂÒ»ÌõÊý¾ÝµÄ´æ´¢¹ý³Ì:
CREATE PROCEDURE [dbo].[spupdatecustom] @id int, @cname nvarchar(50), @departID int, @age int, @ename nvarchar(50), @password nvarchar(50) AS BEGIN update custom set cname = @cname, departID = @departID, age = @age, ename = @ename, password = @password where id = @id END COMMIT TRANÔÙн¨Á½¸öÈ¡³öËùÓÐÓû§µÄ´æ´¢¹ý³Ì:
CREATE PROCEDURE [dbo].[spGetcustom] AS BEGIN select * from custom order by id desc ENDÔÙн¨Ò»¸ö¸ù¾ÝIDÈ¡³öÒ»ÌõÊý¾ÝµÄ´æ´¢¹ý³Ì:
CREATE PROCEDURE [dbo].[spGetcustomer] @id int AS BEGIN select * from custom where id = @id END
ÍÆ¼öÐÅÏ¢
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔØ½ø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
×î½ü¸üÐÂ
- Asp.net MVCÔ´Âë·ÖÎö--Model Validation(Se....
- .Net À¬»ø»ØÊÕ»úÖÆÔÀíºÍËã·¨£¨Ò»£©
- .netʵÌåнâ
- ·ÖÎöASP.NET¶ÁÈ¡XMLÎļþ4ÖÖ·½·¨
- »ñÈ¡ÍøÕ¾ËõÂÔͼ´úÂë
- Asp.net ¸ù¾ÝIPµØÖ·»ñÈ¡¿çÍø¶ÎmacµØÖ·º¯Êý¡¾ËѲء¿
- ¹ýÂËÃô¸Ð¹Ø¼ü×Ö¡£
- Éú³ÉÖ¸¶¨Î»ÊýµÄËæ»ú×Ö·û´®
- ¿Í»§¶Ë»ñÈ¡MACµØÖ·£¬µ½·þÎñÆ÷ÑéÖ¤
- ²½²½ÎªÓª .NETÈý²ã¼Ü¹¹½âÎö ¶þ¡¢Êý¾Ý¿âÉè¼Æ
¡Á
¶©ÔÄ
¶©Ôĵ½ÔĶÁÆ÷£º
ÆÀÂÛ