2014-03-20
2,254 reads
2014-03-20
2,254 reads
2013-12-18
1,335 reads
2013-11-13
1,722 reads
CAN you create AND USE an indexed view in non-Enterprise Editions of SQL Server?
2012-04-10
8,766 reads
2012-02-10
2,418 reads
Sorry I haven't had a chance to play with SQLCE but are you saying your trying to attach to .sdf with EM from desktop or within CE device. See if this helps any http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road05222002.asp
2004-03-22
declare @t datetime, @h char(4) set @t = '20040702' set @h = '0800' select @t, @t + STUFF(@h,3,0,':')
2004-03-10
try:INSERT INTO UNRESOLVED (CaseNbr)SELECT T3.CaseNbr FROM Table3 T3 LEFT OUTER JOIN (Select CaseNbr From Table 1 UNION Select CaseNbr from Table 2  Q ON T3.CaseNbr =Q.CaseNbr WHERE Q.CaseNbr is Null
2004-03-02
Are you using : sp_MSforeachdb 'use ? dbcc showcontig with tableresults, all_indexes' Remember it coms back as Multiple RS HTH
2003-11-24
I also agree with Melanie. As does my friend Joe. In his usual charming style from another list: quote: This is a common mistake that Newbies and idiots often make. They literally do not know what a table is. A table is a set of things of the same kind (as per 1NF and DKNF […]
2003-11-20
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hello friends. I’m new here, so if this is the wrong place for my...
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Comments posted to this topic are about the item Coding Magic Values