One more way

declare @String varchar(1000)

select @String='nhtinhfsgjsdereSalgjdmexSUM=1290SUMddssfsdfsdfsdsdsdf'

Select SUBSTRING(@String, 1, CHARINDEX('SUM',@String)-1),REVERSE(SUBSTRING(REVERSE(@String), 1, CHARINDEX('MUS',REVERSE(@String))-1))

select substring(@String,

charindex('SUM',@String)+len('SUM='),

charindex('SUM',@String,charindex('SUM',@String)+1)-charindex('SUM',@String)-len('SUM='))

Adi

When you use the procedure sp_msforeachdb, it loops through the databases, but it is still being run from the database that you are connected to, so it will run you...

I don't think that cursors are evil. I do think that cursors are being misused a lot and this is what gave them there reputation. You have to...

Here is one more way:

select

tbl.col.value('(../@name)[1]','varchar(10)'),

tbl.col.value('@name','varchar(10)'),

tbl.col.value('@value', 'int')

from @xmlData.nodes('registry/k/k/v') tbl (col)

Adi

Like John wrote in his replay you can query sys.sql_modules, but don't forget that you might miss some views. For example if the view checks the value of empid,...

You have 2 choices. The first choice is to use Unicode instead of ASCII (e.g. nvarchar or nchar instead of varchar or char). If you use Unicode,...

Are you sure that the problem with your tempdb was caused by the code that you posted? Don’t forget that a different code can use most of the tempdb’s...

You can check the GMT time (with GETUTCDATE() function) and then add 2 hours to it (to get the local time at Israel). The problem is that this calculation...

You can find the reason in this URL – http://msdn.microsoft.com/en-us/library/ms178050.aspx. If you don’t specify the column’s source in the subquery, it will first try look for it in...

As far as I know the only things that you should check is that the table exists on your default schema and that you have permissions to work with this...

You can create a computed column that does it. When you create a computed column you don't have to specify its data type and you use the key word...

It should work. I’ve just tested it with the script bellow. Do you have the problem when you run the select statement from a SSMS window or do...

Are you sure that this is the default schema? Can you check if this is the really the user’s default schema with this query?

select default_schema_name

from sys.database_principals

where name = 'WriteUserNameHere'

Adi

You have to use the schema’s name and put apostrophes around it (e.g. ‘Risk.TableA’). If it really bothers you, you can try writing your own procedure that will be...

You are missing the table’s schema in your query. If you didn’t work with schemas then most chances are that the schema name is dbo (which means that the...