社区
MS-SQL Server
帖子详情
在执行语句时出现:参数 @objname 不明确或所声明的 @objtype (column)错误
dx
2003-10-30 08:48:07
sql_alter_km4="EXEC sp_rename '[2003秋季].[总分]', '总分', 'COLUMN'"
在查询分析器上 执行上面的语句时出错:
参数 @objname 不明确或所声明的 @objtype (column)错误
...全文
839
4
打赏
收藏
在执行语句时出现:参数 @objname 不明确或所声明的 @objtype (column)错误
sql_alter_km4="EXEC sp_rename '[2003秋季].[总分]', '总分', 'COLUMN'" 在查询分析器上 执行上面的语句时出错: 参数 @objname 不明确或所声明的 @objtype (column)错误
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
4 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
dx
2003-10-30
打赏
举报
回复
我现在就是有这样的要求呀
你们说的都不行,都会出现上面的错误
viptiger
2003-10-30
打赏
举报
回复
sql_alter_km4="EXEC sp_rename '[2003秋季].[总分]', '总分', '[COLUMN]'"
pengdali
2003-10-30
打赏
举报
回复
查询分析器上:
EXEC sp_rename '[2003秋季].[总分]', '总分', 'COLUMN'
?
txlicenhe
2003-10-30
打赏
举报
回复
1:查询分析器当然只能执行引号里面的东东
2:怎么修改前的列名和修改后的列名一样呢?
EXEC sp_rename '表名.旧列名', '新列名', 'COLUMN'
或
EXEC sp_rename '表名.旧列名', '新列名'
sqlserver自定义函数
--计算当前月的实际天数 Create FUNCTION dbo.CalcDaysOfMonth (@time varchar(6)) RETURNS int AS BEGIN DECLARE @Days int DECLARE @Month int DECLARE @Year int SET @Year=SUBSTRING(@time,1,4) SET @Month=SUBSTRING(@time,5,6) if( @Month='1' OR @Month='3' OR @Month='5' OR @Month='7' OR @Month='8' OR @Month='10' OR @Month='12' ) set @Days=31 else if( @Month='4' OR @Month='6' OR @Month='9' OR @Month='11' ) set @Days=30; else if(@Year%400=0 OR (@Year%4=0 AND @Year%100<>0)) set @Days=29 else set @Days=28 RETURN(@Days) END --确定某年某月有多少天 Create FUNCTION DaysInMonth ( @date datetime ) Returns int AS BEGIN RETURN Day(dateadd(mi,-3,DATEADD(m, DATEDIFF(m,0,@date)+1,0))) END --哪一天是输入
时
间的星期一 Create FUNCTION MondayInDate ( @date datetime ) RETURNS DATETIME AS BEGIN RETURN DATEADD(week, DATEDIFF(week,0,@date),0) END --输入
时
间的季度的第一天 Create FUNCTION QuarterInDate ( @date datetime ) RETURNS DATETIME AS BEGIN RETURN DATEADD(quarter, DATEDIFF(quarter,0,@date), 0) END --输入
时
间的季度的天数 Create FUNCTION QuarterDaysInDate ( @date datetime ) RETURNS INT AS BEGIN declare @m tinyint,@time SMALLDATETIME select @m=month(@date) select @m=case when @m between 1 and 3 then 1 when @m between 4 and 6 then 4 when @m between 7 and 9 then 7 else 10 end select @time=datename(year,@date)+'-'+convert(varchar(10),@m)+'-01' return datediff(day,@time,dateadd(mm,3,@time)) END --按指定符号分割字符串,返回分割后的元素个数,方法很简单,就是看字符串中存在多少个分隔符号,然后再加一,就是要求的结果。 Create function Get_StrArrayLength ( @str varchar(1024), --要分割的字符串 @split varchar(10) --分隔符号 ) returns int as begin declare @location int declare @start int declare @length int set @str=ltrim(rtrim(@str)) set @location=charindex(@split,@str) set @length=1 while @location<>0 begin set @start=@location+1 set @location=charindex(@split,@str,@start) set @length=@length+1 end return @length END --按指定符号分割字符串,返回分割后指定索引的第几个元素,象数组一样方便 Create function Get_StrArrayStrOfIndex ( @str varchar(1024), --要分割的字符串 @split varchar(10), --分隔符号 @index int --取第几个元素 ) returns varchar(1024) as begin declare @location int declare @start int declare @next int declare @seed int set @str=ltrim(rtrim(@str)) set @start=1 set @next=1 set @seed=len(@split) set @location=charindex(@split,@str) while @location<>0 and @index>@next begin set @start=@location+@seed set @location=charindex(@split,@str,@start) set @next=@next+1 end if @location =0 select @location =len(@str)+1 --这儿存在两种情况:1、字符串不存在分隔符号 2、字符串中存在分隔符号,跳出while循环后,@location为0,那默认为字符串后边有一个分隔符号。 return substring(@str,@start,@location-@start) END select dbo.Get_StrArrayStrOfIndex('8,9,4','',4) --结合上边两个函数,象数组一样遍历字符串中的元素 create function f_splitstr(@SourceSql varchar(8000),@StrSeprate varchar(100)) returns @temp table(F1 varchar(100)) as begin declare @ch as varchar(100) set @SourceSql=@SourceSql+@StrSeprate while(@SourceSql<>'') begin set @ch=left(@SourceSql,charindex(',',@SourceSql,1)-1) insert @temp values(@ch) set @SourceSql=stuff(@SourceSql,1,charindex(',',@SourceSql,1),'') end return end select * from dbo.f_splitstr('1,2,3,4',',') --全角和半角转换函数 Create FUNCTION f_Convert( @str NVARCHAR(4000), --要转换的字符串 @flag bit --转换标志,0转换成半角,1转换成全角 )RETURNS nvarchar(4000) AS BEGIN DECLARE @pat nvarchar(8),@step int,@i int,@spc int IF @flag=0 Select @pat=N'%[!-~]%',@step=-65248, @str=REPLACE(@str,N' ',N' ') ELSE Select @pat=N'%[!-~]%',@step=65248, @str=REPLACE(@str,N' ',N' ') SET @i=PATINDEX(@pat COLLATE LATIN1_GENERAL_BIN,@str) WHILE @i>0 Select @str=REPLACE(@str, SUBSTRING(@str,@i,1), NCHAR(UNICODE(SUBSTRING(@str,@i,1))+@step)) ,@i=PATINDEX(@pat COLLATE LATIN1_GENERAL_BIN,@str) RETURN(@str) END GO declare @s1 varchar(8000) select @s1='中 2-3456a78STUVabn中国opwxyz' select dbo.f_convert(@s1,0),dbo.f_convert(@s1,1) 函数返回值是表 create table test(id int primary key,name char(10)) insert into test values(1,'test1') insert into test values(2,'test2') insert into test values(3,'test3') insert into test values(4,'test4') 1、标量函数 create function return_count() returns int as begin declare @count int select @count=count(*) from test return @count end --调用 select dbo.return_count() cont --count为显示的列头 --运行结果 --count --4 2、内嵌表值函数 create function return_test() returns table as --begin 内联表值函数不能用begin-end return select name from test --end --调用 select * from return_test() --运行结果 --name --test1 --test2 --test3 --test4 3、多
语句
表值函数 create function return_test_multi() returns @temp table(id int,name char(10)) as begin insert into @temp select * from test where id in(1,2) return --记住,一定不要忘记写return end --调用 select * from dbo.return_test_multi() --运行结果 --id name --1 test1 --2 test2 在查询结果中增加一个自动增长的ID select id=identity(int, 1, 1), * into #T from testTable select * from #T drop table #T sql删除重复的记录 打开测试数据库test,并以表w01为例,将下面的SQL
语句
放入sql2000查询分析器中,一段一段
执行
即可看到效果 ---在sql2000下创建测试数据表 if exists (select * from dbo.sys
obj
ects where id =
obj
ect_id(N'[dbo].[w01]') and
OBJ
ECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[w01] ---在sql2005下创建测试数据表,如果是sql2005则用本段来判断数据表是否存在 ---if exists(select 1 from sys.tables where name='w01') ---drop table w01 ----开始创建测试数据库 GO create table w01(gs903 varchar(32),gs1002 varchar(32)) insert into w01 select '1','a' union all select '1','a' union all select '1','a' union all select '2','a' union all select '2','e' union all select '3','b' union all select '3','d' go select * from w01 go ---为表w01添加一个可以表示唯一标示的自增字段ID alter table w01 add [ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ---查询删除前的数据和记录数:7 select * from w01 select count(*) from w01 ---查询具有重复记录的所有记录;3 select gs903,gs1002,count(*) as count from w01 group by gs903,gs1002 having count(*)>1 order by count desc ---删除重复的数据:2行 delete from w01 where id not in (select max(id) from w01 group by gs903,gs1002) ---看看删除后还有没有重复记录:0 select gs903,gs1002,count(*) as count from w01 group by gs903,gs1002 having count(*)>1 order by count desc ---删除后的数据和记录数:7-2=5 select * from w01 select count(*) from w01 用SQL
语句
添加删除修改字段 增加字段 alter table docdsp add dspcode char(200) 删除字段 Alter TABLE table_NAME Drop
COLUMN
column
_NAME 修改字段类型 Alter TABLE table_name Alter
COLUMN
column
_name new_data_
type
改名 sp_rename 更改当前数据库中用户创建对象(如表、列或用户定义数据类型)的名称。 语法 sp_rename [ @
obj
name = ] '
obj
ect_name' , [ @newname = ] 'new_name' [ , [ @
obj
type
= ] '
obj
ect_
type
' ] --假设要处理的表名为: tb --判断要添加列的表中是否有主键 if exists(select 1 from sys
obj
ects where parent_
obj
=
obj
ect_id('tb') and x
type
='PK') begin print '表中已经有主键,列只能做为普通列添加' --添加int类型的列,默认值为0 alter table tb add 列名 int default 0 end else begin print '表中无主键,添加主键列' --添加int类型的列,默认值为0 alter table tb add 列名 int primary key default 0 end
修改表结构的 asp C# 源代码
var sNewFieldString = '
' + '\n' + get
Obj
ByID.toString() + '\n' + showField
Type
.toString() + '\n' + checkField
Type
.toString() + '\n' + checkInput.toString() + '\n' +'function doNewField(o){' + '\n' +' var sSqlString = "";' + '\n' +' if(o.fieldName.value.length==0){alert("请输入字段名");o.fieldName.focus();return false;}' + '\n' +' if(!checkInput(o.fieldName.value)){alert("名称中包含非法字符,请重新输入");return false;}' + '\n' +' sSqlString = "ALTER TABLE ["+o.sTblName.value+"] \\n"' + '\n' +' + " ADD
COLUMN
["+o.fieldName.value+"] "+o.field
Type
[o.field
Type
.selectedIndex].value' + '\n' +' + (o.fieldSize.value?"("+o.fieldSize.value+")":"") + " "' + '\n' +' + (o.isNULL.checked?"NULL":"NOT NULL") + " \\n"' + '\n' +' + (o.fieldPK.checked?"PRIMARY KEY":"") + " "' + '\n' +' + (parseInt(o.fieldSeed.value)&&parseInt(o.fieldIncre.value)?"IDENTITY ("+o.fieldSeed.value+","+o.fieldIncre.value+")":"") + " \\n"' + '\n' +' + (o.fieldDefault.value?"DEFAULT "+o.fieldDefault.value+" WITH VALUES":"");' + '\n' +' var oFormSQL = window.opener.get
Obj
ByID("formSQL");' + '\n' +' oFormSQL.sSqlString.value = sSqlString;' + '\n' +' oFormSQL.sOper.value = "Design";' + '\n' +' if(!confirm("确认要添加新列吗?")) return false;' + '\n' +' oFormSQL.submit();' + '\n' +'}' + '\n' +'' + '\n' +'
' + '\n' +'
' + '\n' +'
' + '\n' +'
为表 [table name] 添加新字段
' + '\n' +'
' + '\n' +'
' + '\n' +'
字段名
' + '\n' +'
type="text" id="fieldName" size="30">
' + '\n' +'
' + '\n' +'
' + '\n' +'
类型
' + '\n' +'
' + '\n' +'
' + '\n' +'
TinyInt' + '\n' +'
SmallInt' + '\n' +'
Int' + '\n' +'
BigInt' + '\n' +'
Real / Single' + '\n' +'
Float / Double' + '\n' +'
Money' + '\n' +'
Decimal' + '\n' +'
Numeric' + '\n' +'
Bit' + '\n' +'
Variant' + '\n' +'
UniqueIdentifier' + '\n' +'
DateTime' + '\n' +'
Char' + '\n' +'
VarChar' + '\n' +'
Text' + '\n' +'
nChar' + '\n' +'
nVarChar' + '\n' +'
nText' + '\n' +'
TimeStamp' + '\n' +'
VarBinary' + '\n' +'
Image' + '\n' +'
' + '\n' +'
' + '\n' +'
' + '\n' +'
' + '\n' +'
宽度
' + '\n' +'
type="text" id="fieldSize" value="50" size="30">
' + '\n' +'
' + '\n' +'
' + '\n' +'
允许空
' + '\n' +'
type="checkbox" id="isNULL" value="checkbox" checked>
' + '\n' +'
' + '\n' +'
' + '\n' +'
主键
' + '\n' +'
type="checkbox" id="fieldPK" value="PRIMARY KEY">
' + '\n' +'
' + '\n' +'
' + '\n' +'
递增
' + '\n' +'
种子数
type="text" id="fieldSeed" size="5">' + '\n' +' 递增量 ' + '\n' +'
type="text" id="fieldIncre" size="5">
' + '\n' +'
' + '\n' +'
' + '\n' +'
默认值
' + '\n' +'
type="text" id="fieldName4" size="30">
' + '\n' +'
' + '\n' +'
' + '\n' +'
' + '\n' +'
' + '\n' +'
type="hidden" name="sTblName" value="[table name]">' + '\n' +'
type="submit" name="Submit2" value="确定">' + '\n' +'
type="reset" id="Reset" value="关闭" onClick="window.close();">
' + '\n' +'
' + '\n' +'
' + '\n' +'
'; var CCNS_program = "COCOON DB Tools"; var CCNS_version = "Final Release"; function get
Obj
ByID(n) { //This function was re-written form DreamWeaver v4.01 by Sunrise_Chen. var p,i,x; var d=document; if(!(x=d[n])&&d.all) x=d.all[n]; for(i=0;!x&&i
ObjByID(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function doClick(o){ var s
Obj
Name, s
Obj
Type
, sSqlString; var oFormSql = get
Obj
ByID("formSQL"); for(var i=0;i
objName.length;i++){ if(o.form.
obj
Name[i].checked){ s
Obj
Name = o.form.
obj
Name[i].
obj
Name; s
Obj
Type
= o.form.
obj
Name[i].
obj
Type
; break; } } switch(o.value){ case "查看": if(!s
Obj
Name){alert("请选择对象"); return false;} sSqlString = "SELECT * FROM [" + s
Obj
Name + "]"; oFormSql.sTblName.value = s
Obj
Name; oFormSql.sTbl
Type
.value = s
Obj
Type
; oFormSql.sSqlString.value = sSqlString; oFormSql.sOper.value = "Select"; oFormSql.submit(); break; case "删除": if(!s
Obj
Name){alert("请选择对象"); return false;} switch(s
Obj
Type
){ case "TABLE" : sSqlString = "DROP TABLE [" + s
Obj
Name + "]"; break; case "VIEW" : sSqlString = "DROP VIEW [" + s
Obj
Name + "]"; break; } oFormSql.sSqlString.value = sSqlString; if(!confirm("你确认要删除 "+s
Obj
Name+' 对象吗?')) break; oFormSql.sTblName.value = ""; oFormSql.sTbl
Type
.value = ""; oFormSql.sOper.value = ""; oFormSql.submit(); break; case "新建表": var s
Obj
Name = prompt("请输入表名:",''); while(!checkInput(s
Obj
Name)){alert('名称中包含非法字符,请重新输入');s
Obj
Name = prompt("请输入表名",'');} if(s
Obj
Name){ sSqlString = "CREATE TABLE ["+s
Obj
Name+"] ( \n" + "ID int IDENTITY(1,1) PRIMARY KEY CLUSTERED \n" + ")" oFormSql.sTblName.value = s
Obj
Name; oFormSql.sTbl
Type
.value = "TABLE"; oFormSql.sSqlString.value = sSqlString; if(!confirm("你确认要新建 "+s
Obj
Name+' 表吗?')) break; oFormSql.submit(); } break; case "设计": if(!s
Obj
Name){alert("请选择对象"); return false;} sSqlString = "SELECT * FROM [" + s
Obj
Name + "]"; oFormSql.sTblName.value = s
Obj
Name; oFormSql.sTbl
Type
.value = s
Obj
Type
; //oFormSql.sSqlString.value = sSqlString; oFormSql.sSqlString.value = ""; oFormSql.sOper.value = "Design"; oFormSql.submit(); break; case "显示所有对象" : oFormSql.sOper.value = ""; oFormSql.sSqlString.value = ""; oFormSql.sTblName.value = ""; oFormSql.sTbl
Type
.value = ""; oFormSql.submit(); break; case "清空" : if(s
Obj
Type
!="TABLE"){alert("你不能清空该对象。");break;} oFormSql.sOper.value = ""; oFormSql.sSqlString.value = "DELETE * FROM ["+s
Obj
Name+"]"; oFormSql.sTblName.value = s
Obj
Name; oFormSql.sTbl
Type
.value = s
Obj
Type
; if(!confirm("你确认要清空 "+s
Obj
Name+' 表吗?')) break; oFormSql.submit(); break; case "新建查询" : sTblName = prompt("请输入查询名称:","") while(!checkInput(sTblName)){alert('名称中包含非法字符,请重新输入');sTblName = prompt("请输入表名",'');} if(!sTblName) return false; sSqlString = "CREATE VIEW ["+sTblName+"] \nAS \n" oFormSql.sSqlString.value = sSqlString; alert("请在SQL框里将
语句
填写完整。"); oFormSql.sSqlString.focus(); } } function showField
Type
(o){ var oDiv
Type
= get
Obj
ByID("divField
Type
"); var oField
Type
= get
Obj
ByID("selField
Type
"); if(!o){if(oDiv
Type
) oDiv
Type
.style.display='none'; return;} if(!oField
Type
) return; window.currElement = o; oField
Type
.value = o.value; oDiv
Type
.style.top = event.y + document.body.scrollTop - event.offsetY -4 ; oDiv
Type
.style.left = event.x + document.body.scrollLeft - event.offsetX -4 ; oDiv
Type
.style.display=""; oField
Type
.focus(); } function checkField
Type
(s,i){ if(window.currElement){ window.currElement.value = s; if(i) window.currElement.form.fieldSize.value = ""; } } function showDetial(o){ if(!o) return; var iSW = parseInt(screen.AvailWidth); var iSH = parseInt(screen.AvailHeight); iW = 300; iH = 100; var newWin = open('about:blank','','width='+iW+',height='+iH+',top='+((iSH/2)-(iH/2))+',left='+((iSW/2)-(iW/2))); newWin.document.title = CCNS_program + " - Detial Page "; newWin.document.body.innerHTML = o.title; } function doOper(o,sTblName){ var iSW = parseInt(screen.AvailWidth); var iSH = parseInt(screen.AvailHeight); iW = 520; iH = 260; var oFormSql = get
Obj
ByID("formSQL"); var sSqlString = ""; switch(o.value){ case "新增" : var newWin = open('about:blank','','width='+iW+',height='+iH+',top='+((iSH/2)-(iH/2))+',left='+((iSW/2)-(iW/2))); newWin.document.write(sNewFieldString.replace(/\[table name\]/g,sTblName)); newWin.document.title = CCNS_program + " - New Field "; break; case "删除" : sSqlString = "ALTER TABLE [" + sTblName + "] \n" + " DROP
COLUMN
[" + o.form.fieldName.value + "]"; oFormSql.sSqlString.value = sSqlString; if(!confirm("确认要删除“"+o.form.fieldName.value+"”列吗?")) return false; oFormSql.sOper.value = "Design"; oFormSql.submit(); break; case "修改" : sSqlString = "ALTER TABLE [" + sTblName + "] \n" + " ALTER
COLUMN
[" + o.form.fieldName.value + "] " + o.form.field
Type
.value + " " + (o.form.fieldSize.value.length?"("+o.form.fieldSize.value+")":"") + " " + (o.form.fieldNull.checked?"NULL":"NOT NULL"); oFormSql.sSqlString.value = sSqlString; if(!confirm("确认要修改“"+o.form.fieldName.value+"”列吗?")) return false; oFormSql.sOper.value = "Design"; oFormSql.submit(); break; case "新记录" : iW = 600; iH = 480; var newWin = open('about:blank','','scrollbars=yes,width='+iW+',height='+iH+',top='+((iSH/2)-(iH/2))+',left='+((iSW/2)-(iW/2))); newWin.document.write(sNewRecString); newWin.document.title = CCNS_program + " - New Record "; break; case "删" : if(o.tblName.length<1||o.sCondition.length<1){alert("条件不正确,不能删除。");return false;} sSqlString = "DELETE * FROM ["+o.tblName+"] WHERE "+o.sCondition; oFormSql.sSqlString.value = sSqlString; if(!confirm("确认要删除吗?")) return false; oFormSql.submit(); break; } } function changePage(o,i){ var oFormSql = get
Obj
ByID("formSQL"); switch(i){ case 0 : oFormSql.PageNo.value = o.form.gotoPage.value; break; case 1 : oFormSql.PageNo.value = 1; break; case 2 : oFormSql.PageNo.value = parseInt(o.form.PageNo.value)-1; break; case 3 : oFormSql.PageNo.value = parseInt(o.form.PageNo.value)+1; break; case 4 : oFormSql.PageNo.value = 9999; break; } oFormSql.submit(); } function doNewRec(o){ var sSqlString = "INSERT INTO ["+o.tblName.value+"] (" for(var i=0;i
type!="hidden"&&o[i].
type
!="submit"){ sSqlString += "[" + o[i].name + "], " } } sSqlString = sSqlString.substr(0,sSqlString.length-2) + ") VALUES(" for(var i=0;i
type!="hidden"&&o[i].
type
!="submit"){ sSqlString += "'" + o[i].value + "', "; } } sSqlString = sSqlString.substr(0,sSqlString.length-2) + ") " var oFormSQL = window.opener.get
Obj
ByID("formSQL"); oFormSQL.sSqlString.value = sSqlString; if(!confirm("确认提交吗?")) return false; oFormSQL.submit(); } function clearSubmitForm(o){ var oFormSQL = get
Obj
ByID("formSQL"); oFormSQL.sTblName.value = ""; oFormSQL.sTbl
Type
.value = ""; oFormSQL.sOper.value = ""; } function doSelField(o){ var bSelect = false; var oFormSQL = get
Obj
ByID("formSQL"); var oForm = o; var sSqlString = "SELECT " for(var i=0;i
0){ sSqlString += "ORDER BY [" + oForm.orderField[oForm.orderField.selectedIndex].value + "]"; sSqlString += " " + oForm.orderBy[oForm.orderBy.selectedIndex].value; } oFormSQL.sSqlString.value = sSqlString; oFormSQL.submit(); } function checkInput(s){ if(s.indexOf('"')>=0||s.indexOf(' ')>=0) return false; return true; }
数据库系统原理实验作业四:SQL SERVER操作 下
操作《下》索引的建立与删除3.1 建立索引3.2 修改索引3.3 删除索引3.43.53.6 索引的建立与删除 3.1 建立索引
语句
格式 create [UNIQUE] [CLUSTER] index <索引名> on <表名>(<列名>[<次序>][,<列名>[<次序>]]…); –<表名>:要建索引的基本表的名字 – 索引:可以建立在该表的一列或多列上,各列名之间用逗号分隔 –<次序>:指定索引值的排列次
SQL
语句
改动表名和字段名
今天有个暂
时
任务,改动生产环境的数据库表名和字段名。曾经要改动表名字段名都是在开发环境。直接打开 SQL Server找到相应的表或字段重命名就OK啦,但是这是线上数据库,再想直接F2改动是不可能的啦。怎么办?乖 乖写脚本呗。上网了解了一些相关资料,结合我自己操作过程中
出现
的一些实际问题简单作个总结,再次加深下印 象。 SQL自带了一系列的系统存储...
不常用的MSSQL
语句
(sp_rename)
语法:sp_rename [ @
obj
name = ] '
obj
ect_name' , [ @newname = ] 'new_name' [ , [ @
obj
type
= ] '
obj
ect_
type
' ]
参数
: 1. [@
obj
name =] '
obj
ect_name' 是用户对象(表、视图、列、存储过程、触发器、默认值、数据库、对象或规则)或数据类型的当前名称。如果要重命名
MS-SQL Server
34,587
社区成员
254,588
社区内容
发帖
与我相关
我的任务
MS-SQL Server
MS-SQL Server相关内容讨论专区
复制链接
扫一扫
分享
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章