Viewing 15 posts - 91 through 105 (of 113 total)
if i get you right:
DECLARE @retval INT
EXECUTE @retval = my_stored_proc 'x', 'y'
PRINT @retval
use RETURN to return any integer expression from a stored proc (exits immediately).
if you're looking for "real" return...
July 23, 2003 at 2:52 am
if you don't want to wrap your insert logic into a stored procedure, generate your GUID directly on client side and insert it into your client side recordset (rowguidcol attribute...
July 18, 2003 at 2:38 am
open the "client network utility" program (cliconfg.exe) from the start menu. take a look at (depending on your version) either a tab called "Aliases" or a list of aliased servers....
July 14, 2003 at 2:53 am
generate your own sort key in the select statement by using one of the following statements:
select *, case when nullable_col_name is not null then 0 else 1 end sort_key
...
July 14, 2003 at 2:47 am
The one about usr and pwd was just "best practice" advice -> code clarity and readability.
regards,
chris.
July 7, 2003 at 2:10 am
Hi!
Looking at BOL you'll see that the *=/=* syntax is not anymore supported ("can lead to unpredicted results").
Use LEFT/RIGHT OUTER JOIN instead. In addition, you'll have to include a restricting...
June 23, 2003 at 3:26 am
if everything else isn't an option for you (writing extended stored procedures), you can reside to use the MQSeries-Client automation interface (MQAX200.DLL) and the MSSQL functions to access automation objects...
May 12, 2003 at 7:20 am
you can use "TRUNCATE TABLE mytable", which is in fact a DDL statement (*not* DML) and therefore not logged at all.
that means that you won't be able to run it...
April 29, 2003 at 6:42 am
April 29, 2003 at 6:32 am
Got a little how to for you. Create a table you want to add to your publication. Afterwards issue something like that (depending the options you want to use and...
April 22, 2003 at 1:02 am
That will do the trick (2nd part of the script):
http://www.sqlservercentral.com/scripts/contributions/246.asp
best regards,
chris.
April 22, 2003 at 12:41 am
quote:
cneuhold,Please try it.
sorry, you're absolutely right ... in my posting i meant to write...
April 14, 2003 at 1:52 am
ok! what about:
exec sp_dboption 'dbname', 'bulkcopy', false?
best regards,
chris.
April 14, 2003 at 1:49 am
suggestion: don't get rid of those objects, the optimizier needs them (at least partly). they won't disturb you when dropping objects.
if you don't want to see them when selecting indexes...
April 14, 2003 at 1:40 am
hi!
select into is an implicit DDL statement (it creates a table).
DDL statements are not possible to be executed on a linked server (try eg. create table, truncate table).
best regards,
chris.
Edited by...
April 10, 2003 at 3:35 am
Viewing 15 posts - 91 through 105 (of 113 total)