25201:
cant figure out how to write query..
25202:
Mother Celko's Monday SQL Puzzle #2
25203:
limit size of image column
25204:
Converting mixed text to number
25205:
UNIQUE INDEX AND ERROR HANDLING
25206:
How can i remove IDENTITY by ALTER TABLE?
25207:
List of tables used in query
25208:
IDENTIDY row as bigint?
25209:
Is this a known issue?
25210:
Enterprise Manager rewriting my SQL...is this OK?
25211:
show the records dependent on some conditions
25212:
Regarding security (sql2k/sql25k)
25213:
DATEADD Issue
25214:
check constraints
25215:
Normalization Problem
25216:
Delete Duplicate records in Temp Table
25217:
Sql Server 2005
25218:
PRIMARY key versus UNIQUE index
25219:
Indexed view max and min
25220:
Using variable in from clause in declaration of a cursor
25221:
log file full
25222:
perform aggregate function & group by
25223:
I love using IDENTITY
25224:
SQL SIMPLE result sent in Oracle stored procedure
25225:
Datetime string
25226:
Security Roles
25227:
Stored procedures using C# code?
25228:
345 free programming books
25229:
sql2000 - multiple update calling SP only once
25230:
Columns to Rows - Group By count
25231:
What are minimal permissions required to create database and ...
25232:
Power user question
25233:
what sql datatype
25234:
SSIS Package
25235:
How to script permissions?
25236:
VS CLR SQL Templates missing (File - New - Project -> Database -> SQL Server)
25237:
SQL Server oddity
25238:
best practice - building trees
25239:
Menu Hierarchy Display Order (Recursion)
25240:
Textcopy and nText problems
25241:
SQL Server Best Practices Analyzer -- Suggestions?
25242:
Joining Question
25243:
How to determine columns that are part of an index.
25244:
Rand
25245:
Multiple column unique constraint
25246:
VS2003 and SQL Server 2005
25247:
Retuning rows as a single string
25248:
How to performance case-insensitive search on XML data type in SQLServer 2005?
25249:
Executing a SPROC from a View
25250:
Place count in variable
25251:
URGENT!! I need to attach a db...
25252:
Can SQL Server run in Linux?
25253:
Error Reporting from Stored Procedures
25254:
How to page SQL query result returned from FOR XML statement?
25255:
Database or Server?
25256:
t-sql debugger breakpoints
25257:
undating tables
25258:
ALL STORED PROCS RETURNING NOTHING BUT NULLS IN OUTPUT PARAMETERS
25259:
ignore duplicate key
25260:
Syntax error calling udf
25261:
Optimizing SQL Query performance
25262:
DTS Packages using c#
25263:
Delete trigger capturing text data
25264:
ORDER BY CASE
25265:
Running DTS packages in C#
25266:
Query to show column dependencies
25267:
How to apply SQL Server 2000 Service Pack 4 on Active\Active clust
25268:
Reg: SqlServer Data Type
25269:
SQL Server 2005 : Database settings
25270:
Output file size changes when date format reduced
25271:
How to insert the date
25272:
COLUMNS_UPDATED()
25273:
How to filter out unwanted data
25274:
how to insert a NULL in a table
25275:
sqlxml problem
25276:
Not cool...linking to password-protected Access database
25277:
Insert Data into another database failed-- in Trigger
25278:
Script a SQL Server 2005 Express DB
25279:
Output parameters and stored procedures
25280:
Set parameters in Cursor
25281:
trigger rollback clarification
25282:
Errors restoring Transaction Logs
25283:
DSO Cell Calculation Problem
25284:
How to effectively create dynamic queries?
25285:
SQL Language Tutorial for Newbies
25286:
How Can I Programmatically Remove Identity from a Table?
25287:
Error handling...
25288:
SQL query help: select first record from groups
25289:
EnumAvailableSqlServers does not return version numbers correctly
25290:
checking the error code
25291:
Simple query syntax to retrieve only records with latest date/time
25292:
Trigger Issues
25293:
tracking db usage?
25294:
Counting by Calendar and Fiscal periods in same query
25295:
table versioning
25296:
Converting seconds to HHMMSS
25297:
SQL Query Help - How to get Multiple ID values.
25298:
Find and drop a constraint before dropping the column
25299:
Free Pages is low
25300:
Scheduled jobs not repeating (log shipping restore)
25301:
order of tables in an INNER JOIN
25302:
A Stored Procedure runs slow while it's SQL is fast. RECOMPILE won't help
25303:
Re: how do I shut autocommit off at the database level
25304:
Order By "IN"
25305:
Calling a stored procedure through an UPDATE statement?
25306:
Populating the IN clause with a parameter
25307:
INSERT INTO... SELECT STATMENT w/Extra nonSQl data
25308:
INSERT INTO... SELECT STATMENT w/Extra nonSQl data
25309:
Date Parsing with DateValue Equivalent
25310:
Restricting User From MS SQL Server Registration
25311:
Need some suggestions about using UNIQUEIDENTIFIER
25312:
GROUP BY Question
25313:
Table-UDF in Stored Proc Question
25314:
performance of temp table
25315:
Store File in SQL Server
25316:
Scalar Function Nullability (SQL 2000)
25317:
TOP with ties, but max number of rows as well
25318:
stored procedure with table as a variable
25319:
EXISTS Vs. NOT EXISTS
25320:
Dates wrecking my head!
25321:
SELECT / ORDER BY question
25322:
Can anyone help me understand a question re Data Driven Query Tasks?
25323:
Inn Sub Query
25324:
Convert Date to String
25325:
Attribute Spliting? Design Question
25326:
string comparing function perform at sql server 2000
25327:
string function perform at sql server 2000
25328:
How to compare just the Date portion of DateTime fields
25329:
Join?
25330:
Problem with stored proc syntax
25331:
Trapping errors from stored procedure into a file
25332:
Duration Problem
25333:
SQL Query Inner Join Question for SQL 2005 Express
25334:
Smart or stupid? Tying textbox length to database column length
25335:
Articles on Dynamic SQL and certificates/impersonation
25336:
SQL Error, In clause
25337:
how do I shut autocommit off at the database level
25338:
XPATH QUERY QUESTION
25339:
**find relations of a table**
25340:
join
25341:
Performance question
25342:
Automating Generate Script in Command Line
25343:
Non-deterministic Clustered Index for Indexed View
25344:
Error 823: I/O error (torn page) detected during read at offset...
25345:
Error 823: I/O error (torn page) detected during read at offset...
25346:
Programatically View / Stored Procedure with N fields
25347:
Need help with Stored Procedure
25348:
Store Procedure check
25349:
SQL Server 2005 : Where are the Scripting Options
25350:
Need records forthe last month
25351:
unable to access dbs other than default dbs
25352:
Error 823: I/O error (torn page) detected during read at offset...
25353:
Cross Tab SELECT
25354:
General network error. Check your network documentation ADO.Net error
25355:
How can you mass-validate stored procedures, views, etc?
25356:
Making strings safe for SQL?
25357:
How to check if server address is valid?
25358:
Schema Sample For Financials
25359:
How do you reduce the size of the Log File when using SQL Server 8?
25360:
how to select distinct rows problem?
25361:
Null data source to default value
25362:
How to use LIKE in a store procedure
25363:
Login failed State 16 SQLServer 2005
25364:
SQL2005 and 4GB of RAM : How do I use it?
25365:
GROUPING problem
25366:
DTS Package Migration Wizard error
25367:
Right way to do a insert
25368:
problem with select * from [remote server] in QA
25369:
Trigger Security
25370:
Use UDF which returns a table in a join
25371:
Inserting data into a table which already has identity
25372:
Doing the lookup on the server while inserting
25373:
LoadFromSQLServer method has encountered OLE DB error code 0x80040E09 (EXECUTE permission denied on object 'sp_dts_getpackage',
25374:
Get Today's Records
25375:
How do I link tables to another database?
25376:
I am getting an error in creating a simple store procedure!
25377:
Quick Stupid Question, One to One Relationship Storage
25378:
BULK INSERT permissions for non-admin?
25379:
Top 5 Quesiton
25380:
Stumped on filtering data by date
25381:
Stumped on an Update Query
25382:
How to best handle multiple parameters?
25383:
Join using LIKE ?
25384:
BLOBs and Stored Procedures
25385:
Stored Procedure generating error
25386:
Complex View creation question
25387:
Calling Stored Procedure from asp without waiting
25388:
How-To create a "Dirty" Stored Procedure (Relates to Transaction)
25389:
Use float or decimal to get time?
25390:
Copy users between databases
25391:
Sub Query ?
25392:
Msg 226, Level 16, State 6, Line 4 ALTER DATABASE statement not allowed within multi-statement transaction.
25393:
Automating data exports
25394:
TSQL for date of next weekend
25395:
A stored-procedure becomes slow and needs re-creation
25396:
timeout error in calling from asp
25397:
Any way to query EXECUTE perms on stored procs?
25398:
How to allow normal user (not Administrator) deployment of SSAS Cube?
25399:
sp_sqlagent_notify problem
25400:
Multiple queries SQL
25401:
Interesting Query
25402:
security for row level but not based on Database user's login
25403:
select all the rows where min_date_time <= curr_time <= max_time.(How?)
25404:
Why does (SqlInt32)sqlCommand.ExecuteScalar(); : Throw Specified cast is not valid.
25405:
service broker management views
25406:
Suggestions for JOINs in audit tables.
25407:
OPENXML Insert into table failure not producing @@Error
25408:
pulling unique records from this query
25409:
Data Parse Challenge
25410:
OPENDATASOURCE
25411:
SqlPipe output from CLR sproc
25412:
How to insert empty string
25413:
function versus stored proc
25414:
Problem building query string
25415:
How to use EXEC
25416:
Import DBF File into SQL Server using vb.net
25417:
1434 problem
25418:
Oracle to SQL Server Migration
25419:
EXISTS Vs. NOT EXISTS
25420:
Finding special characters in field?
25421:
DTS ActiveX Script error
25422:
SQL2005 SP1
25423:
wscript.exe vs cscript
25424:
Table Design Question - Infinite Menu Level Items
25425:
Next question regarding to backup location.
25426:
Convert Access Query to Transact SQL 2000 IIF to CASE
25427:
TSQL statement Varchar/char to datetime
25428:
How to generate unique key? (ala Oracle sequence)
25429:
using OPENQUERY in stored procedures with parameters
25430:
UTC -> Local Time conversion - How to? (SQL Server 2000)
25431:
Variable suddenly getting undeclared
25432:
JIT Debugging
25433:
UTC -> Local Time conversion - How to?
25434:
Can I populate an existing table from inline function table data?
25435:
Reg-Gate's SQL Compare
25436:
Is there a better way of doing an INSERT or UPDATE
25437:
ADD IDENTITY PROPERTY WHEN THERE IS ALREADY DATA
25438:
Total by company
25439:
SQL Server Execution Time, elapsed time, Overstated in Query Analyzer
25440:
Can you help me to remember
25441:
Creating a Crosstab in SQL
25442:
schema design question
25443:
Recursion problem...
25444:
Question on MTS and SQL Server
25445:
Have you found any solution for this?
25446:
convert float to string
25447:
Regarding databases
25448:
Two EM at the same time..
25449:
Dts to SSIS...
25450:
Copy Database to another Database
25451:
SELECT with Exclude?
25452:
Profiler Trace Analysis
25453:
Performance between SP3 and SP4
25454:
Service Broker queues
25455:
Having condition
25456:
Service Broker queues
25457:
Table format change
25458:
Bitwise or aggregate function
25459:
Setting up foreign key
25460:
Question about CASE
25461:
Executing a command inside a read loop
25462:
size of a table in bytes
25463:
Search all Varchar fields in Database for text
25464:
Format numbers in a view
25465:
Converting text output of execution plans to graphical
25466:
at a time more than 8 users executing sp_xml_preparedocument what
25467:
Query in SP3a retreives result in different order in SP4
25468:
N Preceding Strings when Scripting Objects
25469:
diff between Cast and Convert
25470:
Locking Problem
25471:
Logging IP of connecting users
25472:
**longest text in SQL**
25473:
Algorithmic question
25474:
Max() on many columns performs slowly
25475:
sysperfinfo table empty
25476:
Processing tables with hierachical contents
25477:
While Inserting into a Table, it takes more than 10 secs...
25478:
shell object does not execute command.
25479:
Insert Primary Keys to all tables in a database
25480:
The usage of substring
25481:
How to extract the string
25482:
Handling error level 16
25483:
function vs stored proc
25484:
checking object usage
25485:
Update numeric value?
25486:
Arithmetic Overflow
25487:
How to access a UDT indexer (aka default property in VB)
25488:
need an alternative for this simple query
25489:
oreilly
25490:
Table Lock on a Simple Update .. Using PrimaryKey as the only value in the WHERE clause // The whole table locks
25491:
Controling xp_sendmail
25492:
INSERT INTO EXECUTE Holds EX_PAGE .. Still an Issue for 2000/2005 ???
25493:
Export Blob (images) to file (jpg)
25494:
possible to concatenate text to Where clause?
25495:
Scan and Write a varchar into numeric column
25496:
Create Procedure Error?
25497:
stored procedure rights
25498:
What's the best way to keep a live db and an archive db?
25499:
i can use SQL2005 Client Tools with SQL2000?
25500:
Reporting + SQL Server 2005 + assembly and "small" problem
25501:
How do I rebuild object dependencies in SQL2000?
25502:
User Defined Function Criteria/Default problem
25503:
Truncating DECIMAL data type
25504:
Is it possible to create CLR function call legacy C++ models?
25505:
How to USE <DatabaseName> in a stored proc
25506:
Temp Table
25507:
Concatenate Date & Time
25508:
how to specify default value of '%' for int param in SP?
25509:
How can I make this update statement faster
25510:
Improve Update Statement
25511:
Multiple row insert only inserting one row?
25512:
sql cookbook.
25513:
UNIQUEIDENTIFIER datatype
25514:
convert float to string
25515:
Using OPENQUERY
25516:
Whyis "Manage Indexes..." grayed out?
25517:
Retrieve GUID from SQL 2005 Stored Procedure
25518:
Calculation between rows in one field
25519:
problem with If Exist select
25520:
Dynamic From Clause
25521:
SSIS Result Set
25522:
Partitioned View performance
25523:
SQL View
25524:
Updating table without using cursor
25525:
Indexed Views are they supported?
25526:
SQL Server has lock on COM DLL
25527:
Recursively creating a String using Cursors
25528:
Is UPDATE worth the effort (in this case)?
25529:
semi-colon as a batch separator
25530:
Re: Daylite saving time problem
25531:
Efficient SQL Backup?
25532:
Stored Proc Parameters
25533:
What am I missing in this INSERT???
25534:
vb6 dll - called from asp classis - [SQL-DMO]Invalid parameter type;...
25535:
::Info Request::
25536:
Generate SQL Script using a DTS
25537:
DBCC fails, why?
25538:
xp_cmdshell
25539:
Importing a text file using Express
25540:
sql cookbook.
25541:
Kill a SQL process
25542:
Does SQLSERVER support fuzzy text searching(like the function of agrep).
25543:
Triggers not Updating
25544:
integer datatype confusion, signed vs unsigned
25545:
local and distributed transaction
25546:
What is the problem of using the IDENTITY column as the only key for table.
25547:
update column dependent on previous values
25548:
Temporal db design ?
25549:
Executing BCP from C# code
25550:
Protect my database (BE)