問題描述

我知道我可以使用以下 sp 更改 sql 表:

I understand that I can change a sql table using the follow sp:

EXEC sp_rename 'customers', 'custs'

我將如何附加它以便新表以今天的日期作為后綴?

How would I go about appending this so that the new table has today's date as a suffix?

我嘗試了以下主題的變體，但收效甚微！

I've attempt variations on the below theme with little success!!

EXEC sp_rename 'customers', 'customers +(CONVERT(VARCHAR(8),GETDATE(),3))'

非常感謝任何幫助.

推薦答案

這聽起來很糟糕！你應該評估你的設計，用名稱中的日期重命名你的表格表明您將生成許多表，每個表用于不同的日期.您可以在表格中添加一個日期列并使用它來區分數據，而不是為不同的日期創建全新的表格.

This sounds like a very bad thing to do! you should evaluate your design, renaming your tables with dates in the names suggests that you will be spawning many tables, each for a different date. You could possibly add a date column into your table and use that to differentiate the data instead of creating completely new tables for different dates.

話雖如此，您不能將表達式作為 SQL Server 中存儲過程的參數.通過嘗試將格式化日期連接到字符串customers"，您試圖將表達式作為參數傳遞.

With that said, you can not have an expression as a parameter to a stored procedure in SQL Server. By attempting to concatenate the formatted date to the string 'customers', you were trying to pass an expression as a parameter.

您必須先將表達式存儲在局部變量中，然后使用該局部變量調用存儲過程:

you must store the expression in a local variable first, and then call the stored procedure with that local variable:

DECLARE @Value varchar(500)
SET @Value='customers' +(CONVERT(VARCHAR(8),GETDATE(),3))
EXEC sp_rename 'customers', @Value

這篇關于將 SQL 表名附加到今天的日期的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！