Hi,
I have 2 tables:
1. Companies:
companyId, LastLoginDate.
2. Jobs:
1. JobId, CompanyId, EntryDate.
Each company can have multiple jobs.
I would like to select all compani...
Hi,
I have following data in .CVS file (US ZipCode Database)
07009 S Cedar Grove D New Jersey NJ 973 40.854334999999999 -74.231713999999997
0...
More of a question of "what's going on" than anything else...
I'm trying to understand what's going on here in this stored procedure. I'm specifically interested in the line beginning with ...
I have a merge replication on a sqlserver 7 sp4 on a winNT computer on a LAN and i have another computer with an adsl internet conection that i use to replicate data with the subscribers, i ha...
We have a Microsoft Windows 2000 Domain running active-directory services and an SQL Database. During Operating hours the database slows down immensely and the only present remedy that we have...
Hi all,
i am new to sql server.
when i am trying to connecting the application(ofcourse backend is sql server) from frontend, frequently i am getting error like below.
Error Type:
...
Q1)
Is that right
sysindexes.status of all system indexes can be filtered by 0x60?
I.e. if sysindexes.status & 0x60 = 0x60 then
// this is a system index
end if
How abou...
The following names and ID are displayed 2 ways:
a jones(123123)
smith(444433)
I need to check for the first condition ie, if a space is in the 2nd position, or not.
What I need is:
...
Hi there, I'm desperate to get some info on what the heck a pageiolatch is, what it means, and what you have to do about it. I can't find any literature on the microsoft site about it, in the...
I have a .net compact framework program written in C# on a pocket pc 2002 that uses a SQL CE database. I'm using RDA to sync the ce db w/ a sql server db. Everything was working fine. Now a...
Hi,
I need a stored procedure, or a function within a stored procedure that when passing in a start date and an end date, will calculate the number of days between the 2 dates, excluding week...
I have:
table1:
Day Title Key
1 Hi 10
2 Hello 10
And I want to get:
Title...
I need to run an e-mail alert daily so I am using WshShell to run an ASP page from SQL Server. This all works fine but I need to have basic authentication where the ASP page will reside. The ...
I have a COM object running on a Windows 2000 Server executing queries against a SQL Server 2000 database running on a another Windows 2000 Server. This is a very active application with man...
I'm using MS SQL Server 7
and in a script i'm trying to initially save the name of the current Database , to later restore back to... (not in a dump/backup sense just Database context)
is...
Dear Experts,
I need to transfer the *content* from tables from a development SQL Server 2000 database to a live web SQL server database such that the content from the dev db completely rep...
I need to drop a FK CONSTRAINT only if exists.
How do I write the "If.." statement before the following sentance:
...ALTER TABLE MyTable DROP CONSTRAINT FK_Mykey
Thanks in advance
Given the following procedure:
create procedure GetProducts
(
@productId int = null,
@category varchar(50) = null,
@orderBy varchar(50) = '',
@sort varchar(4) = 'asc'
)
sele...
Hi,
We have a few cubes designed using the Analysis Manager. Is there a way to generate a script, in any language, that will create cubes with exactly the same structure as our cubes? Are the...
I need to find the table structure for a local temporary table.
create table #test (
a int,
b int
)
sp_columns #test
doesn't work.
If it's possible I want to use some an existin...
If no, then how could you accomplish the same thing?
I could probably figure this out in a few hours but hey, that's what experts exchange is for, right?!
Basically I'm building a "Query Builder" app. I need to be able to (provided a database...
Hi,
How do I add a filed into an existing table, in a specific location, and not to the end of the table ???
I wrote the following query, but :
This query adds the field to the end of the...
I need to do a quick and dirty backup of a database 130 GB in size...
What I plan is:
use master
go
alter database BigDB
set single_user with rollback immediate
sp_detach_db 'Bi...
Okay was updating a table in design view enterprise manager crashed on my client machine, so I ended the task. Remote Desktop connection in to server used enterprise manage to make the change...
