Click here to Skip to main content
15,891,248 members
Search within:


How to use If...Else in SQL Server2000 with select and insert statements?
Please Sign up or sign in to vote.
0.00/5 (No votes)
How to use If...Else in SQL Server2000 with select and insert statements??
Posted
Add a Solution
Comments
LaxmikantYadav 31-Oct-11 8:46am    
Not Cleared :( . Can u explain more.

1 solution

You can do something like:

SQL
IF EXISTS (SELECT 1 FROM Table_name WHERE data_field  = '')  
BEGIN    
   SELECT TableID FROM Table_name WHERE data_field = '' 
END 
ELSE 
BEGIN    
   INSERT INTO Table_name (data_field) VALUES('') 
END
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Select statement in PHP with MSSQL
SQL Statement for Inserting
Select in Insert statement using Merge
How to use if else in select statement in sql server 2008
How do I use SQL statement within my VB.NET application?
Insert statement with multiple select results in sql
select statment in an insert statement.
How to use CASE WHEN THEN ELSE statements in stored procedure
Insert into select in SQL
Using Select Sql statement

Advertise
Privacy
Cookies
Terms of Use
Last Updated 31 Oct 2011
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900