砼浇注施工高处坠落预防专项措施.docx
《砼浇注施工高处坠落预防专项措施.docx》由会员分享,可在线阅读,更多相关《砼浇注施工高处坠落预防专项措施.docx(20页珍藏版)》请在冰豆网上搜索。
砼浇注施工高处坠落预防专项措施
=quotename(@table_owner)
end
else
begin
SELECT@full_table_name=quotename(@table_owner)+
'.'+quotename(@table_name)
end
end
/*GetObjectID*/
SELECT@table_id=object_id(@full_table_name)
select
TABLE_QUALIFIER=convert(sysname,db_name()),
TABLE_OWNER=convert(sysname,user_name(o.uid)),
TABLE_NAME=convert(sysname,o.name),
COLUMN_NAME=convert(sysname,c.name),
KEY_SEQ=
case
whenc.name=index_col(@full_table_name,i.indid,1)thenconvert(smallint,1)
whenc.name=index_col(@full_table_name,i.indid,2)thenconvert(smallint,2)
whenc.name=index_col(@full_table_name,i.indid,3)thenconvert(smallint,3)
whenc.name=index_col(@full_table_name,i.indid,4)thenconvert(smallint,4)
whenc.name=index_col(@full_table_name,i.indid,5)thenconvert(smallint,5)
whenc.name=index_col(@full_table_name,i.indid,6)thenconvert(smallint,6)
whenc.name=index_col(@full_table_name,i.indid,7)thenconvert(smallint,7)
whenc.name=index_col(@full_table_name,i.indid,8)thenconvert(smallint,8)
whenc.name=index_col(@full_table_name,i.indid,9)thenconvert(smallint,9)
whenc.name=index_col(@full_table_name,i.indid,10)thenconvert(smallint,10)
whenc.name=index_col(@full_table_name,i.indid,11)thenconvert(smallint,11)
whenc.name=index_col(@full_table_name,i.indid,12)thenconvert(smallint,12)
whenc.name=index_col(@full_table_name,i.indid,13)thenconvert(smallint,13)
whenc.name=index_col(@full_table_name,i.indid,14)thenconvert(smallint,14)
whenc.name=index_col(@full_table_name,i.indid,15)thenconvert(smallint,15)
whenc.name=index_col(@full_table_name,i.indid,16)thenconvert(smallint,16)
end,
PK_NAME=convert(sysname,i.name)
from
sysindexesi,syscolumnsc,sysobjectso--,syscolumnsc1
where
o.id=@table_id
ando.id=c.id
ando.id=i.id
and(i.status&0x800)=0x800
and(c.name=index_col(@full_table_name,i.indid,1)or
c.name=index_col(@full_table_name,i.indid,2)or
c.name=index_col(@full_table_name,i.indid,3)or
c.name=index_col(@full_table_name,i.indid,4)or
c.name=index_col(@full_table_name,i.indid,5)or
c.name=index_col(@full_table_name,i.indid,6)or
c.name=index_col(@full_table_name,i.indid,7)or
c.name=index_col(@full_table_name,i.indid,8)or
c.name=index_col(@full_table_name,i.indid,9)or
c.name=index_col(@full_table_name,i.indid,10)or
c.name=index_col(@full_table_name,i.indid,11)or
c.name=index_col(@full_table_name,i.indid,12)or
c.name=index_col(@full_table_name,i.indid,13)or
c.name=index_col(@full_table_name,i.indid,14)or
c.name=index_col(@full_table_name,i.indid,15)or
c.name=index_col(@full_table_name,i.indid,16)
)
orderby1,2,3,5
go
grantexecuteonsp_pkeystopublic
go
dumptranmasterwithno_log
go
print'creatingsp_server_info'
go
createprocsp_server_info(
@attribute_idint=null)
as
if@attribute_idisnotnull
select*
frommaster.dbo.spt_server_info
whereattribute_id=@attribute_id
else
select*
frommaster.dbo.spt_server_info
orderbyattribute_id
go
grantexecuteonsp_server_infotopublic
go
dumptranmasterwithno_log
go
print'creatingsp_special_columns'
go
/*Procedureforpre-6.0server*/
CREATEPROCEDUREsp_special_columns(
@table_namevarchar(32),
@table_ownervarchar(32)=null,
@table_qualifiervarchar(32)=null,
@col_typechar
(1)='R',
@scopechar
(1)='T',
@nullablechar
(1)='U',
@ODBCVerint=2)
AS
DECLARE@indidint
DECLARE@table_idint
DECLARE@full_table_namevarchar(65)/*2*32+1*/
DECLARE@scopeoutsmallint
if@col_typenotin('R','V')or@col_typeisnull
begin
raiserror20002'~~Rush_42~~'
return
end
if@scope='C'
select@scopeout=0
elseif@scope='T'
select@scopeout=1
else
begin
raiserror20002'~~Rush_43~~'
return
end
if@nullablenotin('U','O')or@nullableisnull
begin
raiserror20002'~~Rush_44~~'
return
end
if@table_qualifierisnotnull
begin
ifdb_name()<>@table_qualifier
begin/*Ifqualifierdoesn'tmatchcurrentdatabase*/
raiserror20001'~~Rush_5~~'
return
end
end
if@table_ownerisnull
begin/*Ifunqualifiedtablename*/
SELECT@full_table_name=@table_name
end
else
begin/*Qualifiedtablename*/
SELECT@full_table_name=@table_owner+'.'+@table_name
end
/*GetObjectID*/
SELECT@table_id=object_id(@full_table_name)
if@col_type='V'
BEGIN/*ifROWVER,justrunthatquery*/
SELECT
SCOPE=convert(smallint,NULL),
COLUMN_NAME=convert(varchar(32),c.name),
DATA_TYPE=convert(smallint,-3),
TYPE_NAME=t.name,
"PRECISION"=convert(int,8),
LENGTH=convert(int,8),
SCALE=convert(smallint,NULL),
PSEUDO_COLUMN=convert(smallint,1)
FROM
systypest,syscolumnsc
WHERE
c.id=@table_id
ANDc.usertype=80/*TIMESTAMP*/
ANDt.usertype=80/*TIMESTAMP*/
RETURN
END
/*ROWID,nowfindtheidofthe'best'indexforthistable*/
IF@nullable='O'/*Don'tincludeanyindexesthatcontain
nullablecolumns.*/
SELECT@indid=MIN(indid)
FROMsysindexesi,syscolumnsc,syscolumnsc2
WHERE
i.status&2=2/*IfUniqueIndex*/
ANDc.id=i.id
ANDc2.id=c.id
ANDc2.colidANDi.id=@table_id
ANDindid>0/*EliminateTableRow*/
ANDc.name=index_col(@table_name,i.indid,c2.colid)
GROUPBYindidHAVINGSUM(c.status&8)=0
ELSE/*Includeindexesthatarepartiallynullable.*/
SELECT@indid=MIN(indid)
FROMsysindexesi
WHERE
status&2=2/*IfUniqueIndex*/
ANDid=@table_id
ANDindid>0/*EliminateTableRow*/
SELECT
SCOPE=@scopeout,
COLUMN_NAME=convert(varchar(32),INDEX_COL(@full_table_name,indid,c2.colid)),
d.DATA_TYPE,
TYPE_NAME=t.name,
"PRECISION"=isnull(d.data_precision,convert(int,c.length)),
LENGTH=isnull(d.length,convert(int,c.length)),
SCALE=d.numeric_scale,
PSEUDO_COLUMN=convert(smallint,1)
FROM
sysindexesx,
syscolumnsc,
master.dbo.spt_datatype_infod,
systypest,
syscolumnsc2/*Self-jointogeneratelistofindexcolumnsand*/
/*toextractdatatypenames*/
WHERE
x.id=@table_id
ANDc.name=INDEX_COL(@full_table_name,@indid,c2.colid)
ANDc.id=x.id
ANDc2.id=x.id
ANDc2.colidANDx.indid=@indid
ANDt.type=d.ss_dtype
ANDc.length=d.fixlen
ANDc.usertype=t.usertype
go
if(charindex('6.00',@@version)=0and
charindex('6.50',@@version)=0and
charindex('7.00',@@version)=0and
charindex('8.00',@@version)=0)
begin
print''
print''
print'Warning:
'
print'youareinstallingthestoredprocedures'
print'onapre6.0SQLServer.'
print'Ignorethefollowingerrors.'
end
else
dropprocsp_special_columns
go
/*Procedurefor6.0and6.50servers*/
CREATEPROCEDUREsp_special_columns(
@table_namevarchar(32),
@table_ownervarchar(32)=null,
@table_qualifiervarchar(32)=null,
@col_typechar
(1)='R',
@scopechar
(1)='T',
@nullablechar
(1)='U',
@ODBCVerint=2)
AS
DECLARE@indidint
DECLARE@table_idint
DECLARE@full_table_namevarchar(65)/*2*32+1*/
DECLARE@scopeoutsmallint
if@col_typenotin('R','V')or@col_typeisnull
begin
raiserror(15251,-1,-1,'col_type','''R''or''V''')
return
end
if@scope='C'
select@scopeout=0
elseif@scope='T'
select@scopeout=1
else
begin
raiserror(15251,-1,-1,'scope','''C''or''T''')
return
end
if@nullablenotin('U','O')or@nullableisnull
begin
raiserror(15251,-1,-1,'nullable','''U''or''O''')
return
end
if@table_qualifierisnotnull
begin
ifdb_name()<>@table_qualifier
begin/*Ifqualifierdoesn'tmatchcurrentdatabase*/
raiserror(15250,-1,-1)
return
end
end
if@table_ownerisnull
begin/*Ifunqualifiedtablename*/
SELECT@full_table_name=@table_name
end
else
begin/*Qualifiedtablename*/
SELECT@full_table_name=@table_owner+'.'+@table_name
end
/*GetObjectID*/
SELECT@table_id=object_id(@full_table_name)
if@col_type='V'
BEGIN/*ifROWVER,justrunthatquery*/
SELECT
SCOPE=convert(smallint,NULL),
COLUMN_NAME=convert(varchar(32),c.name),
DATA_TYPE=convert(smallint,-2),
TYPE_NAME=t.name,
"PRECISION"=convert(int,8),
LENGTH=convert(int,8),
SCALE=convert(smallint,NULL),
PSEUDO_COLUMN=convert(smallint,1)
FROM
systypest,syscolumnsc
WHERE
c.id=@table_id
ANDc.usertype=80/*TIMESTAMP*/
ANDt.usertype=80/*TIMESTAMP*/
RETURN
END
/*ROWID,nowfindtheidofthe'best'indexforthistable*/
IF@nullable='O'/*Don'tincludeanyindexesthatcontain
nullablecolumns.*/
SELECT@indid=MIN(indid)
FROMsysindexesi,syscolumnsc,syscolumnsc2
WHERE
i.status&2=2/*IfUniqueIndex*/
ANDc.id=i.id
ANDc2.id=c.id
ANDc2.colidANDi.id=@table_id
ANDindid>0/*EliminateTableRow*/
ANDc.name=index_col(@table_name,i.indid,c2.colid)
GROUPBYindidHAVINGSUM(c.status&8)=0
ELSE/*Includeindexesthatarepartiallynullable.*/
SELECT@indid=MIN(indid)
FROMsysindexesi
WHERE
status&2=2/*IfUniqueIndex*/
ANDid=@table_id
ANDindid>0/*EliminateTableRow*/
SELECT
SCOPE=@scopeout,
COLUMN_NAME=convert(varchar(32),INDEX_COL(@full_table_name,indid,c2.colid)),
d.DATA_TYPE,
convert(varchar(32),case
when(t.usertype>100ort.usertypein(18,80))
thent.name
elsed.TYPE_NAME
end)TYPE_NAME,
convert(int,case
whend.DATA_TYPEin(6,7)thend.data_precision/*FLOAT/REAL*/
elseisnull(convert(int,c.prec),2147483647)
end)"PRECISION",
co