Database, SQL (Structured Query Language)

Comments Off on Using (nolock) with SQL Select Query in SQL Server 2005

Using (nolock) with SQL Select Query in SQL Server 2005

I was using following query select top 10 * from [sqlserver02\sqlserver02].mydatabase.dbo.aspnet_membership (nolock) whereas “sqlserver02″ was a remote serever  and I found following errro Msg 4122, Level 16, State 1, Line 1 Remote table-valued function calls are not allowed. Then I remove (nolock) from the query and it worked. Does any one know why remote serever […]

Database, SQL (Structured Query Language)

Comments Off on Power of CLR (Common Language Runtime) + SQL server 2005, Managed Assembly

Power of CLR (Common Language Runtime) + SQL server 2005, Managed Assembly

Today I used Managed Assembly to use Regular Expression in SQL server 2005. I wanted to search for all records which contain special characters in my data and some foreign characters so I was using following SQL Query Select OrganisationId,organisationname from organisation Where organisationname like ‘%-%’ OR OrganisationName like ‘%&%’ OR OrganisationName like ‘%(%’ OR […]

Accent Insensitive search in sql server + COLLATE SQL_Latin1_General_CP1_CI_AI

We were facing a problem in searcing the exact data from Microsoft sql server 2005 database, Our database is containng foreign language characters ,çéèêëñòóôõöàáâãäåìíîïùúûüŵŷýÿ as you can see in following data, I was wondering how we can solve this problem, I tried to search it on the google and posted this in some forums. The Coleg Sir Gâr   […]