Hi, Is there any way to insert into table 100 integers from 1 to 100 in one insert statement? Now I have to use loop to insert numbers. I was...

Yo mama

01-28-2008 10:30 PM
Plamen Ratchev

Consider the following two functionally identical example queries: Query 1: DECLARE @Name VARCHAR(32) SET @Name = 'Bob' SELECT * FROM...

Jared

01-28-2008 09:28 AM
Daniel Eyer

I am running MS SQL 2000 server. The table involved is only about 10,000 records. But this is the behavior I am seeing. The local machine is...

quincy451@yahoo.com

01-28-2008 04:01 AM
Jack Vamvas

Hello all, I am looking for help with MS SQL Server 2005. Basically, there is an app I have installed taht runs on the client and talks the MS SQL...

David Williams

01-26-2008 09:04 PM
David Williams

Is it possible to connect to Sql Server 2005 using an Access 2000 adp? I keep trying, but it doesn't want to accept my id, even though it is right.

JA

01-26-2008 10:08 AM
serge

Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions...

alvinstraight38@hotmail.com

01-25-2008 08:51 PM
Jim Johannsen

Hello all, Had a question about CALs and SQL server. From my reading and limited knowledge of SQL Server ( I am not too familiar with as I have...

David Williams

01-25-2008 09:40 AM
David Williams

Hello all, Is there a log of all connection attempts made to a SQL server? The server I have is on Windows 2k. Thanks, David -- David...

David Williams

01-25-2008 07:54 AM
David Williams

Hi, I have a query like this : SELECT x1, x2, ( SELECT ... FROM ... WHERE ... UNION SELECT ... FROM ... WHERE ...) as x3

Hiho

01-24-2008 12:45 PM
Plamen Ratchev

I'm coming from Oracle world and trying to find something similar to rownum in Oracle. I know there exists TOP which normally if used in the same...

Gints Plivna

01-24-2008 05:25 AM
Gints Plivna

Originally I had a temporary table with about a million rows. Now I have some questions about the row counts returned from some queries: SELECT *...

metaperl

01-23-2008 09:16 PM
jefftyzzer

Hi, I am trying to determine the amount of months between today and a date stored in the database. But I cannot seem to figure out get the difference...

mets19@gmail.com

01-23-2008 06:25 PM
Erland Sommarskog

Hello everyone, I imported a DTS package from SQL2000 to SQL2005. The problem is the package fails during validation. That happens because some...

stathisgotsis@hotmail.com

01-23-2008 01:18 PM
stathisgotsis@hotmail.com

Hai all, I developed an application software using VB 6.0 at front end and MS Access 2000 at the back end. The application runs very slow as the...

sheenitmathew@gmail.com

01-23-2008 08:12 AM
Dan Guzman

I had to detach the database to delete the transaction log as it took the hole disk space. No I am trying to attach database, however I am not able...

grzegorz.gazda@googlemail.com

01-23-2008 07:00 AM
Erland Sommarskog

Sometimes at the end of a project you'll end up with unused Tables, Stored Procs, Functions, and Views. Since there is not something like a 'SELECT'...

kellygreer1

01-22-2008 07:00 PM
kellygreer1

My pee-brain cannot seem to grasp what seems quite simple. I am trying to query a single table that stores items and their warehouse locations to...

Artie

01-22-2008 06:42 PM
Artie

Is it possibe to combine the results of these 2 queries into a single result set consisting of 1 row and 2 columns (for each value)? SELECT COUNT(*)...

wackyphill@yahoo.com

01-22-2008 01:39 PM
wackyphill@yahoo.com

I am using ASP and SQL 2005 Express. I am inserting a timestamp from an ASP page using <%=now%> into a smalldatetime field. All of my timestamps...

t8ntboy

01-21-2008 05:39 PM
Plamen Ratchev

I am looking for some help troubleshooting my SQL issue. I have taken over someone else's work, and am now playing catch up. I have an MS SQL db...

RodStrongo1@gmail.com

01-21-2008 05:04 PM
RodStrongo1@gmail.com

I was able to find a few posts on this topic, but none of them quite seemed to fit the situation, so I'm hoping that someone else might be able to...

Thomas R. Hummel

01-21-2008 04:09 PM
Thomas R. Hummel

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: " Database Workbench Pro 3.1...

Martijn Tonies

01-21-2008 03:23 AM
Martijn Tonies

Is there a built in stored procedure that would allow me to list out the database permissions assigned to a particular user or role?

SQL Server

01-19-2008 08:17 PM
SQL Server

This is the default path. The default folders for data and log files can be changed using Enterprise Manager/SQL Server Management studio. Also,...

Dan Guzman

01-19-2008 10:40 AM
Greg D. Moore \(Strider\)

I'm designing a database with 3 tables called Function, Test and Scene. A Function has multiple Tests, but a Test has only one Function. A many to...

bg_ie@yahoo.com

01-18-2008 05:41 PM
Erland Sommarskog

Hi Hope you can help.... What would be the most efficient way to de dup a table I have like 10 columns i need to Check against.... our business...

Analizer1

01-18-2008 10:51 AM
Analizer1

Not all DCL commands accept variables (see BOL syntax) so you'll need to use dynamic SQL. For example: DECLARE @SqlStatement nvarchar(MAX); SET...

Dan Guzman

01-18-2008 08:51 AM
Dan Guzman

I am new to SQL and am trying to sort some information. The data isbeing sorted, but not in the way I desire it to be. Example: Sorted...

SQLLearner

01-18-2008 05:26 AM
Jack Vamvas

Plz can anyone suggest me good sql program for table building, queries.... not Acsess

Mikulenas slavni

01-17-2008 08:37 PM
George Shubin

Begin tran update server1.database1.dbo.table1 set col1=4 where pk=5 update server2.database1.dbo.table1 set col1=4 where pk=5 commit...

Hilary Cotter

01-17-2008 10:30 AM
Hilary Cotter

Please help! I am at my wit's end with this one. I have two tables, SAFs (which contains course information) and SAF_Status (which contains records...

t8ntboy

01-17-2008 06:24 AM
Ed Murphy

I asked this question in the OLAP group but got no response. I am hoping somebody will have some answers here. Thanks ------------------- HI, I need...

Mike K

01-16-2008 01:15 PM
Mike K

On Tue, 15 Jan 2008 05:36:34 -0800 (PST), kevin (AT) nu-urbanmusic (DOT) co.uk wrote: Better ask that question in a Dreamweaver newsgroup. -Tom.

Tom van Stiphout

01-16-2008 01:03 PM
Piero 'Giops' Giorgi

Hello, At our company we are considering building an architecture for file imports and processing and considering both Biztalk and SSIS at...

KR

01-16-2008 11:50 AM
Brad

We have a SQL Server database that can accept data from several different projects throughout our lab. Is it better to (1) let each developer create...

Mike Husler

01-16-2008 05:11 AM
Jack Vamvas

I am connecting to MS SQL 2000 from Red Hat EL4 using freetds and currently running queries to get counts on tables etc. When running SELECT queries...

eeb4u@hotmail.com

01-16-2008 05:05 AM
Jack Vamvas

Hi, I am trying to set up a Updatable Subscriptions for Transactional Replication with SQL 2005 (queued updating). I have a stored procedure...

PatrickW

01-15-2008 07:09 PM
Patrick

Why in the hell doesn't SQL Server provide a facility for dropping an active connection on an attached database in SQL Server Management console? I...

Crazy Cat

01-15-2008 09:46 AM
Crazy Cat

I'm trying to connect to a SQL-Server from Java using code that worked OK before another place: connectionUrl...

Rune Henning Johansen

01-15-2008 05:19 AM
Rune Henning Johansen

We have a 64-bit clustered Windows 2003 R2 Enterprise Edition x64 SP 2 running SQL 2005 Standard Edition SP2. It has 2 Dual-Core AMD Opteron...

serge

01-14-2008 11:06 PM
serge

A couple users at one client are complaining of early morning slowness in their OLTP system. The first thing that came to mind is that the nightly...

Ed Murphy

01-14-2008 10:54 PM
serge

Im trying to design my time dimension and need to add a field to handle null dates in the fact. So if at the time of ETL the date isnt known,...

Jimbo

01-14-2008 10:36 PM
dmcmunn@gmail.com

Here's another game written in T-SQL. Sudoku: http://www.geocities.com/swint002/Sudoku.txt Let me know what you think.

swint002@gmail.com

01-14-2008 09:56 PM
swint002@gmail.com

I've just upgraded to SP2 for SQL Server 2005 STD Edition on Win Server 2003 Ent. Since the upgrade I cant get MS SQL Server Management Studio to...

albertwoomer@yahoo.com

01-14-2008 10:17 AM
albertwoomer@yahoo.com

Hi there -- I'm writing a SQL query that works something like this: SELECT a, b, a/b AS col_name FROM TABLE Dividing a by b can result in a value...

Stephen C. Smith

01-13-2008 07:00 PM
Stephen C. Smith

iis and sql on same box. asp lan app. I can open the initial page but get this error when i try to look up a customer or other db dependant...

jho

01-13-2008 05:46 PM
jho

Is there any log that catches all querys in SQL Server 2000??? Full problem (in slanish): http://foro.hackhispano.com/showthread.php?t=28980 Thanks

Josechu

01-13-2008 10:14 AM
Dan Guzman

How can I get data from table to text-file by SQL-commands, for example SELECT * FROM Table. Result to text-file Table.txt.

Kaitsu

01-13-2008 03:58 AM
Roy Harvey (SQL Server MVP)

I have table that stored business types. I use full text search in that table . I can find the business type but when user enter the worng word or...

akk2006@gmail.com

01-12-2008 11:48 AM
Tom van Stiphout

Hi everyone I am trying to create a DELETE Trigger. I have 2 tables. Table1 and Table2. Table 2 has all the same fields and records as Table1 +...

Yas

01-12-2008 09:53 AM
Erland Sommarskog