search results

  1. Can I use an IF…ELSE statement to set a field? (T-SQL) ... I can do this by just writing a separate update statement but ... use LEFT JOIN and a CASE statement ...
    stackoverflow.com/questions/15276315/​can-i-use-an-if... - Cached
  2. Here is an example of how to use the SELECT statement to set ... IF ... ELSE. T-SQL has the \"IF\" statement to ... can be tested. If a SELECT statement is used the ...
    www.databasejournal.com/features/mssql/​article.php /3087431 - Cached

  3. Transact-SQL - Wikipedia, the free encyclopedia

    Transact-SQL ( T-SQL) ... we can use BEGIN and END like this: ... The statement can be used for delays or to block execution until the set time.
    en.wikipedia.org/wiki/Transact-SQL - Cached
    More results from en.wikipedia.org »
  4. S ubquery in the FROM clause of an UPDATE statement: SET NOCOUNT ON CREATE TABLE x( i INT IDENTITY, a CHAR(1 )) ... , and how they can be used in your T-SQL code. ...
    www.akadia.com/services/sqlsrv_​subqueries.html - Cached
  5. Can\'t get SQL statement to update from 2 ... Is there any way to use Order By on an update statement? 1. ... Can I use an IF…ELSE statement to set a field? (T-SQL) 4.
    stackoverflow.com/questions/15830779/​can-anyone-spot-the... - Cached
  6. I have following t-sql statement, ... Can I use \"Set @Amount = \'field_name1\' \" for this operation? Edited by patrickli on Apr 25, 2009 09:22 AM; Reply; mo meng.
    forums.asp.net/t/1415057.aspx/1 - Cached
  7. How To Use Switch - Case Statement In T-SQL ... tht I have to set the value for the variable @Segment_Field acc to the ... I can use 2 SELECT queries using \'IF ELSE\', ...
    www.bigresource.com/MS_SQL-How-to-use-​switch-case... - Cached
  8. Unless a statement block is used, ... IF tests can be nested after another IF or ... The following example uses IF…ELSE with output from the uspGetList stored ...
    technet.microsoft.com/en-us/library/​ms182717 - Cached
  9. The FROM clause normally identifies the tables used in the T-SQL statement. You can think of ... a subquery is just a set of records, and therefore can be used in the ...
    www.databasejournal.com/features/mssql/​article.php/3464481 - Cached
  10. ... SET @X = Case @Y WHEN 1 THEN 444 WHEN 2 THEN 555 END How can I make this work: Case @Y WHEN 1 THEN SET @X ... Case statement T-SQL ... to use IF..ELSE ...
    www.experts-exchange.com/Database/​Miscellaneous/Q...
    More results from experts-exchange.com »