Posts tagged with sql by apark

Related tags:
database + (53)
mysql + (32)
query + (21)
access + (16)
server + (14)
resolved + (14)
programming + (11)
php + (11)
mssql + (6)
databases + (6)
Windows + (6)
sqlserver + (6)
oracle + (5)
Data + (5)
microsoft + (5)
dba + (4)

Users that often use this tag:
DakotaPaul (6)
arrowhead (3)
odinsdream (3)
Glendale (2)
omnipotentq (2)
desjardins (2)
maxwelton (2)
adipocere (2)
bleucube (2)
inigo2 (2)
apark (2)
mark7570 (2)
Wild_Eep (2)
Four Flavors (2)
AllesKlar (2)
derbs (2)
eas98 (2)
benjh (2)
dnash (2)
Nothing (2)

How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted by apark on Jan 24, 2007 - 5 answers

I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark on Apr 7, 2006 - 6 answers