基于动态参数的值,用于SQL数据库中使用的文件组的硬编码值 [英] Dynamic parameter based values insted of hardcoded values for filegroup used in SQL database
问题描述
我希望基于参数的值而不是数据库文件组中的硬编码值,其值低于以下值
I want parameter based values instead of hardcoded values in database filegroup in below values
ALTER DATABASE [$(DatabaseName)]
ADD LOG FILE
(
NAME = [Transactional_Log1_log],
FILENAME = "C:\",
SIZE = 32000MB,
MAXSIZE = 200000MB,
FILEGROWTH = 500MB
)
我希望使用基于参数的值而不是硬编码
SIZE = 32000MB,
MAXSIZE = 200000MB,
FILEGROWTH = 500MB
建议表示赞赏
我尝试了什么:
我尝试使用FILENAME来制作动态使用的语法,例如
I want below values using parameter based instead of hardcoded
SIZE = 32000MB,
MAXSIZE = 200000MB,
FILEGROWTH = 500MB
Suggestion are appreciated
What I have tried:
I tried for FILENAME for making dynamic used syntax like
FILENAME = '$(LogPath)$(DefaultFilePrefix)_Transactional_Log1.ldf',
这个工作正常,但我想要以下所有值动态方式使用参数。
This is working fine but i want all below values in dynamic ways using parameter.
推荐答案
(DatabaseName)]
ADD LOG FILE
(
NAME = [Transactional_Log1_log],
FILENAME =C:\,
SIZE = 32000MB,
MAXSIZE = 200000MB,
FILEGROWTH = 500MB
)
(DatabaseName)] ADD LOG FILE ( NAME = [Transactional_Log1_log], FILENAME = "C:\", SIZE = 32000MB, MAXSIZE = 200000MB, FILEGROWTH = 500MB )
我想要使用基于参数的值而不是硬编码
SIZE = 32000MB,
MAXSIZE = 200000MB,
FILEGROWTH = 500MB
建议表示赞赏
我是什么尝试过:
我尝试使用FILENAME制作动态使用的语法,例如
I want below values using parameter based instead of hardcoded
SIZE = 32000MB,
MAXSIZE = 200000MB,
FILEGROWTH = 500MB
Suggestion are appreciated
What I have tried:
I tried for FILENAME for making dynamic used syntax like
FILENAME = '
(LogPath)
(DefaultFilePrefix)_Transactional_Log1.ldf',
(DefaultFilePrefix)_Transactional_Log1.ldf',
这样工作正常,但我希望使用参数以动态方式获得所有以下值。
This is working fine but i want all below values in dynamic ways using parameter.
这篇关于基于动态参数的值,用于SQL数据库中使用的文件组的硬编码值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!