Viewing 15 posts - 13,141 through 13,155 (of 13,876 total)
SPs do not handle user interaction - your app does that.
It should then call SPs, with appropriate parameters, to do the data processing side - whether it be data retrieval,...
March 29, 2006 at 8:18 am
As I said, you need to use single quotes.
declare @quote char(1)
set @quote = '''' --4 single quote characters
'DELETE ' +
' WHERE dssid = ' + @quote + @vchdssid +...
March 29, 2006 at 5:41 am
Use single quotes around literals in SQL Server. To debug, try running your statement in Query Analyser and see what happens.
By the way, this looks like a horrendously complex routine for...
March 29, 2006 at 4:07 am
Stored procedures should perform better, in general. Network traffic is optimised and SQL Server should be able to reuse execution plans when running SPs multiple times.
March 28, 2006 at 9:37 am
When the system finds a 'duplicate', what logic should be used to determine which of them to delete?
March 28, 2006 at 9:30 am
Are you using Access to delete the data?
If you are using linked tables within Access, you must ensure that Access knows the primary key of the table when you link...
March 28, 2006 at 3:24 am
OK - this is turning into a weird one. If you take the
and PickupDate > '3/2/2006' --*****
line out of the query, what is the latest entry displayed?
You could also...
March 27, 2006 at 10:10 am
What is the datatype of the PickupDate field - is it datetime or varchar()?
March 27, 2006 at 9:57 am
Expanding on PW's post, I suggest you use this format:
'YYYY-MM-DD HH:MM:SS.mmm'
So your query becomes:
...
and PickupDate > '2006-02-03 00:00:00.000'
order by PickupDate
(if you're using English date format.)
March 27, 2006 at 9:48 am
A strange request!
update table set age = 32 where id = [PK for row containing John's data]
update table set age = 26 where id = [PK for row...
March 27, 2006 at 9:38 am
Please do not cross post. Follow this thread.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=268690
March 27, 2006 at 9:21 am
Are you exporting the field as text?
March 27, 2006 at 9:20 am
So what's wrong with my solution? ![]()
Your solution, I'm afraid, is logically flawed. Eg if this is sample data
T1 (CustNo, OrderNo)
1,1
1,2
2,1
T2 (CustNo, OrderNo)
1,1
Your query...
March 27, 2006 at 5:50 am
So are you thinking of adding a new column to the 'old' table corresponding with 'software_no' in the new table?
March 27, 2006 at 3:07 am
Once you have the 'next' identity number, what are you going to do with it?
Maybe @@IDENTITY, or Scope_Identity() (check BOL for details) will give you what you need?
March 27, 2006 at 2:58 am
Viewing 15 posts - 13,141 through 13,155 (of 13,876 total)