I need to start by unwrapping this a bit so I can see what’s going on: SELECT 199.96 – ( 0.0 * FLOOR( CAST(1.0 AS DECIMAL(19, 4)) * CAST(199.96 AS DECIMAL(19, 4)) ) ) Now let’s see exactly what types SQLÂ Server is using for each side of the subtraction operation: SELECT SQL_VARIANT_PROPERTY (199.96 ,’BaseType’), SQL_VARIANT_PROPERTY … Read more
If you want everything after the last _, then use: select right(db_name(), charindex(‘_’, reverse(db_name()) + ‘_’) – 1) If you want everything before, then use left(): select left(db_name(), len(db_name()) – charindex(‘_’, reverse(db_name()) + ‘_’))
You could try something like DECLARE @Table TABLE( SPID INT, Status VARCHAR(MAX), LOGIN VARCHAR(MAX), HostName VARCHAR(MAX), BlkBy VARCHAR(MAX), DBName VARCHAR(MAX), Command VARCHAR(MAX), CPUTime INT, DiskIO INT, LastBatch VARCHAR(MAX), ProgramName VARCHAR(MAX), SPID_1 INT, REQUESTID INT ) INSERT INTO @Table EXEC sp_who2 SELECT * FROM @Table WHERE …. And filter on what you require.
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
SQL Server 2005 onwards: IF EXISTS(SELECT 1 FROM sys.columns WHERE Name = N’columnName’ AND Object_ID = Object_ID(N’schemaName.tableName’)) BEGIN — Column Exists END Martin Smith’s version is shorter: IF COL_LENGTH(‘schemaName.tableName’, ‘columnName’) IS NOT NULL BEGIN — Column Exists END