8051:
DateTime columns in SQLexpress and .NET 2.0 DataAdapter.Update()
8052:
make window not appear in task manager
8053:
How to receive selected field in a stored proc in calling stored proc
8054:
Is it possible to recreate my database from a myDatabase.BAK file?
8055:
Running Balances
8056:
Daily Notification Stored Procedure
8057:
Crosstab; Sum() or Group BY
8058:
PIVOT Question ...... need sum of the resultant pivot rows
8059:
List all the tables and primary keys
8060:
HOW TO REMOVE THE USELESS CONNECTION IN DTS PACKAGE (2000)
8061:
how can i query same table in different databases
8062:
Database Script Does Not Account for Dependencies
8063:
using a varable as a column select
8064:
need tsql help, please
8065:
Help with Join Statement
8066:
SQL Server Event: Advanced Manageability for Analysis Services 200
8067:
I've problem with Insert
8068:
Problems with smalldatetime
8069:
Changing the Order of the Columns within a Table
8070:
select abs(?) a from test, can this be prepared
8071:
Select help needed
8072:
sp_send_dbmail
8073:
CLR (VS2005) assemblies
8074:
Newbie needs help on best how-to, step-by-step 'book' for C# 2.0 ADO.NET 2.0 C# databases--BUT USING THE WIZARD!
8075:
TSQL question
8076:
bug in exception handling (try/catch)?
8077:
When using the same name for an alias as for a column in a table
8078:
General advice on scheduling data structure
8079:
Getting Rid of Extra Log file
8080:
Stored proc that takes 10+mins blocks other queries
8081:
T-SQL equvialent to PL/SQL Number
8082:
Transact SQL Books
8083:
quick question, DATEPART function
8084:
Dynamic Update stored procedure??
8085:
Computer Security Information (Free Articles and eBooks)
8086:
Replication on SQL Server 2000
8087:
«æ! ¤â¾÷²M³f5§é°_
8088:
select & insert *SP function.
8089:
insert cr-lf into dynamic sql
8090:
changing a format of a money value to only two decimals
8091:
How To Evaluate a Business Opportunity ***
8092:
World Wide SQL Server Community Launched
8093:
Reregister DLL's
8094:
How to find current procedure name and line #
8095:
Find details about the computer who caused an error
8096:
Store Procedure Syntax Help
8097:
T-SQL Statement to generate a weekly total (week of the 3rd sunday of month only) and a yearly total averaging each month's week (3rd sunday week) total
8098:
Given a temp table, how can one script its DDL?
8099:
No idea where to start with Query
8100:
UPDATE in a UDF
8101:
How to execute SQL script on machine with no Query Analyzer or SQL Tools installed?
8102:
SQL calls VB calls C++ problem - perhaps SQL 2005 problem
8103:
Syntax of OSQL.exe
8104:
DBCC
8105:
Determine inserted columns
8106:
select
8107:
Collation problem
8108:
Matrix Table
8109:
First record converts 1 to 10
8110:
select where date in unix time column problem
8111:
how to get first n record from a sql result
8112:
SQL calls VB calls C++ problem - perhaps SQL 2005 problem
8113:
finding CASE
8114:
Sql 2005 single user mode: change back to multi user ?
8115:
Application Roles in SQL Server
8116:
Specify Processor to use
8117:
Select MAX and Store procedure question
8118:
Clustering Disadvantage
8119:
where are the index stored in SQL SERVE 200
8120:
Math problem on T-SQL
8121:
openxml and xpath
8122:
How can I update two or more columns in c# string?
8123:
Problems getting records from a stored Procedure into a recordset
8124:
change the time part
8125:
How to move MSSQL database to Oracle for a single customer?
8126:
Localization design question
8127:
NULL
8128:
SQLServer 2005
8129:
Help with this query
8130:
Problem with WHERE
8131:
Add contraint to table with VIEW with SCHEMABINDING using it
8132:
Complex query to combine records
8133:
newbie: T-SQL code doesn't recognize table column
8134:
Pulling my hair out
8135:
Oracle Linked Server
8136:
Not-Locking on Insert
8137:
dropping snapshots
8138:
Who is the last person updated a record of a table.
8139:
How to retrieve all records from 30th record to 50th record of a table?
8140:
Complex query
8141:
Programming Language with SQL Server ?
8142:
A Must Read!!!
8143:
Select * from a table based on a select distinct column value from the same table
8144:
SS2K5 Express and Pro Together On One Dev Box
8145:
Join on float and varchar
8146:
Select Query: Incorrect Result
8147:
List as an aggregate function...
8148:
Calling a view within a sp
8149:
Help with BCP Data file
8150:
MCITP: Database Administrator
8151:
Unexpected result from NOT IN
8152:
Query Help
8153:
group by query
8154:
UTC converted to local time, current and historical?
8155:
Run SQL statement in Query Analyzer as...
8156:
Run SQL statement in Query Analyzer as...
8157:
Run SQL Statement in Query Analyzer As...
8158:
2005 MCDBA
8159:
Why cann't I delete or edit my data in a table?
8160:
SQL Query help
8161:
Using OPENROWSET not returning all columns
8162:
Select Query Analyzer and then select "Run as..."
8163:
xml parameter
8164:
lock a table
8165:
Update query not working
8166:
Subquery returned more than 1 value
8167:
Problem with ISNUMERIC function
8168:
How to back up SQL Server 2005 database to 2000 format
8169:
Returning the lowest price
8170:
Use of a reserved keyword in a query
8171:
sys.database information available in 2000
8172:
Conditional Join Condition
8173:
Procedure Cache Issue? (SQL Server 2005 EE, Service Pack 2)
8174:
Update failed to an image field when data > 256 MByte
8175:
Speed of Stored Procedure
8176:
MSSQL Group By
8177:
Cannot create new connection because in manual or distributed tran
8178:
Do you know what the Sql CTE really is?
8179:
The Two Standards of the Sql CTE
8180:
Invalid Column Name
8181:
Create Database fials
8182:
Manage data between 2 databases
8183:
declare a variable for entire batch
8184:
SQL Question on a table
8185:
datetime insert into error
8186:
Query to find duplicate rows
8187:
Need help with a query
8188:
I need a table valued function that returns records from two possible tables...
8189:
SQL Server Express CPU limitations
8190:
advice on sql server 2005 compact edition use
8191:
Running reporting queries without killing the production server.
8192:
Is this a bug? - Change the Collation of a Not Null Text column.
8193:
DTS Hanging
8194:
Last try: Polling the network for SQL servers, including named instances
8195:
Help With Ordering
8196:
Help with error handling
8197:
check if bitvalue is in integer
8198:
Default value
8199:
XP_SMTP_SendMail extended stored procedure
8200:
How to LOCK a table for INSERT and UPDATE, but not SELECT for duration of SqlTransaction?
8201:
Grouping Records By Day
8202:
Alternate to cursors
8203:
INFORMATION_SCHEMA indexes
8204:
Adding a wildcard to a stored proc parameter
8205:
Automating a Stored Procedure
8206:
Transparent Data Encryption
8207:
Get Login and Password for first time after install...
8208:
monitor anny data change with trigger on Table and database level
8209:
SQL automation
8210:
Queries on a certain table not using indexes
8211:
SQL Server 2008 ETA
8212:
Using CLR to compress data [SQL2005]
8213:
complex table combine multiple rows into one
8214:
sql question
8215:
sql question
8216:
default value (0) necessary?
8217:
Good T-SQL programming book wanted
8218:
Record matching based upon dates and duplicate field values
8219:
Session activity view
8220:
Why programmers don't like DB(A)s
8221:
Redirecting named pipes to instance
8222:
averaging all employees
8223:
Regarding transaction and lock
8224:
Leading Zeros with OpenRowSet
8225:
avg vs average
8226:
Calendar/business day logic
8227:
logging adhoc updates
8228:
Date diff for specific dates
8229:
print statement help
8230:
Use of function ???
8231:
Javascript and CDO...
8232:
How to select
8233:
sql server 2000 error
8234:
sql server 2000 error
8235:
Date/Time querry handing ??
8236:
Auditing data on SQL 2000
8237:
How to check the amount of concurrent users in a database?
8238:
How to check the table schema for Stored Procedure output
8239:
Functions in SQL 2005
8240:
FK Naming
8241:
sql server 2000 question
8242:
How do I use the FIRST function in T-SQL or replicate this behaviour?
8243:
Deadlock doing ONLY a Select
8244:
Traversing Hierarchy Structure w/ CTE
8245:
How to Return Inclusive Rows for DateTime Data Type
8246:
SQL 2005 linked servers and try / catch
8247:
Date Restrictors for Last Week and This Month
8248:
Update Top 500000 in SQL 2000 on large dataset
8249:
Query of Linked Server
8250:
Not getting new id from sp
8251:
negative sign instead of parentheses
8252:
begin try begin tran or begin tran begin try
8253:
Initialize Auto-Incremental, Unique field?
8254:
xp_sqlmaint
8255:
Services
8256:
Disk to Same Disk
8257:
Typed Dataset and identites - Commit entire Dataset
8258:
Conditions within a SELECT
8259:
how to reach database in distributed environement??
8260:
Join Question
8261:
Advice for database driven website
8262:
Performance issue with partitioned table
8263:
A severe error occurred on the current command - help
8264:
outer join: how would you . . . ?
8265:
How to get TotalRows using row_number()
8266:
Trigger question
8267:
Send mail from SQl Server 2000
8268:
implications of not using sp_helplogins
8269:
xp_cmdshell
8270:
Problem in system tables (SQL Server 2000)
8271:
xp_cmdshell
8272:
Straneg behaviour with Set Quoted Identifier
8273:
Displaying the same records for multiple time
8274:
Using Wildcards with COALESCE
8275:
Time between Execute and direct request
8276:
Selecting distincting records
8277:
How to modify the column size without affecting the data in column.?
8278:
SQL Syntax error joining two queries
8279:
Arithmetic error when running a script
8280:
Join
8281:
Import MSAccess to MSSQL
8282:
Configure settings with SMO
8283:
Where can I post SSIS (SQL server Integration Services) Questions?
8284:
Average
8285:
Count
8286:
Compiling Procedures with Incorrect Column Names - Shouldn't the c
8287:
Different Date Format ?
8288:
number of days since latest high score
8289:
3 digit comma grouping help
8290:
run_status on sysjobhistory
8291:
"Group By" Aggregation in Cube?
8292:
<newbie> setting dbowner of a database
8293:
Sql Server 2005: Set Default value for datatime column to NULL
8294:
Simple table structure question ???
8295:
CPP32
8296:
Simple question on triggers
8297:
GetDate() question
8298:
Help, how to openrowset an unicode text file?
8299:
SQL Injection Demonstration
8300:
SQL Injection Demonstration
8301:
Drop ##table doesn't drop table
8302:
Syntax problem with Date restrictor
8303:
How to total a column
8304:
Meaning of @ in parameter names
8305:
How to track down this error
8306:
Full Outer Self Join problem
8307:
change day of date variable to 1st
8308:
Recursive SQL Query
8309:
102nd Birthday of E=mc2 ( 27 Sep 1905- 27 Sep.2007) Complete tribute in book Einstein's E=mc2 generalized , www.ajayonline.us
8310:
Parameter sent to MS SQL 2000 from Powerbuilder
8311:
(restricted user) after restore
8312:
varchar(max) and 8k limit
8313:
Timing Alert Query
8314:
Performance of query on partitioned table without partition key
8315:
LINKED SERVER QUERY PROBLEM ON SQL 2005
8316:
Service Broker Locking
8317:
troubleshooting deadlocks in sql2k
8318:
shorthand syntax
8319:
Modeling Inheritance - Best Practice Question
8320:
PIVOT / UNPIVOT
8321:
Sub: SQL Server Query cost serial number
8322:
Retreiving data from system tables
8323:
the AIM of LIFE
8324:
Silly Date/Time Algorithm
8325:
Group data
8326:
Join Question
8327:
Need help with query
8328:
SQL Server and delay writes
8329:
Having issues on and off with this page
8330:
SQL Server not liking where clause
8331:
"USE" command with SQL Server Express
8332:
SQL syntax problem
8333:
Index Defrag - Clustered vs Non-Clustered
8334:
sp_OACreate fail for the second call
8335:
lock question
8336:
default value question and temporary tables
8337:
Which is better DISTINCT or GROUP BY performance
8338:
recovering from Select expression error?
8339:
Passing Part of an SQL-Statement to a Stored Procedure
8340:
SQL syntax error
8341:
Which version is right for Vista Home Premium
8342:
Backup statement won't work with Stats=10
8343:
when max() does not yield a valid maximum
8344:
dynamic column name
8345:
parsing c style strings with variable arguments in a table
8346:
problem - including null values in query
8347:
Is this 3NF?
8348:
how to write a query to find all the users and their database permission?
8349:
Endpoints with Port other than 80?
8350:
Using full-text with joins and sum
8351:
Insert takes to long !
8352:
Is it possible to do it in a single SQL statement?
8353:
Deleting undo file in a restore
8354:
Bulk Insert after validation of uniqueness - SQL Query
8355:
Need help in the process of moving/copying the .LDF file
8356:
sql server 2005 editions requirements
8357:
xp_cmdshell
8358:
Group by and having causes time out
8359:
Name Table
8360:
No primary key ?
8361:
Default value not less than 0
8362:
SQL Server 2005 Schema / Permissioning Question
8363:
SQL Query from Access to SQL Server
8364:
please help
8365:
Restoring 2 versions of the same base
8366:
How to check database is replication database
8367:
Multiple databases or single database, that is the question
8368:
OPENROWSET error and SQL service restart
8369:
Does anyone know any available tool used for viewing the impact on database and stored procs from changes
8370:
SQLCMD rows affected
8371:
sum a difference
8372:
FOR XML AUTO query doesn't work on 2005
8373:
using numeric/decimal types in stored procedures
8374:
GetDate() - 93 OK to use?
8375:
pivot
8376:
Linking Tables on a Calculated Field
8377:
How to get a total sum
8378:
query question
8379:
Repost: Polling the network for SQL servers, including named instances
8380:
SELECT query
8381:
Standby problem
8382:
Complex Query for Stock quote
8383:
t-sql for alter table to change field to identity
8384:
Question regarding "HAVING COUNT(*) = 0"
8385:
Question about optimization
8386:
DECLARE question
8387:
Multiple Matching Rows Problem - how to avoid a cursor
8388:
Query question
8389:
Select
8390:
Best method to Query an (ItemA, ItemB, MixResultC) table where...
8391:
Object already in database.
8392:
BOL
8393:
Mirroring and Restoring Databases
8394:
How to use - exec sp_repladdcolumn
8395:
Basic Question
8396:
Simple query question
8397:
Performance Issue
8398:
Exporting data from a MSSQL 2005 database
8399:
Return Error Code
8400:
dynamic column name