The max size for a column of type NVARCHAR(MAX) is 2 GByte of storage. Since NVARCHAR uses 2 bytes per character, that’s approx. 1 billion characters. Leo Tolstoj’s War and Peace is a 1’440 page book, containing about 600’000 words – so that might be 6 million characters – well rounded up. So you could … Read more
You can not update identity column. SQL Server does not allow to update the identity column unlike what you can do with other columns with an update statement. Although there are some alternatives to achieve a similar kind of requirement. When Identity column value needs to be updated for new records Use DBCC CHECKIDENT which … Read more
If the table is already created in the database, then you can add a unique constraint later on by using this SQL query: ALTER TABLE dbo.User ADD CONSTRAINT ucCodes UNIQUE (fcode, scode, dcode)
Cast/Convert the values to a Date type for your group by. GROUP BY CAST(myDateTime AS DATE)
Updated For MS SQL Server 2012 and above USE [master]; DECLARE @kill varchar(8000) = ”; SELECT @kill = @kill + ‘kill ‘ + CONVERT(varchar(5), session_id) + ‘;’ FROM sys.dm_exec_sessions WHERE database_id = db_id(‘MyDB’) EXEC(@kill); For MS SQL Server 2000, 2005, 2008 USE master; DECLARE @kill varchar(8000); SET @kill=””; SELECT @kill = @kill + ‘kill ‘ … Read more
I resolved this issue by setting database owner. My database did not have had any owner before this issue. Execute this command in your database to set owner to sysadmin account: use [YourDatabaseName] EXEC sp_changedbowner ‘sa’
ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName; If you want to move all tables into a new schema, you can use the undocumented (and to be deprecated at some point, but unlikely!) sp_MSforeachtable stored procedure: exec sp_MSforeachtable “ALTER SCHEMA TargetSchema TRANSFER ?” Ref.: ALTER SCHEMA SQL 2008: How do I change db schema to dbo
No – you have to do it the other way around: add it right from the get go as INT IDENTITY – it will be filled with identity values when you do this: ALTER TABLE dbo.YourTable ADD ID INT IDENTITY and then you can make it the primary key: ALTER TABLE dbo.YourTable ADD CONSTRAINT PK_YourTable … Read more
Try: With DependencedIncidents AS ( SELECT INC.[RecTime],INC.[SQL] AS [str] FROM ( SELECT A.[RecTime] As [RecTime],X.[SQL] As [SQL] FROM [EventView] AS A CROSS JOIN [Incident] AS X WHERE patindex(‘%’ + A.[Col] + ‘%’, X.[SQL]) > 0 ) AS INC ), lalala AS ( SELECT INC.[RecTime],INC.[SQL] AS [str] FROM ( SELECT A.[RecTime] As [RecTime],X.[SQL] As [SQL] FROM … Read more
If you wanted to simply assign some variables for later use, you can do them in one shot with something along these lines: declare @var1 int,@var2 int,@var3 int; select @var1 = field1, @var2 = field2, @var3 = field3 from table where condition If that’s the type of thing you’re after