Justin Cooney
Web Development Tips and Examples
Category: SQL Tips
-
Sometimes while developing a tool, a developer needs to pass a list of values with a variable size to their database. There are several ways of doing so, one of which involves passing the list in XML format. The introduction of SQL Server 2005 offered the use of XML datatypes, which had not existed in…
-
Sometimes using the SSMS GUI table designer is a hassle when compared with directly querying the table structure using a simple SQL statement. For example if you are right in the middle of editing a stored procedure and want to know the data types and sizes of some columns for a table or two, then…
-
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…
Justin Cooney 