How I can do If instruction in DTS ??
example
select @data=date form table where id=32
if @data='2007-10-22'
copy data to exel from table2 (I have this in 3 elements(OLE DB Source,Data Conversion,Flat File Destination)
else
do nothing
I don't now how to do if instraction.
Pleas help me.
I am very VERY new to using Visual Studios...
I have a SQL database with a table in it "table1" inside the table there is a field "ID"
I have made a new website project thing, and I have a textbox and a submit button
What I want to do is make a function that will check if what the user has typed into ID is valid, e.g. it exists in the database
Can anyone point me in the right direction about how I could do this?
Thanks very much
Hi,
I need something like a sequence in a datafield of my table. (unique number in the table) is a uniqueidentifier the right thing to choose? and if yes, how to I insert a new value into the that table:
a) from the SQL Enterprise Manager?
b) from a JAVA program using jdbc?
thanks for all hints.