SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
lemme know lemme know

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 12-22-2007, 05:04 AM
Sowmya
 
Posts: n/a
Exclamation ANY dialect question:

lemme know

Hi,
Can anyone tell me if there is a single command to insert if no value is present and update if present....
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 05-23-2008, 12:08 PM
Unregistered
 
Posts: n/a
Default ANY answer. Re: lemme know
Quote:
Originally Posted by Sowmya View Post
Hi,
Can anyone tell me if there is a single command to insert if no value is present and update if present....
There is no single command for doing that,You have to use IF-THEN-ELSE condition.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 08-26-2008, 10:59 AM
SandeshSegu SandeshSegu is offline
Junior Member
  
Join Date: Aug 2008
Location: Bangalore, INDIA
Posts: 6
SandeshSegu is on a distinguished road
Default ANY answer. Re: lemme know
Or Use Triggers...
__________________
Thanks
Sandesh S
http://sanssql.blogspot.com/
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Using SQL Query, find minimun price of each brand.? | SQL Server »

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 10:00 PM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8