Viewing 15 posts - 37,681 through 37,695 (of 39,506 total)
You can by storing the id value in a @var and then incrementing by selecting the min(id) where id > @id.
Steve Jones
April 4, 2002 at 2:21 pm
Or send in all the values for the params to one procedure and have that one call the appropriate procedure to do what you want.
Steve Jones
April 4, 2002 at 2:13 pm
April 4, 2002 at 2:06 pm
It was buggy and IMHO, that is why they made it the non-default.
Probably a registry setting, but I have no idea which one.
Steve Jones
April 4, 2002 at 2:05 pm
We do this with categories here at SSC.
create table Category
( categoryid int
, categoryname varchar(20)
, parentcatid int
)
insert category 1, 'SQL 2000', 0
insert category 2, 'Programming', 0
insert category...
April 4, 2002 at 1:09 pm
yes,
create view N_orders as
select *
from northwind.dbo.orders
return
create this in pubs to access northwind.
Steve Jones
April 4, 2002 at 1:06 pm
Is this a valid path on the server? THe with MOVE is to restore from a different path than that the backup was made with. This applies to different servers...
April 4, 2002 at 1:01 pm
they both will work well. The IN resolves to essentially a series of ORs
Steve Jones
April 4, 2002 at 12:59 pm
Is the problem that SQL Server sometimes runs on 5000? Is this an instance besides the default? The server network utility mentioned above allows you to limit SQL Server to...
April 4, 2002 at 9:53 am
If you don't have the need for a SAN, I'd stay away. You are spending $$ and taking chances for no reason. SANs are usually looked at for the 100s...
April 2, 2002 at 4:43 pm
Personally I use Box C as a QA box, backup/restore box A to box C, deploy code, and test. If everything is ok, then deploy code to box A and...
April 2, 2002 at 10:53 am
This is an often a debated topic. Store the .jpgs in the filesystem and the path in the db or store the image in the db. I vote for the...
April 2, 2002 at 10:46 am
You cannot do this. You need to setup a linked server to access another sql server from T-SQL.
Steve Jones
April 2, 2002 at 10:44 am
secure shell, vpn, export to file and encrypt the file and then ftp the encrypted file (or other transport).
Steve Jones
April 2, 2002 at 10:26 am
OK, I'm slightly confused, but here are some things to note.
For each SQL Server instance, there is an MSSQLServer service and a SQLAgent service. There may be others, but these...
April 2, 2002 at 10:15 am
Viewing 15 posts - 37,681 through 37,695 (of 39,506 total)