SQL Server
早起的菜鸟wzt
这个作者很懒,什么都没留下…
展开
-
SQL Server data patching模板
DECLARE @SVOC_HIS_FULL_TBL_NM NVARCHAR(128);DECLARE @SVOC_TBL_OWNER NVARCHAR(10);DECLARE @SVOC_CUR_FULL_TBL_NM NVARCHAR(128);DECLARE @RERUN_DT NVARCHAR(10);DECLARE @NEW_EFF_DT NVARCHAR(100);DECLARE @JOIN_STMT原创 2021-07-15 10:54:08 · 121 阅读 · 0 评论 -
SQL Server 生成oracle建表语句
declare @TABLESPACE nvarchar(100)= 'oracle tablespace'declare @SCHEMA nvarchar(100)= 'oracle schema'declare @PRE nvarchar(100)= 'table prefix'declare @role nvarchar(100)= 'grant role name'declare @TABLENAME nvarchar(100)= 'sql server table_name'SE原创 2021-07-14 11:57:49 · 378 阅读 · 2 评论 -
SQL Server 现有表建立分区表
查看表分区SELECT o.name objectname,i.name indexname, partition_id, partition_number, [rows] FROM sys.partitions p INNER JOIN sys.objects o ON o.object_id=p.object_id INNER JOIN sys.indexes i ON i.object_id=p.object_id and p.index_id=i.index_id WHERE o.nam原创 2021-07-14 11:55:43 · 438 阅读 · 0 评论 -
SQL Server 表重命名
–表重命名sp_rename 'schema_name.old_table_name', 'new_table_name';原创 2021-07-14 11:34:20 · 977 阅读 · 0 评论 -
SQL Server 查看表结构
SQL Server 查看表结构SELECT distinct TABLE_NAME=d.name, COLUMN_NAME=A.name, DATA_TYPE = B.name, CHAR_LENGTH=A.length, DATA_PRECISION=A.xprec, DATA_SCALE=A.xscale, NULLABLE = Case When A.isnullable=1 Then 'NULL' Else 'NOTNULL' End, PRIMARY_原创 2021-07-14 11:32:43 · 834 阅读 · 0 评论