Viewing 15 posts - 1,216 through 1,230 (of 1,412 total)
Are you connecting to a local server or a remote server? What network protocol are you using?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 18, 2003 at 10:57 am
quote:
SELECT * FROM PERSONS WHERE LASTNAME = 'O''Malley';
Correct.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 18, 2003 at 10:50 am
quote:
When our developers create stored procs they become the owners of the proc.
If your developers...
March 18, 2003 at 2:11 am
Have you patched for Slammer (or using SP3)? It could be that your SQL Server instance gets hit by Slammer and then clogs up your internet connection.
--
Chris Hedgate @ Apptus...
March 18, 2003 at 1:58 am
You're missing quotation-marks.
use northwind
DECLARE @CharVariable CHAR(9)
SET @CharVariable = 'Beverages'
exec('select * from categories where categoryname = ''' + @CharVariable + '')
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 18, 2003 at 1:43 am
That sounds like a great solution, and yes, WSH is probably better than batch script. Just me that's oldfashioned. 🙂
But still, neither of these solutions makes it possible to call...
March 17, 2003 at 10:33 am
quote:
Let me clarify a little.Since a clustered index specifies how SQL server should physically sort a table, use one of those.
March 17, 2003 at 7:50 am
To my knowledge there is no way to do this in T-SQL. I think Oracle has some syntax for it, that may be why some want this. I can't see...
March 17, 2003 at 7:42 am
What does the script look like? Is it pubs you are trying to create? What happens if you run the same script in query analyzer?
--
Chris Hedgate @ Apptus Technologies (
March 17, 2003 at 2:45 am
March 16, 2003 at 10:26 am
I'd use three bit fields, or a separate many-tom-many relationship table. With a single column storing a bitmasked value you won't be able to have foreign keys.
--
Chris Hedgate @ Apptus...
March 16, 2003 at 10:24 am
You can use xp_cmdshell to run isql with the script. Don't really see why you would need that though, are you sure that is the right way of doing what...
March 15, 2003 at 2:01 am
Two choices as I see it. First is to wrap all of your query, except the OScore column, in a subquery and then do a SELECT from that. Something like...
March 15, 2003 at 1:59 am
No difference ion performance, however I agree that it is better to explicitly state the columns in INSERT ... SELECT statements, as well as INSERT ... VALUES statements. The worst...
March 14, 2003 at 8:08 am
Juanita, if you are talking about placing SQL Server data files on a network file share and then using those as data files for a database on your server, that...
March 14, 2003 at 6:38 am
Viewing 15 posts - 1,216 through 1,230 (of 1,412 total)