|
what is print in sql server 2000?
I have the ff. code:
declare @CurrentDate datetime
set @CurrentDate = 2003/7/11
print @CurrentDate
The query returns:
Jan 27 1900 12:00AM
-----------------------------------------------
Is this returned value the same as the ones returned by a select statement?
What is this basically used for?
"To teach is to learn twice"
|
|
|
|
|
Under SQL Server 2000, is it possible to review the transaction log for a specific database? If so, how?
Semper Fidelis
|
|
|
|
|
On http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm[^] I found this:
8. DBCC log
This command is used to view the transaction log for the specified database.
Syntax:
DBCC log ( {dbid|dbname}, [, type={-1|0|1|2|3|4}] )
PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.
type - is the type of output:
0 - minimum information (operation, context, transaction id)
1 - more information (plus flags, tags, row length, description)
2 - very detailed information (plus object name, index name,
page id, slot id)
3 - full information about each operation
4 - full information about each operation plus hexadecimal dump
of the current transaction log's row.
-1 - full information about each operation plus hexadecimal dump
of the current transaction log's row, plus Checkpoint Begin,
DB Version, Max XDESID
by default type = 0
To view the transaction log for the master database, run the following command:
DBCC log (master)
Also, there are some third-party tools that will let you look into, and manipulate db-logs...
|
|
|
|
|
This is what I needed.
Thank you for your help.
Semper Fidelis
|
|
|
|
|
Hi all,
I am working on a tool to execute sql files(something like Query Analyzer) using ADO.Net & C#. I try to add a function which can cancel any executing queries. To achieve this, I think I need to use multi-thread. I want to create a thread to execute the sql, meanwhile, if user click the cancel button, then create another thread to stop it. I believe it can work, but because I am a very beginner in these(ADO.Net, C# & multi-thread ), I can not work it out now. Please help!
Thanks in advance!
yyf
|
|
|
|
|
|
HELP
Can anybody help me with a short and simple guide on how to create an access 2000 database and being able to update it using .Net.
If we can start with a simple address book that somebody can or know of a site with help.
Anything will be appreciated.
Thanks
|
|
|
|
|
Hey
How can i run a query which can be an insert/update query from one database referring another database.
For example
i need to insert a row in my database1.table1 from database2
thanks
Cheers,
Venkatraman Kalyanam
Bangalore - India
"Being Excellent is not a skill, it is an attitude"
Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
|
|
|
|
|
Is this- Two SQL Server databases on the same server instance
- Two SQL Server databases on two different server instances
- Not SQL Server at all?
If the first or second:
You can reference any object in SQL Server (table, view, function) by a full name: server.database.owner.object . The first three can be omitted when referencing an object in the same database as you're currently accessing; owner is typically only used to disambiguate where two users have an object with the same name, although functions require the owner part.
The simplest syntax for referring to an object in another database on the same server - say you wanted to access the titles table in the pubs database is pubs..titles (note the two dots, signifying that the owner of titles has been omitted).
If you want to refer to an object on another server, you need to set up a linked server, which you can do in Enterprise Manager, under Security > Linked Servers.
I believe Access has the concept of foreign tables.
|
|
|
|
|
Hi,
I'm retrieving the changes from a dataset and creating an XmlDataDocument
for transport to a web service, however any rows with a RowState of Deleted
don't get propagated to the XmlDataDocument...is there something that I'm missing?...
Any help would be appreciated as I'm slowly going out of my mind .
Regards
Kieron
|
|
|
|
|
Hi !!
does anyone know how to do an autonumbering index when creating a new table with SQL ?
Thanks !
Jerome
|
|
|
|
|
What SQL implementation are you using?
- Mike
|
|
|
|
|
It will be crossdatabase : Access, MySQL, SQL Server and Oracle (and maybe some others)....
|
|
|
|
|
As far as I know, every SQL implementation has a different way of making autoincrement columns, e.g., MySQL uses the AUTO_INCREMENT modifer, Oracle uses sequence objects, PostgreSQL uses the SERIAL type, SQL Server uses IDENTITY , etc.
- Mike
|
|
|
|
|
These may be a stupid questions, but I have not been able to figure it out except for having a SPs that are slightly different.
Is it possible in a MS-SQL Server T-SQL Stored Procedure to do something like this pseudo code:
SELECT SUM(Amount) FROM Sales
if @StoreID > 0
then WHERE StoreID = @StoreID
else WHERE StoreID > 0
And also something like this, where @StoreID is a comma delimited list of StoreIDs
SELECT SUM(Amount) FROM Sales
if CAST(@StoreID as integer) > 0
then WHERE StoreID = @StoreID
else WHERE StoreID IN (@StoreID)
Note: My SELECT statements are much (much) more complicated than this. These where minimized for clarity.
Maybe I guess the real question is "even if I can do this, should I"? I am trying to minimize the business logic and the number of different SPs I have.
Thanks in advance,
Konstantine
|
|
|
|
|
The first can be done in a rather roundabout way:
SELECT SUM(Amount)
FROM Sales
WHERE
StoreID > 0 AND
StoreID =
CASE
WHEN @StoreID > 0 THEN @StoreID
ELSE StoreID
END This basically works by comparing the StoreID in the table against itself when the variable @StoreID is not greater than 0 (always TRUE, unless you've got any NULL s in your data), as an extra filter clause. It's sometimes possible to exploit these conditions, but you should check the impact on the execution plan in Query Analyzer (it might cause an index to be rejected, leading SQL Server to read every row, killing your performance ).
For the second one, I refer you to http://www.algonet.se/~sommar/arrays-in-sql.html[^] (link found from http://sqljunkies.com/weblog/[^]).
|
|
|
|
|
Mike,
Thanks for your reply.
That is a nice trick. I will give it a try and see how good/bad the performance works out.
Thanks for the links too. I search for a long time and never found anything nearly that useful.
Konstantine
|
|
|
|
|
I am wondering if this is possible with one query?
I want to sum some values based off different customer id values,
for instance:
select sum(value1) as value1_total where customer = '1111'
but also sum(value1) where it equals a customer of '9999'
Thanks,
Chris
|
|
|
|
|
CREATE PROC up_MyTotal
@id INT
AS
select sum(value1) as value1_total where customer = @id
The call teh stored proc twice
|
|
|
|
|
SELECT customer, sum(value1)<br />
FROM my_table<br />
GROUP BY customer
or
SELECT customer, sum(value1)<br />
FROM my_table<br />
WHERE customer IN ('1111', '9999')<br />
GROUP BY customer
|
|
|
|
|
I use a DataView to sort and filter information. How do I get specfic cell out of the DataView? For example I use the DataRowView to display the entire Row. The row appears like this 1 5 10 7 9. Each number represents a different column. I need to get each number indivdually and pass it to a local variable I have created.
myId = 1.
myOtherId = 5.
Any ideas.
thanks
|
|
|
|
|
I want to select some information from one server and join it to another servers information in a query. Is this Possible?
QMuffs
|
|
|
|
|
|
Worked great. Thank you for your time.
QMuffs
|
|
|
|
|
I need help constructing a query for my database application. Please use notepad to view the text file below for the problem's description. Thanks.
http://www.nghiep.com/sqlhelp.txt[^]
|
|
|
|