C#.Net, WPF Space
Sunday, July 10, 2011
Find Which Stored Procedures are using a column in SQL Server
Use below query to find out which stored procedures are using a particular column in SQL Server.
SELECT
OBJECT_NAME
(
id
)
FROM
syscomments
WHERE
[text]
LIKE
'%ColumnName%'
AND
OBJECTPROPERTY
(
id
,
'IsProcedure'
)
=
1
GROUP
BY
OBJECT_NAME
(
id
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Type based templating
<DataTemplate DataType="{x:Type vm:SampleViewModel}"> <DataTemplate.Resources> ...
Execute Command on ComboBox Selection changed
If you are developing WPF application MVVM way you might have noticed that Button Provide a Command property that can be set to a ICommand...
Wire any WPF Event to Command on ViewModel in MVVM
In the last post I explained how to write a behaviour to hook a commmand to an event. That works well but a new behaviour is needed to wr...
IsPressed Trigger on any WPF control
WPF provides IsPressed Property on button that can be used to write triggers based on its value. There is no such propery available on other...
No comments:
Post a Comment