Justin Cooney
Web Development Tips and Examples
Category: SQL
-
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…
-
If you are working with XML data types in your .NET and SQL Server code, then you will most likely encounter this error message at some point. Specifically, this error is related to improperly passing an XML value as a SQLParameter to your database. Since most of the work one does with XML in .NET…
Justin Cooney 