Как отладить MS SQL запросы на сервере MU Online в SQL Server?

foxx · 2011 Сен. 05, 16:19

Что в этом скрипте не правильно ?
Если можете , помогите отредактировать скрипт.
Три дня уже с ним вожусь , так и не смог понять что ему не хватает для правильной Отладки

Вот что он пишет после того как нажимаю в Query Analyzer Отладка.

Сообщение 102, уровень 15, состояние 1, процедура NewCharactersFixs, строка 9
Неправильный синтаксис около конструкции "FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFF".

Спойлер

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExtWarehouse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ExtWarehouse]
GO

CREATE TABLE [dbo].[ExtWarehouse] (
[AccountID] [varchar] (10) COLLATE Latin1_General_CS_AS NOT NULL ,
[Items] [varbinary] (1920) NULL ,
[Money] [int] NULL ,
[EndUseDate] [smalldatetime] NULL ,
[DbVersion] [tinyint] NULL ,
[pw] [smallint] NULL ,
[VaultID] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ExtWarehouse] ADD
CONSTRAINT [DF_ExtWarehouse_Money] DEFAULT (0) FOR [Money],
CONSTRAINT [DF_ExtWarehouse_DbVersion] DEFAULT (0) FOR [DbVersion],
CONSTRAINT [DF_ExtWarehouse_pw] DEFAULT (0) FOR [pw],
CONSTRAINT [DF_ExtWarehouse_NUMBER] DEFAULT (1) FOR [VaultID]
GO

ALTER TABLE [dbo].[warehouse] ADD
[VaultID] [int] NOT NULL DEFAULT (1)
GO

CREATE PROCEDURE [dbo].[ENC_ChangeVault]
L @Login varchar(10),
@futureVaultID int
AS
Begin
SET NOCOUNT ON
DECLARE
@actualVaultID int,
@actualVaultItem varbinary(1920),
@futureVaultItem varbinary(1920),
@actualMoney int,
@futureMoney int

IF NOT EXISTS ( SELECT * FROM warehouse WHERE AccountID = L @Login )
Begin
INSERT INTO warehouse (AccountID, Money, EndUseDate, DbVersion, VaultID) VALUES (L @Login,0, getdate(), 3, 1)
End

IF (@futureVaultID <= 0)
Begin
SELECT @futureVaultID = 1
End

SELECT @actualVaultID = VaultID FROM warehouse WHERE AccountID = L @Login

IF (@actualVaultID <> @futureVaultID)
Begin
IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @futureVaultID AND AccountID = L @Login )
Begin
SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = L @Login
SELECT @actualMoney = Money FROM warehouse WHERE AccountID = L @Login
SELECT @futureVaultItem = Items FROM ExtWarehouse WHERE AccountID = L @Login and VaultID=@futureVaultID
SELECT @futureMoney = Money FROM ExtWarehouse WHERE AccountID = L @Login and VaultID=@futureVaultID
UPDATE warehouse SET Items = @futureVaultItem, Money = @futureMoney, VaultID = @futureVaultID WHERE AccountID = L @Login

IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = L @Login )
Begin
UPDATE ExtWarehouse SET Items = @actualVaultItem, Money = @actualMoney WHERE AccountID = L @Login AND VaultID = @actualVaultID
End

ELSE
Begin
INSERT INTO ExtWarehouse (AccountID, Items, Money, EndUseDate, DbVersion, VaultID) VALUES (L @Login, @actualVaultItem, @actualMoney, getdate(), 3, @actualVaultID)
End
End

ELSE
Begin
SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = L @Login
SELECT @actualMoney = Money FROM warehouse WHERE AccountID = L @Login
UPDATE warehouse SET Items = NULL, Money = 0, VaultID = @futureVaultID WHERE AccountID = L @Login

IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = L @Login )
Begin
UPDATE ExtWarehouse SET Items = @actualVaultItem, Money = @actualMoney WHERE AccountID = L @Login AND VaultID = @actualVaultID
End

ELSE
Begin
INSERT INTO ExtWarehouse (AccountID, Items, Money, EndUseDate, DbVersion, VaultID) VALUES (L @Login, @actualVaultItem, @actualMoney, getdate(), 3, @actualVaultID)
End
End
End
End

GO

IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'NewCharactersFixs' AND type = 'TR')
DROP TRIGGER NewCharactersFixs
GO

CREATE TRIGGER [NewCharactersFixs] ON [dbo].[Character]
FOR INSERT
AS
BEGIN
IF ( SELECT Class FROM INSERTED ) = 96
BEGIN
UPDATE Character SET MagicList=Null, Quest=Null, Inventory=0x00001200000000000010000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14081E0
0
0000000000D000000000000014101E000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
WHERE Class='96'
END
END

[свернуть]

что никто не знает как поправить скрипт?

foxx · 2011 Сен. 05, 18:14

Стоит операционная система Windows 7 Professional x64bit.
MICROSOFT SQL SERVER 2008 R2

И ещё один вопрос.
Что и где надо ещё сделать , если в ручную прописано верно и ошибок не выдавало в Администрировании - Источники данных (ODBC)

Спойлер

[свернуть]

Спойлер

[свернуть]

Deathless · 2011 Сен. 05, 18:20

Цитата: foxx от 2011 Сен. 05, 17:14 Стоит операционная система Windows 7 Professional x64bit.
Что и где надо ещё сделать , если в ручную прописано верно и ошибок не выдавало в Администрировании - Источники данных (ODBC)

Вписывать здесь:
Start -> Run -> %WINDIR%SysWOW64odbcad32.exe

foxx · 2011 Сен. 05, 18:46

Цитата: Deathless от 2011 Сен. 05, 17:20 Вписывать здесь:
Start -> Run -> %WINDIR%SysWOW64odbcad32.exe

Так я там и добавлял в ручную.
Или эти два файла которые на скрине , тоже надо прописать в ручную?
Я добавил только одну MuOnline.

Deathless · 2011 Сен. 05, 18:57

ODBC x64:

Код Выделить

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INI]

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INILOGIN]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuOnline]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuOnlineJoinDB]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuRanking]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuEvent]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIUSELOG]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIRMDB_CONNECTLOG]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIPC_MUONLINE]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIAccountDB]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIWPaymentDB]
"Driver"="C:\WINDOWS\system32\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIODBC Data Sources]
"LOGIN"="SQL Server"
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"MuRanking"="SQL Server"
"MuEvent"="SQL Server"
"USELOG"="SQL Server"
"RMDB_CONNECTLOG"="SQL Server"
"PC_MUONLINE"="SQL Server"
"AccountDB"="SQL Server"
"WPaymentDB"="SQL Server"

foxx · 2011 Сен. 05, 19:14

Спойлер

Цитата: Deathless от 2011 Сен. 05, 17:57 ODBC x64:
Код Выделить Развернуть
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INI] [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INILOGIN] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="Administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuOnline] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="Administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuOnlineJoinDB] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="Administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuRanking] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="Administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIMuEvent] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="Administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIUSELOG] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="Administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIRMDB_CONNECTLOG] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIPC_MUONLINE] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIAccountDB] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIWPaymentDB] "Driver"="C:\WINDOWS\system32\SQLSRV32.dll" "Server"="(local)" "Database"="MuOnline" "LastUser"="administrator" "Trusted_Connection"="Yes" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIODBC Data Sources] "LOGIN"="SQL Server" "MuOnline"="SQL Server" "MuOnlineJoinDB"="SQL Server" "MuRanking"="SQL Server" "MuEvent"="SQL Server" "USELOG"="SQL Server" "RMDB_CONNECTLOG"="SQL Server" "PC_MUONLINE"="SQL Server" "AccountDB"="SQL Server" "WPaymentDB"="SQL Server"

[свернуть]

Перезаписал файл ODBC с этими настройками и всё равно в логах такая хрень

19:6:59 QNO : 3, TID : 2, DB ODBC CONNECT [FAIL]
19:7:0 SQLSTATE:IM002, БшґЬБ¤єё:[Microsoft][Диспетчер драйверов ODBC] Источник данных не найден и не указан драйвер, используемый по умолчанию

А вот в Ranking пропал еррор.

Вот то что я создал.

Спойлер

[свернуть]

Deathless · 2011 Сен. 05, 19:21

1. DSN для программ:
- X:\MuServer\RankingServer\svconfig.ini
-- odbc_dsn = Ranking
- X:\MuServer\EventServer\Data\svconfig.ini
-- mu2003_dsn = MU2003_EVENT_DATA

2. Надо добавить и остальные DSN записи:
- LOGIN
- MuOnlineJoinDB
- USELOG
- RMDB_CONNECTLOG
- PC_MUONLINE
- AccountDB

foxx · 2011 Сен. 05, 19:59

Цитата: Deathless от 2011 Сен. 05, 18:21 1. DSN для программ:
- X:MuServerRankingServersvconfig.ini
-- odbc_dsn = Ranking
- X:MuServerEventServerDatasvconfig.ini
-- mu2003_dsn = MU2003_EVENT_DATA

2. Надо добавить и остальные DSN записи:
- LOGIN
- MuOnlineJoinDB
- USELOG
- RMDB_CONNECTLOG
- PC_MUONLINE
- AccountDB

Этот ODBC - MuOnlineJoinDB там был
Этот тоже - USELOG был

А вот этих не было
- LOGIN
- RMDB_CONNECTLOG
- PC_MUONLINE
- AccountDB

Какие из них и в какие ODBC пихать?
MU2003_EVENT_DATA
MuOnline
Ranking

P.S
По поводу скрипта никто не чем помочь не может?

ketanof · 2011 Сен. 06, 18:15

пробуй ..

Код Выделить

if exists (select * from dbo.sysobjects where id =  object_id(N'[dbo].[ExtWarehouse]') and OBJECTPROPERTY(id,  N'IsUserTable') = 1)
drop table [dbo].[ExtWarehouse]
GO

CREATE TABLE [dbo].[ExtWarehouse] (
[AccountID] [varchar] (10) COLLATE Latin1_General_CS_AS NOT NULL ,
[Items] [varbinary] (1920) NULL ,
[Money] [int] NULL ,
[EndUseDate] [smalldatetime] NULL ,
[DbVersion] [tinyint] NULL ,
[pw] [smallint] NULL ,
[VaultID] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ExtWarehouse] ADD
CONSTRAINT [DF_ExtWarehouse_Money] DEFAULT (0) FOR [Money],
CONSTRAINT [DF_ExtWarehouse_DbVersion] DEFAULT (0) FOR [DbVersion],
CONSTRAINT [DF_ExtWarehouse_pw] DEFAULT (0) FOR [pw],
CONSTRAINT [DF_ExtWarehouse_NUMBER] DEFAULT (1) FOR [VaultID]
GO

ALTER TABLE [dbo].[warehouse] ADD
[VaultID] [int] NOT NULL DEFAULT (1)
GO

CREATE PROCEDURE [dbo].[ENC_ChangeVault]
@login varchar(10),
@futureVaultID int
AS
Begin
SET NOCOUNT ON
DECLARE
@actualVaultID int,
@actualVaultItem varbinary(1920),
@futureVaultItem varbinary(1920),
@actualMoney int,
@futureMoney int

IF NOT EXISTS ( SELECT * FROM warehouse WHERE AccountID = @login )
Begin
INSERT INTO warehouse (AccountID, Money, EndUseDate, DbVersion, VaultID) VALUES (@login,0, getdate(), 3, 1)
End

IF (@futureVaultID <= 0)
Begin
SELECT @futureVaultID = 1
End

SELECT @actualVaultID = VaultID FROM warehouse WHERE AccountID = @login

IF (@actualVaultID <> @futureVaultID)
Begin
IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @futureVaultID AND AccountID = @login )
Begin
SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = @login
SELECT @actualMoney = Money FROM warehouse WHERE AccountID = @login
SELECT @futureVaultItem = Items FROM ExtWarehouse WHERE AccountID = @login and VaultID=@futureVaultID
SELECT @futureMoney = Money FROM ExtWarehouse WHERE AccountID = @login and VaultID=@futureVaultID
UPDATE warehouse SET Items = @futureVaultItem, Money = @futureMoney, VaultID = @futureVaultID WHERE AccountID = @login

IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = @login )
Begin
UPDATE ExtWarehouse SET Items = @actualVaultItem, Money =  @actualMoney WHERE AccountID = @login AND VaultID = @actualVaultID
End

ELSE
Begin
INSERT INTO ExtWarehouse (AccountID, Items, Money,  EndUseDate, DbVersion, VaultID) VALUES (@login, @actualVaultItem,  @actualMoney, getdate(), 3, @actualVaultID)
End
End

ELSE
Begin
SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = @login
SELECT @actualMoney = Money FROM warehouse WHERE AccountID = @login
UPDATE warehouse SET Items = NULL, Money = 0, VaultID = @futureVaultID WHERE AccountID = @login

IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = @login )
Begin
UPDATE ExtWarehouse SET Items = @actualVaultItem, Money =  @actualMoney WHERE AccountID = @login AND VaultID = @actualVaultID
End

ELSE
Begin
INSERT INTO ExtWarehouse (AccountID, Items, Money,  EndUseDate, DbVersion, VaultID) VALUES (@login, @actualVaultItem,  @actualMoney, getdate(), 3, @actualVaultID)
End
End
End
End

GO

IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'NewCharactersFixs' AND type = 'TR')
DROP TRIGGER NewCharactersFixs
GO

CREATE TRIGGER [NewCharactersFixs] ON [dbo].[Character]
FOR INSERT
AS
BEGIN
IF ( SELECT Class FROM INSERTED ) = 96
BEGIN
UPDATE Character SET MagicList=Null, Quest=Null,  Inventory=0x00001200000000000010000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
F
FFFFFFFFFFFFFFFFFF
WHERE Class='96'
END
END

foxx · 2011 Сен. 06, 20:46

Подскажите на что это влияет если выбрать одно из них ?
Такими функциями можно воспользоваться при восстановлении базы данных.

SQL Server 2000 (80)
SQL Server 2005 (90)
SQL Server 2008 (100)

ОС стоит
Windows 7 Professional x64bit.
MICROSOFT SQL SERVER 2008 R2

И какая из этих функций подойдёт для сервера и Apache ?

Спойлер

[свернуть]

Спойлер

Цитата: ketanof от 2011 Сен. 06, 17:15 пробуй ..

Код Выделить Развернуть
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExtWarehouse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ExtWarehouse] GO CREATE TABLE [dbo].[ExtWarehouse] ( [AccountID] [varchar] (10) COLLATE Latin1_General_CS_AS NOT NULL , [Items] [varbinary] (1920) NULL , [Money] [int] NULL , [EndUseDate] [smalldatetime] NULL , [DbVersion] [tinyint] NULL , [pw] [smallint] NULL , [VaultID] [int] NOT NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[ExtWarehouse] ADD CONSTRAINT [DF_ExtWarehouse_Money] DEFAULT (0) FOR [Money], CONSTRAINT [DF_ExtWarehouse_DbVersion] DEFAULT (0) FOR [DbVersion], CONSTRAINT [DF_ExtWarehouse_pw] DEFAULT (0) FOR [pw], CONSTRAINT [DF_ExtWarehouse_NUMBER] DEFAULT (1) FOR [VaultID] GO ALTER TABLE [dbo].[warehouse] ADD [VaultID] [int] NOT NULL DEFAULT (1) GO CREATE PROCEDURE [dbo].[ENC_ChangeVault] @login varchar(10), @futureVaultID int AS Begin SET NOCOUNT ON DECLARE @actualVaultID int, @actualVaultItem varbinary(1920), @futureVaultItem varbinary(1920), @actualMoney int, @futureMoney int IF NOT EXISTS ( SELECT * FROM warehouse WHERE AccountID = @login ) Begin INSERT INTO warehouse (AccountID, Money, EndUseDate, DbVersion, VaultID) VALUES (@login,0, getdate(), 3, 1) End IF (@futureVaultID <= 0) Begin SELECT @futureVaultID = 1 End SELECT @actualVaultID = VaultID FROM warehouse WHERE AccountID = @login IF (@actualVaultID <> @futureVaultID) Begin IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @futureVaultID AND AccountID = @login ) Begin SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = @login SELECT @actualMoney = Money FROM warehouse WHERE AccountID = @login SELECT @futureVaultItem = Items FROM ExtWarehouse WHERE AccountID = @login and VaultID=@futureVaultID SELECT @futureMoney = Money FROM ExtWarehouse WHERE AccountID = @login and VaultID=@futureVaultID UPDATE warehouse SET Items = @futureVaultItem, Money = @futureMoney, VaultID = @futureVaultID WHERE AccountID = @login IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = @login ) Begin UPDATE ExtWarehouse SET Items = @actualVaultItem, Money = @actualMoney WHERE AccountID = @login AND VaultID = @actualVaultID End ELSE Begin INSERT INTO ExtWarehouse (AccountID, Items, Money, EndUseDate, DbVersion, VaultID) VALUES (@login, @actualVaultItem, @actualMoney, getdate(), 3, @actualVaultID) End End ELSE Begin SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = @login SELECT @actualMoney = Money FROM warehouse WHERE AccountID = @login UPDATE warehouse SET Items = NULL, Money = 0, VaultID = @futureVaultID WHERE AccountID = @login IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = @login ) Begin UPDATE ExtWarehouse SET Items = @actualVaultItem, Money = @actualMoney WHERE AccountID = @login AND VaultID = @actualVaultID End ELSE Begin INSERT INTO ExtWarehouse (AccountID, Items, Money, EndUseDate, DbVersion, VaultID) VALUES (@login, @actualVaultItem, @actualMoney, getdate(), 3, @actualVaultID) End End End End GO IF EXISTS (SELECT name FROM sysobjects WHERE name = 'NewCharactersFixs' AND type = 'TR') DROP TRIGGER NewCharactersFixs GO CREATE TRIGGER [NewCharactersFixs] ON [dbo].[Character] FOR INSERT AS BEGIN IF ( SELECT Class FROM INSERTED ) = 96 BEGIN UPDATE Character SET MagicList=Null, Quest=Null, Inventory=0x00001200000000000010000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF F FFFFFFFFFFFFFFFFFF WHERE Class='96' END END

[свернуть]

Спасибо нажал.

А по поводу функций , никто не подскажет на что это влияет!?

x-MU.net форум

Как отладить MS SQL запросы на сервере MU Online в SQL Server?

foxx

foxx

Deathless

foxx

Deathless

foxx

Deathless

foxx

ketanof

foxx

Похожие темы (5)