2.这个datepart 能够 提取其中的任何一个: Year, yy, yyyy, quarter, qq, q, month, mm, m, dayofyear, dy, y, day, dd, d, week, wk, ww, weekday, dw,hour, hh, minute, mi, n, second, ss, s, millisecond, or ms.
for example: datepart(year,getdate())
2.插入一组数据的 存储过程:
Code
1CREATE PROCEDURE [dbo].[insertpage]
2(
3@Name char(50),
4@Address char(100),
5@Telephone char(50),
6@Email char(50),
7@ID int OUTPUT
8)
9As
10Declare @Age INT
11SET @Age = 0
12SET @Age = [dbo].[ufn_GetAge1](@Birthday, getdate())INSERT INTO [Customer] ([Name],
13[Address],[Telephone],[Email], [Age]) VALUES (@Name,@Address,@Telephone,@Email,@Age)
14
15SET @ID = @@IDENTITY 这个是输出(http://msdn.microsoft.com/en-us/library/ms187342.aspx)
16
17
3. View 功能
4. trigger 功能
Code
1Create TRIGGER [dbo].[tableLastModifiedDate]ON [dbo].[table1]
2FOR UPDATE
3AS
4UPDATE table1SET table1.Lastmodified=getdate()
5FROM table1INNER JOIN Inserted ON table1.ID= Inserted.ID
6
。。。。。