Viewing 15 posts - 17,491 through 17,505 (of 18,926 total)
It still won't work. It'll sort by the numerical value 1,2,3... not the colid. Which if I remember corectly won't even be supported starting with Yukon.
You either...
June 1, 2005 at 10:20 am
You don't need to put anything in it, but you must declare it. I set it to something to show you that its value was changed in the proc.
Also...
June 1, 2005 at 10:04 am
BTW this is how to call the proc from VB6 :
MyCn is a global connection to the application
Private Function exec_demo(ByVal param1 As Integer, ByRef paramOUT As Integer, Optional ByRef...
June 1, 2005 at 9:57 am
Look at this carefully, you must supply the output parameter to the proc...
Declare @Return as int
Declare @Out as int
set @Out = 1000
exec @Return = dbo.demo 9, @out output
Select...
June 1, 2005 at 9:55 am
That's the way I would go to... I used this technique once before. I put all the important columns in the main table, then every other text and large...
June 1, 2005 at 9:52 am
This won't work if you have a mix of different datatypes. Case expression must return only 1 datatype. And unless I'm mistaken, it'll take the first case as...
June 1, 2005 at 9:47 am
btw.. Sql server doesn't need to have '{' around the dates.. this is usually to have some compatibility with MS Access.
Here's an exemple of how to execute a stored proc...
June 1, 2005 at 9:42 am
This is an asssumption, but in sqlserver 2000 you can set the compatibility level of the database. The 2000 dbs have a level of 80 (8.0), if you set...
June 1, 2005 at 9:36 am
Maybe not, but if you think you are, then I feel I should tell you this : Make sure that the user has absolutely NO WAY of accessing the column...
June 1, 2005 at 9:02 am
Select Name, XType from dbo.SysObjects O where USER_NAME (O.UID) = 'dbo' order by XType, Name
June 1, 2005 at 8:53 am
Btw I would strongly urge you to read these documents... it's an hour very well spent (especially the first one for this thread) :
Dynamic Search Conditions in T-SQL
June 1, 2005 at 8:47 am
Depends on how many columns you have to sort on... if there's only 2-3 possibilities and that the recordset is small you can always do it on the server. ...
June 1, 2005 at 8:45 am
Wish I could.. but the only thing I know about heap is how to spell it so I'll be waiting for an answer myself.
June 1, 2005 at 8:15 am
Viewing 15 posts - 17,491 through 17,505 (of 18,926 total)