declare @v_SQL varchar(2000)
DECLARE @CurrDate AS DATETIME
SELECT @CurrDate = DATEADD(Year, 1, GETDATE())
SET @v_SQL = 'CREATE TABLE ' + convert(varchar(21), DATEADD(Year, 1, GETDATE())) + '
(NASIdentifier varchar(16),
NASPort varchar(10),
AcctSessionID varchar(10),
AcctStatusType tinyint(1),
CallDate smalldatetime(4),
UserName varchar(32),
UserService tinyint(1),
AcctDelayTime int(4),
AcctSessionTime int(4),
FramedProtocol int(4),
FramedAddress varchar(16),
AcctInputOctets int(4),
AcctOutputOctets int(4),
AcctTerminateCause tinyint(1),
NASPortType tinyint(1),
NASPortDNIS varchar(10),
CallerID varchar(12),
ConnectInfo varchar(32)
) '
exec (@v_sql)
[code/]
قوانین ایجاد تاپیک در تالار
