2. How do I get the row size of the table?
For #2, as long as you don't have BLOB columns, you'd want something along the lines of:
WHERE id = (SELECT id FROM sysobjects
WHERE xtype = 'U'
AND name = 'TableName')
View questions and answers from all of our SQL Server experts here.
Dig Deeper on SQL Server Database Modeling and Design
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...continue reading
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.