The only viable solution in my opinion is to use an ID INT IDENTITY(1,1) column to get SQL Server to handle the automatic increment of your numeric value a computed, persisted column to convert that numeric value to the value you need So try this: CREATE TABLE dbo.tblUsers (ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY … Read more
Use Configuration.cs file to set custom time out: internal sealed class Configuration : DbMigrationsConfiguration<ApplicationDbContext> { public Configuration() { AutomaticMigrationsEnabled = false; ContextKey = “YourDbContext”; // New timeout in seconds this.CommandTimeout = 60 * 5; } }
Here is my own answer to this question (Please also see the update at the end): No, there isn’t such unary operator defined on the String expressions. It is possible that this is a bug. Explanation: The given statement is valid and it generates the below result: (No column name) —————- ABCDEF (1 row(s) affected) … Read more
Table parameters are readonly. You cannot select into them. Use Table-Valued Parameters: Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine. And Table-Valued Parameters: You cannot return data in a table-valued … Read more
Simplest option is to create a DataTable in C# code and pass it as a parameter to your procedure. Assuming that you have created a User Defined Table Type as: CREATE TYPE [dbo].[userdefinedtabletype] AS TABLE( [ID] [varchar](255) NULL, [Name] [varchar](255) NULL ) then in your C# code you would do: DataTable dt = new DataTable(); … Read more
Ok, after 6 hours of struggle and ‘googling’ I could finally get this work. The problem was due to some account name conflict. Here are the steps I followed to set it right 1) Un-installed the SQLserver 3) Re-installed it back with following changes In the server configuration section, I changed the account name details … Read more
Since you are on SQL Server 2012… here is a version that uses that. It might be faster than other solutions but you have to test that on your data. sum() over() will do a running sum ordered by Id adding 1 when there are a value in the column and keeping the current value … Read more
You can’t do this through the wizard, because there are a couple of bugs. Even if I chose not to track changes and not to populate the index when it was finished, I still got an error about SQL Agent: Cannot load ‘Select or Create Population Schedules’ Full-Text Wizard form. SQL Server Agent is not … Read more
You are trying to restore a SQL Server 2000 database on SQL Server 2012. This is not supported. You will need to restore your database on an instance of SQL Server 2005, 2008 or 2008 R2 first, then back it up from there, then restore the new backup on SQL Server 2012. Microsoft explains this … Read more
When using XML in SQL Server you can try to cast to a data type and receive null values where the cast fails. declare @T table ( Col varchar(50) ) insert into @T values (‘1’), (‘1.1’), (‘1,1’), (‘1a’) select cast(” as xml).value(‘sql:column(“Col”) cast as xs:decimal ?’, ‘decimal(28,10)’) as Col from @T Result: Col ————- 1.0000000000 … Read more