What are the advantages and disadvantages of using the nvarchar(max) vs. NText data types in SQL Server? I don’t need backward compatibility, so it is fine that nvarchar(max) isn’t supported in older SQL Server releases. Edit: Apparently the question also applies to TEXT and IMAGE vs. varchar(max) and varbinary(max), for those searching for those data-types … Read more
I am trying to execute this query: declare @tablename varchar(50) set @tablename=”test” select * from @tablename This produces the following error: Msg 1087, Level 16, State 1, Line 5 Must declare the table variable “@tablename”. What’s the right way to have the table name populated dynamically? 10 Answers 10
I have a table and one of the columns is “Date” of type datetime. We decided to add a default constraint to that column Alter table TableName alter column dbo.TableName.Date default getutcdate() but this gives me error: Incorrect syntax near ‘.’ Does anyone see anything obviously wrong here, which I am missing (other than having … Read more
I have been getting an error message that I can’t resolve. It originates from Visual Studio or the debugger. I’m not sure whether the ultimate error condition is in VS, the debugger, my program, or the database. This is a Windows app. Not a web app. First message from VS is a popup box saying: … Read more
How can we check which database locks are applied on which rows against a query batch? Any tool that highlights table row level locking in real time? DB: SQL Server 2005 7 Answers 7
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to … Read more
I’ve noticed that Visual Studio 2008 is placing square brackets around column names in sql. Do the brackets offer any advantage? When I hand code T-SQL I’ve never bothered with them. Example: Visual Studio: SELECT [column1], [column2] etc… My own way: SELECT column1, column2 etc… 10 Answers 10
In PostgreSQL there is the Limit and Offset keywords which will allow very easy pagination of result sets. What is the equivalent syntax for SQL Server? 17 Answers 17
I have a table and, somehow, the same person got into my Person table twice. Right now, the primary key is just an autonumber but there are two other fields that exist that I want to force to be unique. For example, the fields are: ID Name Active PersonNumber I only want 1 record with … Read more
Does anyone know how I can copy a SQL Azure database to my development machine? I’d like to stop paying to have a development database in the cloud, but it’s the best way to get production data. I copy my production database to a new development database but I’d like to have that same database … Read more
