![]() ![]() List of sysobjects. There is only one different, type K (primary key or UNIQUE constraint) is in xtype splitted to PK (primary key) and UQ (UNIQUE contraint). List of possible objects of sysobjects.type and sysobjects.xtype is bellow and is very similar. Then change where condition, add sysobjects.type in association to used xtypes. Then you need change case condition, and add other xtypes you want to use. You can use also other objects for searching. If you want exclude some results with specify text, you can use variable. When sysobjects.xtype = 'TR' then 'Trigger'ĪND you can assign any text you need search. When sysobjects.xtype = 'TF' then 'Function' I have a database which (For whatever reason) has a column containing pipe delimited data.I want to parse this data quickly, so I've thought of converting this column (nvarchar) into an XML by. SELECT DISTINCT sysobjects.name AS ,Ĭase when sysobjects.xtype = 'P' then 'Stored Proc' This example show you how to search in triggers and store procedures. ![]() There is code for searching in xtype objects, that contains body of triggers, store procedures and other objects inside MS SQL database. If you want search text not only in name of triggers and store procedures, using search object in query analyzer is not enough and in MS SQL 2005 there isn't any search object function. I do something like: if Result<>200 then begin lpdwBufferLength:1 SetLength (Response.If it is 200 all is ok if not I want to get the statustext. After posting the data I read the result. Hello, I use wininet to post and get data from my webservice. Search text in Triggers and Store Prodedures Details HttpQueryInfo with HTTPQUERYSTATUSTEXT truncate result.
0 Comments
Leave a Reply. |