為您找到相關(guān)結(jié)果46個(gè)
sql cast,convert,QUOTENAME,exec 函數(shù)學(xué)習(xí)記錄_MsSql_腳本之家
select*from[index] --這便有了QUOTENAME,即: print('select * from'+QUOTENAME(@tbname)) --結(jié)果:select * from [index] exec('select * from'+QUOTENAME(@tbname)) EXEC命令有兩個(gè)用法:執(zhí)行一個(gè)存儲(chǔ)過程,或者執(zhí)行一個(gè)動(dòng)態(tài)批次。批次是一個(gè)內(nèi)容為SQL語(yǔ)句的字符串。
www.dbjr.com.cn/article/206...htm 2025-6-9
SQL命令大全-中英文對(duì)照_MsSql_腳本之家
QUOTENAME() --函數(shù)返回被特定字符括起來的字符串 /*select quotename('abc', '{') quotename('abc') 運(yùn)行結(jié)果如下 ---{ {abc} [abc]*/ REPLICATE() --函數(shù)返回一個(gè)重復(fù)character_expression 指定次數(shù)的字符串 /*select replicate('abc', 3) replicate( 'abc', -2) 運(yùn)行結(jié)果如下 --- --- abcabc...
www.dbjr.com.cn/article/12820_a...htm 2025-6-9
SQLServer 表的索引碎片查詢和處理_MsSql_腳本之家
SELECT @objname= QUOTENAME(so.name) , @schemaname = QUOTENAME(ss.name) FROM sys.objects AS so JOIN sys.schemas AS ss ON ss.schema_id = so.schema_id WHERE so.object_id = @objectid; SELECT @idxname = QUOTENAME(name) FROM sys.indexes WHERE object_id = @objectid AND index_id = @...
www.dbjr.com.cn/article/2829...htm 2025-6-8
SQLServer行轉(zhuǎn)列實(shí)現(xiàn)思路記錄_MsSql_腳本之家
DECLARE @s NVARCHAR(4000) SELECT @s = ISNULL(@s + ',', '') + QUOTENAME(ScoreName) FROM (select distinct ScoreName from Score) as A ---列名不要重復(fù) Declare @sql NVARCHAR(4000) SET @sql=' select r.* from (select UID,Name,ScoreName,Score from Score,[User] where Score.UID=[User...
www.dbjr.com.cn/article/511...htm 2025-6-5
SQL字符串處理函數(shù)大全_MsSql_腳本之家
1、QUOTENAME() 返回被特定字符括起來的字符串。 QUOTENAME (<'character_expression'>[, quote_ character]) 其中quote_ character 標(biāo)明括字符串所用的字符,缺省值為“[]”。 2、REPLICATE() 返回一個(gè)重復(fù)character_expression 指定次數(shù)的字符串。 REPLICATE (character_expression integer_expression) 如果integer_exp...
www.dbjr.com.cn/article/433...htm 2025-5-16
查詢mysql中執(zhí)行效率低的sql語(yǔ)句的方法_Mysql_腳本之家
在MySQL下,在啟動(dòng)參數(shù)中設(shè)置 --log-slow-queries=[文件名],就可以在指定的日志文件中記錄執(zhí)行時(shí)間超過long_query_time(缺省為10秒)的SQL語(yǔ)句。你也可以在啟動(dòng)配置文件中修改long query的時(shí)間,如: 復(fù)制代碼代碼如下: # Set long query time to 8 seconds ...
www.dbjr.com.cn/article/347...htm 2025-6-9
sqlserver中在指定數(shù)據(jù)庫(kù)的所有表的所有列中搜索給定的值_MsSql_腳本...
SET @SQL = 'select *, ' + QUOTENAME(@Table_Schema,''') + 'as [Table Schema], ' + QUOTENAME(@Table_Name,''') + ' as [Table Name]' + ' from (select '+ @PkColumn + ' as [PK Column], ' + @Cols + ' from ' + QUOTENAME(@Table_Name) + ' ...
www.dbjr.com.cn/article/283...htm 2025-6-7
sqlserver 行列互轉(zhuǎn)實(shí)現(xiàn)小結(jié)_MsSql_腳本之家
Select @s=@s+','+quotename([Course])+'=max(case when [Course]='+quotename([Course],''')+' then [Score] else 0 end)' from Class group by[Course] exec('select [Student]'+@s+' from Class group by [Student]') 生成靜態(tài): select...
www.dbjr.com.cn/article/230...htm 2025-5-26
SQL2005重新生成索引的的存儲(chǔ)過程 sp_rebuild_index[原創(chuàng)]_mssql2005...
,N'重新生成索引:'+quotename(object_schema_name(a.object_id))+'.'+quotename(object_name(a.object_id))+'.'+quotename(a.name)as[str] fromsys.indexes a innerjoinsys.dm_db_index_physical_stats(db_id(),null,null,null,null) bonb.object_id=a.object_id ...
www.dbjr.com.cn/article/815...htm 2025-5-16