| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello,
I have 2 tables, Table1 and Table2. I have copied all data from Table1
to Table2.
However Table1 is dynamic it has new rows added and some...
Yas
|
08-21-2007 07:01 AM
Roy Harvey  | 14 | 72 |
| | | HI,
I have a table
Create table test(a int identity(1,1), b int)
insert into test(b) values(12)
insert into test(b) values(30)
insert into test(b)...
satish
|
08-20-2007 06:06 PM
Roy Harvey | 3 | 36 |
| | | Hi,
What is the SPID column for in SQL Profiler?
I have many databases but I only want to view the transactions on one
particular database. What...
wesleym312@gmail.com
|
08-20-2007 05:56 PM
Erland Sommarskog | 3 | 46 |
| | | Data Cleansing:
In the example (SQL Server DDL below) there are two tables -
ExampleCustomer, and ExampleCar.
ExampleCar is a lookup table. The...
teddysnips@hotmail.com
|
08-20-2007 05:52 PM
Erland Sommarskog | 2 | 37 |
| | | I have been using NewID but was advised to use TABLESAMPLE as it would
be more efficient - unfortunately I can get it to work properly.
This comes...
WhytheQ
|
08-20-2007 10:48 AM
WhytheQ | 2 | 54 |
| | | And here's another thing that's gives me pause for thought (for other
information see the thread entitled "ODBC Timeout problems but very
hard to pin...
teddysnips@hotmail.com
|
08-20-2007 07:03 AM
teddysnips@hotmail.com | 8 | 44 |
| | | Hi,
Anyone know an online source for database schemas, or schemas for single
tables i.e. where can I download a schema for an addresses...
Rich
|
08-19-2007 01:32 PM
--CELKO-- | 4 | 57 |
| | | SQL Server 2005
We have a table where the current identity value is lower than the
maximum value. This is the first time I've seen such a thing. ...
Bill E.
|
08-19-2007 12:02 PM
Erland Sommarskog | 5 | 47 |
| | | On Aug 17, 6:24 am, "Rico" <m... (AT) you (DOT) com> wrote:
GLAFS
FIscal sets one to 5
john@aspaccounting.com.au
|
08-19-2007 08:45 AM
john@aspaccounting.com.au | 0 | 42 |
| | | Chris.Cheney (Chris.CheneyXXNOSPAMXX (AT) tesco (DOT) net) writes:
I assume that you mean the point on NULL values.
Consider the script below....
Yas
|
08-19-2007 08:17 AM
Erland Sommarskog | 7 | 44 |
| | | Hi guys..
is there any query to do this action:
i want to combine view record into a single record.
exm.
table 1
Name A B
Jack 10 ...
dede
|
08-18-2007 05:17 PM
Erland Sommarskog | 1 | 53 |
| | | To view best Tutorial on SQL Server and XML Programming visit this
site
http://it-techtutorials.com/Trainings/SQL/Sql01.asp
future.revelation@gmail.com
|
08-18-2007 01:30 PM
future.revelation@gmail.com | 0 | 104 |
| | | On Fri, 17 Aug 2007 08:12:21 +0200, Søren Reinke wrote:
Hi Søren.
Here's the response of Peter DeBetta:
"I just added the main feed to pageflakes...
WhytheQ
|
08-17-2007 07:01 PM
Hugo Kornelis | 8 | 45 |
| | | I have a small database that I have been testing.
I get an error about a transaction deadlock.
The code is in stored procedures and I added...
steven
|
08-17-2007 06:07 PM
Erland Sommarskog | 4 | 99 |
| | | Hi,
I'm using the following code to open a data base and show it's content
in a Data Grid View
----
Code
-----
Imports System.Data.SqlClient
Private...
Omar Abid
|
08-17-2007 11:27 AM
Omar Abid | 6 | 46 |
| | | How I can call an oracle function from SQL SERVER 2000 stored
procedure. Anyone?
ind_123
|
08-17-2007 10:02 AM
ind_123 | 0 | 47 |
| | | I've a SQL 2005 with a certain number of db.
Until today i was the only admin of all dbs.
Now i need to give to another admin permission to manage...
bertainafederico@gmail.com
|
08-17-2007 09:01 AM
bertainafederico@gmail.com | 4 | 44 |
| | | One of our clients has reported a problem. Everything was working
fine on Monday, but since Tuesday all is going wrong. The sysadmin
assures me...
teddysnips@hotmail.com
|
08-17-2007 06:18 AM
Erland Sommarskog | 5 | 42 |
 | | I'm trying to restore a database backed up a production machine onto
my development machine. I don't want to restore the transaction logs
(there are...
Bill E.
|
08-17-2007 04:58 AM
Bill E. | 5 | 299 |
| | | Ho un server SQL 2005 con N db.
Al momento ho sempre amministrato tutti i db autonomamente e dunque
con un singolo amministratore.
Ora mi è sorta la...
bertainafederico@gmail.com
|
08-17-2007 02:57 AM
bertainafederico@gmail.com | 4 | 64 |
| | | I am trying to a simple insert statement from a remote application
against a sql server 2005 database. To fix the problem I was having,
I had to...
rhaazy
|
08-16-2007 06:18 PM
Erland Sommarskog | 5 | 43 |
| | | Hello all, I am still learning about SQL, and have a question. I have
two tables. I want to update table 2 with data from table 1. Table 1
has two...
ceconix
|
08-16-2007 06:06 PM
Erland Sommarskog | 1 | 47 |
| | | hi
my table having record
cust_name
sachin's
vishal's
sumeet
rajesh
sachin shah
|
08-16-2007 07:48 AM
PDreyer | 1 | 42 |
| | | Here is my code
ALTER PROCEDURE Test
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET...
gancy26@gmail.com
|
08-16-2007 06:50 AM
Erland Sommarskog | 1 | 43 |
| | | Hi All,
1. i want to transfer the .csv file data into sql server table, i
tried with the DTS but while creating DSN it not prompt to attech
the...
sachin shah
|
08-16-2007 05:16 AM
sachin shah | 2 | 56 |
| | | We have received a backup file that is 6G in size. The log file is
about 74G while the MDF is about 5 G when we restored. Is there a way
to run a SQL...
GM
|
08-16-2007 04:39 AM
Bill E. | 1 | 50 |
| | | Hi all
i want result as month name from my query
i tried with the following query but it give result as month number
like (8)
select...
sachin shah
|
08-16-2007 04:38 AM
stephen | 2 | 50 |
| | | Hello all, I was just awarded the job of maintaing the database server
for our company. I have basically ZERO experience using MS SQL Server
2000....
scott s
|
08-15-2007 05:38 PM
Erland Sommarskog | 2 | 45 |
| | | Is it possible to use sql to execute a batch file? I would like to
execute the following "C:\BTW\bartend.exe /f=C:\BTW\Toolbox\Formats
\carnum.btw...
mcolson
|
08-15-2007 05:21 PM
Erland Sommarskog | 6 | 58 |
| | | Hello,
I ran a query that I thought would take an hour, but instead took 14
hours to run. The consequence was it bogged down our data warehouse
and...
rcamarda
|
08-15-2007 05:18 PM
Erland Sommarskog | 3 | 51 |
| | | Hello,
I have a table containing user data. Each row has user data and last
column of each row has current date in the format:...
Yas
|
08-15-2007 02:57 AM
Erland Sommarskog | 5 | 46 |
| | | I have recently updated the stored procedure and now I am getting
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14' .
Invalid column...
Bhavna
|
08-14-2007 05:19 PM
Erland Sommarskog | 1 | 46 |
| | | Hi,
Would like to know the performance differenece between Multi-column
Index vs Single Column Indexes. Let's say I have a table with col1,
col2,...
Sonny
|
08-14-2007 11:15 AM
Alex Kuznetsov | 2 | 57 |
| | | Hello,
Is there any possibility to replicate SQL Server 2005 database into
PostgreSQL?
I have found, that the non-sql subscriber types list is...
Mr Pear
|
08-14-2007 09:56 AM
Mr Pear | 0 | 43 |
| | | select pippo
from
(
select person.name as pippo
from person
)
This query run in oracle....in sqlserver no!
what can i do!?
thank's
dario.8282@hotmail.it
|
08-14-2007 06:50 AM
Tony Rogerson | 1 | 41 |
| | | Right now, a client of mine has a T-SQL statement that does the
following:
1) Create a temp table.
2) Populate temp table with data from one table...
imani_technology_spam@yahoo.com
|
08-13-2007 06:01 PM
Erland Sommarskog | 1 | 45 |
| | | There seems to be a lot of confusion around the groups about linking
to an Access mdb with the SQL Server Jet OLE DB provider and I havent
been able...
BillCo
|
08-13-2007 07:06 AM
BillCo | 1 | 33 |
| | | urls/ free downloadbable tutorials
Hi,
Can anybody send me some useful urls / free downloadable tutorials for
learning and deveploment under...
Rahul
|
08-13-2007 06:44 AM
Rahul | 0 | 49 |
| | | Hi Friends,
Is it possible to pass a table as a parameter to a funtion.
whos function declaration would look some thing like this....
ALTER FUNCTION...
ArunDhaJ
|
08-12-2007 02:09 AM
steve | 18 | 106 |
| | | I am trying to execute a batch file using xp_cmdshell: EXEC
xp_cmdshell 'c:\testing\runbattest.bat'
When I do this, I get an output that says...
mcolson
|
08-10-2007 09:38 AM
mcolson | 0 | 44 |
| | | www.bootstraptech.com
Bootstrap Technologies Private Limited, Global Systems integration and
IT Services Company with a Focus on Enterprise...
bootstrap
|
08-10-2007 06:45 AM
bootstrap | 0 | 41 |
| | | www.bootstraptech.com
Bootstrap Technologies Private Limited, Global Systems integration and
IT Services Company with a Focus on Enterprise...
bootstrap
|
08-10-2007 06:40 AM
bootstrap | 0 | 44 |
| | | I am currently running SQL Server 2005 on a stand alone (not a domain
member) Windows Server 2003, this server was installed during setup
using local...
sailorfej
|
08-09-2007 03:37 PM
sailorfej | 0 | 46 |
| | | Hi!
I have the DB, now with about 100 Million rows (Going strong!!!)
One question... I'm using Thesaurus search (COOL!!!) for names,
(Rebecca,...
Piero 'Giops' Giorgi
|
08-08-2007 01:29 PM
Piero 'Giops' Giorgi | 0 | 49 |
| | | Is there any Senior SQL DBA Consultants available for projects ? If
so, please send across resumes with rate and availabilit to
ittkrish (AT) gmail...
ittkrish@gmail.com
|
08-08-2007 10:11 AM
ittkrish@gmail.com | 0 | 65 |
| | | I am currently using ADO from an application to connect to SQL 2005. Is this
the preferred way, or is that the most common method? I was told I need...
Charlie
|
08-07-2007 11:49 PM
Dan Guzman | 1 | 46 |
| | | hi there,
Just wondering if anyone can offer any advice on an a SQL performance
issue i have repeatedly come up against in work. I am a sys admin...
Fox1977
|
08-07-2007 06:52 PM
Hugo Kornelis | 3 | 43 |
| | | Hello,
We have MS SQL Server 2000 and recently we found out that right
clicking on a database and selecting properties would lock up the
enterprise...
Skeptical
|
08-07-2007 04:58 PM
Skeptical | 0 | 46 |
| | | I'm trying to automate an auto-export of a table on a daily basis,
using BCP. I'm using native format for the BCP because the text in
one of the...
M Bourgon
|
08-07-2007 10:09 AM
M Bourgon | 7 | 42 |
| | | Hello -
I am researching consolidation and management utilities for both SQL
2000 and 2005 and I was hoping there might be someone out here who...
rwyarger@hotmail.com
|
08-07-2007 09:53 AM
rwyarger@hotmail.com | 0 | 45 |
