test_DbaHelpers.test GetSettingInt eksik veya bozuk degerde default doner
procedureDB-11 · modified 10/11/2026 · Back to object search
Statements
0 statements ·
0 executions ·
0.0 s total
Nothing here
No executions of this object in the period.
Dependencies
Direct references (sys.sql_expression_dependencies); dynamic SQL and deferred names may be missing.same databaseother databaselinked server
| Direction | Object | Type | Scope |
|---|---|---|---|
| uses | DBA.AppSetting | table | same database |
| uses | DBA.fn_GetSettingInt | function | same database |
| uses | tSQLt.AssertEquals | procedure | same database |
| uses | tSQLt.FakeTable | procedure | same database |
CREATE PROCEDURE test_DbaHelpers.[test GetSettingInt eksik veya bozuk degerde default doner]
AS
BEGIN
EXEC tSQLt.FakeTable N'DBA.AppSetting';
INSERT DBA.AppSetting (SettingKey, SettingValue) VALUES (N'A', N'abc'), (N'B', N'42');
-- EXEC parametresi ifade/alt sorgu alamaz: önce değişkene ata.
DECLARE @a int = DBA.fn_GetSettingInt(N'A', 7), @b int = DBA.fn_GetSettingInt(N'B', 7), @c int = DBA.fn_GetSettingInt(N'YOK', 7);
EXEC tSQLt.AssertEquals 7, @a;
EXEC tSQLt.AssertEquals 42, @b;
EXEC tSQLt.AssertEquals 7, @c;
END;
Analyses of this object
Nothing here
No analyses for this object.