|
Track changes made to existing stored procedure
how can I keep track of who is making modifications to a existing stored
procedure.
thanks
samy ...
Thu, 13 Jan 2005 10:59:04 -0800
|
Describing a table structure
Hi,
I would like to know the syntax in MS SQL 2K for describing a table, without
having to expand everything in the object browser.
I know in Oracle it is: desc ;
Thanks,
Jig. ...
Thu, 13 Jan 2005 09:11:02 -0800
|
Update query SQL2000
Hi
I am trying to write an update query that update the BG1 field in the
Customer table with the BG value in the Agreements Table from a different
database.
Here is what I have so far . . . but it doesn't work - I get the error
Server: Msg 8152, Level 16, State 2, Line 1
String or binary data would be ...
Thu, 13 Jan 2005 08:55:18 -0000
|
Extrating Data from One Database from Another
Hello,
I am new to sql (very new).
I have two database, let's call it database1 and database2.
Both database contains last name, first name and address information.
Database1 has approximatley 12000 records and database2 has approximately
2000 records. Here is what I am trying to accomplish. I will like ...
Mon, 10 Jan 2005 10:03:03 -0800
|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:53:00 +0800
|
Parameter Query
I'm using sql 2000 and Access 2002. I need to create a parameter query that
would ask the following statement: "Enter the work order number".
How would I do this in sql?
Thanks for the help,
Paul ...
Tue, 4 Jan 2005 06:47:03 -0800
|
Regarding SQL Queries - TimeOut Problem
I am doing my search in a 1.3 million records table. I have used FullText
Indexing in that table. I am fetching top 1000 records only, still I am
facing Timeout Expired error in my web application. I am using a DotNet Web
application to do this Search. Is there anything like Indexing Partition in
SQL Serve ...
Mon, 3 Jan 2005 05:27:02 -0800
|
#Temp table question
I'm not sure if I understood this correctly.
If I create a temporary table with the name #SomeTempTab,
can anybody else see this table while I'm using it and before I drop it.
So if two users at the same time trying to create the table with this name
will they be different for each user or there will be a confl ...
Fri, 31 Dec 2004 16:12:06 -0800
|
Running counter
Is it possible to make a query to have a counter which would have
a sequential number of each record in the query starting with 1?
Thanks,
Michael
423 no such article number in group
...
Mon, 27 Dec 2004 13:37:05 -0800
|
Read this for a more simple example
CREATE PROCEDURE dbo.will
(
@a int,
@b int
)
AS
SELECT * from price_view where keydate between @a and @b
GO
Keydate is the The first field in the clustered key
The table is shown in the previous post.
--
will ...
Thu, 23 Dec 2004 13:19:05 -0800
|
Execution plan question
In the proc posted below I should only be hitting the partitions that apply.
But when I look at the execution plan It show me accessing all of them.
The Partitioned tables look like this (on Keydate):
KEYDATE int 4
Priceid int 4
Price smallmoney 4
Seed smalldatetime 4
DocId int 4
Volatility decim ...
Thu, 23 Dec 2004 12:05:01 -0800
|
SQL 7 vs. 2000 issue -trigger and nulls
We're trying to dump our remaining v7 SQL server and update to 2000.
We're having trouble with a trigger updating some tables.
At the beginning, it has this statement:
COMMIT TRANSACTION --This unlocks the Lot table so I can update UDAs,
etc...
BEGIN TRANSACTION
This is what throws the trigger off. I cre ...
Wed, 22 Dec 2004 11:34:54 -0800
|
newbie SP question
Hi, I'd like to create a SP like this:
SP_Table1_LOAD
Update Table1 set... (alter existing rows)
Insert Into Table1... (insert new rows)
This table is a dimension on my DW, I'm used to do this with DTS but I have
never used Stored Procedures before.
Can anyone please help me?
Thanks
...
Mon, 20 Dec 2004 05:01:01 -0800
|
Bookmark lookup (Why)
I can't figure out why i have a bookmark lookup cost on ValidVendorPackages
on the below proc:
Select PriceViewHotelPrice.price as Totalprice, PriceViewHotelPrice.Docid
from price_view PriceViewHotelPrice Inner Join
(
select C1.Priceid as Pid,C1.VendorPackageId from
(
select distinct(HA.PriceId), ...
Wed, 15 Dec 2004 11:55:04 -0800
|
Help with Select statement
Help me with the following query.
I have employee table as follows
EmpID (Number)
FullName (Text)
ReportTo(Number)
ReportTo field contain number from EmpID
Sample Data from the table
EmpID FullName Reports To
1 Nancy Davolio 2
2 Andrew Fuller
3 Janet Leverling 2
4 Margaret Peacock 2
5 Steve ...
Mon, 13 Dec 2004 06:59:08 -0800
|