Yes. However you have to create SQL server function first and call that as by default LINQ will use a like. This blog post which will explain the detail but this is the extract: To get it working you need to create a table valued function that does nothing more than a CONTAINSTABLE query based … Read more
It sets how the database server sorts (compares pieces of text). in this case: SQL_Latin1_General_CP1_CI_AS breaks up into interesting parts: latin1 makes the server treat strings using charset latin 1, basically ascii CP1 stands for Code Page 1252 CI case insensitive comparisons so ‘ABC’ would equal ‘abc’ AS accent sensitive, so ‘ΓΌ’ does not equal … Read more
Summary of what I’ve seen so far: Some people don’t like cascading at all. Cascade Delete Cascade Delete may make sense when the semantics of the relationship can involve an exclusive “is part of” description. For example, an OrderLine record is part of its parent order, and OrderLines will never be shared between multiple orders. … Read more
The VARCHAR(MAX) type is a replacement for TEXT. The basic difference is that a TEXT type will always store the data in a blob whereas the VARCHAR(MAX) type will attempt to store the data directly in the row unless it exceeds the 8k limitation and at that point it stores it in a blob. Using … Read more
Here is some good explaination. check out it. http://www.mssqltips.com/tip.asp?tip=1360 CHECKPOINT; GO DBCC DROPCLEANBUFFERS; GO From the linked article: If all of the performance testing is conducted in SQL Server the best approach may be to issue a CHECKPOINT and then issue the DBCC DROPCLEANBUFFERS command. Although the CHECKPOINT process is an automatic internal system process … Read more
from #client_profile_temp cpt cross apply dbo.split( #client_profile_temp.interests, ‘,’) as split <–Error is on this line I think the explicit naming of #client_profile_temp after you gave it an alias is a problem, try making that last line: cpt.interests, ‘,’) as split <–Error is on this line EDIT You say I made this change and it didn’t … Read more
IsNumeric returns 1 if the varchar value can be converted to ANY number type. This includes int, bigint, decimal, numeric, real & float. Scientific notation could be causing you a problem. For example: Declare @Temp Table(Data VarChar(20)) Insert Into @Temp Values(NULL) Insert Into @Temp Values(‘1’) Insert Into @Temp Values(‘1e4’) Insert Into @Temp Values(‘Not a number’) … Read more
Try this one – SET NOCOUNT ON; IF OBJECT_ID (N’tempdb.dbo.#temp’) IS NOT NULL DROP TABLE #temp CREATE TABLE #temp ( [COUNT] INT , DB VARCHAR(50) ) DECLARE @TableName NVARCHAR(50) SELECT @TableName=”[dbo].[CUSTOMERS]” DECLARE @SQL NVARCHAR(MAX) SELECT @SQL = STUFF(( SELECT CHAR(13) + ‘SELECT ‘ + QUOTENAME(name, ””) + ‘, COUNT(1) FROM ‘ + QUOTENAME(name) + ‘.’ … Read more
SELECT LEFT(Car, LEN(Car) – 1) FROM ( SELECT Car + ‘, ‘ FROM Cars FOR XML PATH (”) ) c (Car)
Once connected to Sql Server 2005 Database, From Object Explorer Window, right click on the database which you want to import table into. Select Tasks -> Import Data. This is a simple tool and allows you to ‘map’ the incoming data into appropriate table. You can save the scripts to run again when needed.