|
Update query analyzer grid results?
Is it possible to do updates to a grid result from the
query analyzer?
i.e. select * from ABCD gives a grid result (w/ PK cols),
can I edit one or more fields in the gride and update ?
The help files seem to indicate that it is possible
("Rules for Updating Results"), but I seem to be missing
somethi ...
Tue, 10 Aug 2004 10:40:21 -0700
|
Sorting information using query analyser
Hi all,
I am trying to sort a really large file of information
and I need some help as I cant work out how to get some
of it.
the fields I have are:
csbytes
cscookie
csuriquery
I need to program to get:
A list of the distinct values in cs bytes ( got have done
this one using: SELECT DISTINCT (csbytes ...
Tue, 10 Aug 2004 08:43:02 -0700
|
Restore runs longer in batch mode
I have created a Job that uses "cmcexec" to execute a SQL script. This Job
brings SQL to single_user mode then restores from a directory that is local
to the server.
1) When I run this restore in the GUI it takes 15 minutes but is still
executing
(1 + hours).
2) How can I tell that it is actually runn ...
Fri, 6 Aug 2004 07:27:03 -0700
|
Copy job from one server to another
How do you copy a job from one server to another. Identical databases different servers with different names ...
Thu, 5 Aug 2004 09:03:03 -0700
|
Nick Berg Found Alive
Conspiracy theories of Nick Berg being alive and well in Iraq have today been proven true. Aljazeera have released video footage of the supposedly beheaded American captive. The clip was first "discovered" on an Islamic website in Malaysia and has now been released by
American Journalists colaborating with Alja ...
Tue, 03 Aug 2004 22:48:40 GMT
|
Date calculation
Im relatively new with sql and im having a problem
creating a criteria based on todays date less 150 days.
I tried to use the following...
< GetDate () -150 however it will not let me use this.
I know that there must be away to do this, but I need
help.. Thank you in advance ...
Tue, 3 Aug 2004 10:37:13 -0700
|
Import data
I have a table called cr. Within that table I have the colums c_id,
c_type, first_name, last_name. I need help creating a query that will pull
from an excel file that have the same colum names. This excel file is
automaticaly generated from one of our systems and the c_id will never
change for the record.
So ...
Tue, 3 Aug 2004 08:33:03 -0700
|
new SQL tool, Diana, is here
Hello,
I wanted to bring to your attention a new helpful SQL tool that's coming
out. It enables you to run a search & replace throughout your entire TSQL
code - Stored procedures, Functions, and Triggers. In addition, it helps
you find the database entities you are looking for, across databases and
servers ...
Mon, 2 Aug 2004 21:58:06 -0400
|
Multithreading in Sql server
Does sqlserver 2000 supports multi threading?
If so how can we implement it?
As per my knowledge it supports Symmetric multi
processing.
Can you please confirm this?
Thanks in adavance.
-Sriram
...
Mon, 2 Aug 2004 02:39:17 -0700
|
Querying Multiple SQL Servers in one statement
I currently have information stored on two different SQL
servers. I need to run a query that qeurys both at the
same time making comparisions. I would like to be able to
do this in on select statement. Both machines are on a
local network.
First I need to know if this can be done, and if it can,
if so ...
Thu, 29 Jul 2004 11:19:20 -0700
|
Update
I've Emp table with empno, name, dept. The data for the
dept are A,B,C
I want to update that table Edu for A, Sport for B,....
using self join in single statement.
is it possible?
Regs,
Mottu
...
Thu, 29 Jul 2004 04:22:06 -0700
|
Append Data
Hi,
Appreciated it if someone could help me with regards to
the abovesaid problem.
I don't know how to append data using SQL Query Analyzer
from table a to table b because it will create duplicate
table b.recordnumber(auto number) in table b. I tried to
use DTS but failed due to the duplicate record n ...
Thu, 29 Jul 2004 00:28:31 -0700
|
working with dates
I am trying to join two tables on a date field. My
problem is the hour/minute section. I want to match
07/26/04 on both tables, regardless of the
hour/minute/second piece of the number. I am used to
doing this in Access/Excel by getting rid of the decimal
part of the number, but can't find how to do th ...
Mon, 26 Jul 2004 12:43:28 -0700
|
Count(*) and Like
I have a SQL statement like the below listed inside a
stored procedure.
-------------------------------
declare @cnt int
declare name varchar(250)
set @name = 'aaa'
Select @cnt = count(*) from table1
where name like @name + '%'
select @cnt
--------------------------------
@cnt is always zero, irresp ...
Mon, 26 Jul 2004 04:34:47 -0700
|
time
Hi
i am new in mssql7.before i am using sybase and
some of the tables having field type time.after
convert to mssql7 i changed that field type as timestamp.
i want to store time in that feild.For select and update
query there was no prbm in sybase, but here it is showing
error"The columns data type (columnna ...
Sun, 25 Jul 2004 08:54:24 -0700
|