摘要：
CREATETABLEtb(idINT,valueVARCHAR(10))INSERTINTOtbVALUES(1,'aa')INSERTINTOtbVALUES(1,'bb')INSERTINTOtbVALUES(2,'aaa')INSERTINTOtbVALUES(2,'bbb')INSERTINTOtbVALUES(2,'ccc')goCREATEFUNCTIONdbo.f_str(@idI... 阅读全文
摘要：
--创建表ifexists(select*fromsysobjectswhereid=OBJECT_ID('[TempTable_Base]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[TempTable_Base]CREATETABLE[TempTable_Base]([id][int]IDENTITY(1,1)NOTNULL,[guid][... 阅读全文
摘要：
CREATETABLEProduct(ProductIDVARCHAR(7)NOTNULLPRIMARYKEY,ProductNameVARCHAR(100)NOTNULL,ageintDEFAULT0);INSERTINTOProductVALUES('11','周杰伦',50),('12','周星驰',30);--目标表CREATETABLEProductNew(ProductIDVARCHA... 阅读全文
摘要：
DECLARE@xXMLSELECT@x='<Peoples><PeopleNAME="周星驰"/><PeopleNAME="刘德华"/><PeopleNAME="周杰伦"/></Peoples>'SELECT@X.query('(/Peoples)')/*<Peoples><PeopleNAME="周星驰"/>&... 阅读全文
