Programming SQL
in [Microsoft SQL Server]
|
jameelmossly@yahoo.com ���� ������ mahmdyosef35 Skype ����� ���� ������ ���� �� ���� ... 24 Jul 2010 13:25
Avoid conditional logic? I've heard that SQL Server can create a better execution plan if the query has unconditional logic as opposed to conditional logic. So where I might want to do this (conditional logic)... IF @Test = 1 SELECT This, That From Table WHERE This = 'aaa' ELSE SELECT This, That From Table WHERE This = 'bbb' ...... 23 Jul 2010 13:39
SQL Server 2005 CE Tools for VS2005 SP1. I develop mobile applications with SQL Server 2005 Compact Edition + Visual Studio .NET 2005. So I installed both SQL Server 2005 CE and SQL Server 2005 CE Tools for VS2005 SP1. Now I want to setup a new development environment: SQL Server 2005 CE + Visual Studio .NET 2008. My question is,should I setup some l... 23 Jul 2010 02:44
Pink Love-GHD Pink Limited Edition box set with 60% discounts and free shipping Inspired by bold, statement bows seen on the catwalks the set comes complete with a never-seen- before collection of ghd accessories. The new ghd Pink Limited Edition box set is the secret to perfect styling that every fashionista needs.Pastel pinks and nude shades are the colour statement of the season w... 22 Jul 2010 21:20
Send Messages to Broker in Set? I am converting a single row of table data into an XML fragment with the below code. The fragment is dumped into a Service Broker queue as a single message. I think I will have to loop through the table to get individual mesages into the queue, since 1 row = 1 message. If there is a way to do this in a set-ba... 22 Jul 2010 18:02
Subquery with Wildcards? Is a query like this possible? I'm trying to filter out for words that exist in a filter table. I'd like to filter for foul language, but for example: "Cat" is in the filter table. It should also filter: Recat Cat! Catyou SELECT id ,name ,comment ,fk_id FROM tresponsecomments WHERE comment NOT... 23 Jul 2010 00:35
Case Expression Performance Implication When writing an a business application where speed is important, are there isssues with using case expression in sql queries? and why? Thanks in advance ... 22 Jul 2010 16:56
Creating user for change one schema Hello there I have database with 10 schemas. all the authorization of the schemas is dbo for security purposes. I need to create user who can do anything on specific schema include create and drop objects and don't have any access to other schemas. Is there a way to do this? ... 22 Jul 2010 12:31
How to find transposed data and near misses I just wanted to let Erland Sommarskog know that more than 5 years later, that CASE code is still helping people. I found this page via a Bing search on "sql fuzzy matching of transposed numbers", and that CASE code was exactly what I needed. THANKS! From http://www.developmentnow.com/g/113_2005_6_0_0_533778/How-to-... 22 Jul 2010 11:26
change table scema right click table | modify | goes on property panel then set new schema value on schema row ciupazNoSpamGrazi wrote: Re: Change table schema 21-Feb-08 "Tibor Karaszi" wrote: Yeah Tibor ;-) Thanks a lot you all. -- Luigi http://blogs.dotnethell.it/ciupaz/ Previous Posts In This Thread: On Wednesda... 22 Jul 2010 09:13 |