Justin Cooney
Web Development Tips and Examples
Category: tSQL
-
A fairly common task is to add or remove user or group permissions to a SQL Server Stored Procedure, and also to maintain a list of database objects and the permissions associated with them. The syntax for these actions has remained fairly similar throughout the various versions of SQL Server, although SQL Server 200 and…
-
There are times when using the XML data type in Microsoft SQL Server can be of great help. For example the XML data type is very useful when you want to return data in a hierarchical structure rather than a simple tabular structure. There are several options for going about and returning XML from your queries…
-
It is often very useful to be able to query the SQL Server system tables to find data about stored procedures. Rather than running visual searches through the GUI or scripting the stored procedures, the fastest way to find what you are looking for is a direct query via SSMS (SQL Server Management Studio). Specifically,…
Justin Cooney 