19251:
How to "UNION" horizontally?
19252:
How to "UNION" horizontally?
19253:
Lock Monitoring
19254:
sp_OACreate Failure
19255:
Return single value from a group by total
19256:
combine two columns in one new table
19257:
help for update query
19258:
problem with an update query
19259:
looping recordset
19260:
Query / Stored Proc Question
19261:
Enumerate built-in SQL Server 2005 functions
19262:
Automatic alias names for the tables in a design mode view MS SQL 2000
19263:
Drop and Add Indexes
19264:
Output parameter vs return value in simple integer case
19265:
using HttpWebRequest for viewing Reporting Services reports
19266:
automaticaly sending the results of a query to Excel
19267:
Substring T-SQL
19268:
Finding the next AutoID without actually inserting a new record !
19269:
DB Design Question.
19270:
Understanding deadlock trace -T1204
19271:
Merge Replication Identity Column Constraint
19272:
index and performance
19273:
concatenate and format the text data in insert/update trigger
19274:
How to error trap SP within trigger ?
19275:
Reg DTS Package..
19276:
Select rows based on occurance of other records
19277:
How to make a random search in SQL 2005
19278:
SqlDependency message timeouts
19279:
Clustering Q's
19280:
Excluding Weekends from SQL Query
19281:
Excluding Weekends from SQL Query
19282:
Rounding with DECIMAL data type
19283:
How to select an image in 2005?
19284:
problem with row(s) affected
19285:
Date in stored procedure for VB 6 code
19286:
confused about OUTER JOIN
19287:
VBS to SQL Connection (Alternate Connection Method)
19288:
Delimited Seperators
19289:
Very poor query performance
19290:
Create object failure
19291:
error 904 Database %ld cannot be autostarted during server shutdown or startup.
19292:
Question as to why dates have two quotes as ''2006-09-26 17:05:30:730'' in Profiler
19293:
Looking for tutor in SQL for MS Sql Server
19294:
Adding Field With Hardcoded Value In SELECT...INTO Query
19295:
Need help with setting variables; DDL included
19296:
How to avoid use cursor in this situation
19297:
Transaction and result code
19298:
select count from Except query
19299:
Questions on PASS 2006 Community Summit in Seattle
19300:
Service Brokers
19301:
access to database using stored procedures only for security making sense?
19302:
Dead Lock problem with same sequence of commands
19303:
Is this a Valid Date Time
19304:
Cannot perform an aggregate function on an expression containing..
19305:
SS2005: database growing very quickly
19306:
Is there a better way?
19307:
Non English Characters
19308:
Best ERD design apps ?
19309:
@@Error problem, execution terminated
19310:
surrogate key in master detail tables
19311:
SP performance problem
19312:
Group by clause on date value
19313:
Simple query, same database, same plan - difference in io - 2473 t
19314:
Date Problem in VB
19315:
Replace
19316:
Accessing parent record from child table's DELETE trigger
19317:
Questions about MSDE and SQL 2005 Server Express
19318:
Joining 2 tables, pulling MAX field value from second
19319:
Using the SMALLMONEY datatype
19320:
Advice on how to tackle this
19321:
Multiple Aggregate Columns In One Query
19322:
Delete Primary Key using SMO
19323:
SQL 2005 - SQL Agent Job/DTS Error - Invalid class string
19324:
convert statement
19325:
one-to-one relationship
19326:
Should I use TRAN in stored procedure?
19327:
The multi-part identifier could not be bound.
19328:
How to use variable in USE method?
19329:
How to avoid Deadlocks
19330:
Performance issues because of recursive call.
19331:
SQL Query
19332:
how to alias (Select * from tbl1) to represent a table in bigger
19333:
sp_who
19334:
Different results based on sql version
19335:
odd or even number!!??
19336:
Syntax error converting the varchar value
19337:
breaking changes from sql2000 sp4 to sql2005 sp1
19338:
Logical read confusion
19339:
Determining if database is Trustworthy
19340:
Query Formulation against a "Transaction" Table
19341:
Performance for Views, indexes and Group By
19342:
Invalid Object Name
19343:
PRINT 'Stupid Programmer Error'
19344:
Best method to copy database items that are recursive?
19345:
SQL Query Optimized Statements?
19346:
Best Practices
19347:
OSQL Return value
19348:
80040E14 - Incorrect syntax near 'BATCHSIZE'
19349:
Struggling with a many to many relationship
19350:
Create table permissions within a SP SQL2005
19351:
how to give password to database of sql server
19352:
Drop unique
19353:
DTS error on 'KEY' field when trying to import data from one SQL server to another?
19354:
Securing Data Through Views
19355:
Bit Question
19356:
Instr ??
19357:
Null plus string thing
19358:
GROUP...BY clause
19359:
Sql Server 2000 Meta Data Access
19360:
Whats the right approach for getting a job
19361:
need query
19362:
creating triggers (when columns updated or deleting too many rows)
19363:
Security - SOX Audit
19364:
Shrinking Logs
19365:
Most Recent Numbers
19366:
Outlook Express Spell Checker
19367:
SQL INSERT problem with AS returns unknown field name
19368:
CASE Statement (SQL 2005)
19369:
what permissions needed for managing jobs and intergration sevices packages?
19370:
Edit - Validation function
19371:
Returning Rows as Columns from a Query
19372:
HelP: SQL-DMO and SQL Server 2005 SP1
19373:
SQL Query Question
19374:
SS2005: Truncating the log file
19375:
how to add auto row count column to a Select statement on the fly?
19376:
SELECT Triggers
19377:
Convert to DateTime format
19378:
Help with get record with Max date or null
19379:
problem connecting to SQL Server 2000
19380:
Create a temporary table within a view
19381:
SQL Server 2005 bug re: Temporary tables in insert trigger?
19382:
Help with a query that turns columns to rows
19383:
Alter Table - Adding column to large table
19384:
Create Table + OSQL Return Value
19385:
SQL Server Locking in Busy Periods
19386:
Custom Active X script for Transform Data Task
19387:
help writing query
19388:
UpdLock false Deadlock - please help
19389:
End of Month function
19390:
pass database name as parameter in stored procedure
19391:
Turning query results into a numeric value?
19392:
Generate SQL Script
19393:
Transaction deadlocked
19394:
Performance Tips Needed Please
19395:
Question regarding sp_executeSQL.
19396:
INSERT INTO from a text file
19397:
Replication and IO question
19398:
Create Table - return value
19399:
%Rowtype in SQL server
19400:
retriev employee information with the help of password encryption
19401:
retrieving employee name against the encrypted password
19402:
retrieving information against the encrypted password
19403:
selecting and locking a record from distributed DB
19404:
cumulative problem
19405:
Simple syntax question
19406:
SqlContext does not contain a definition for GetCommand()
19407:
Calculating Percent
19408:
find connection killer
19409:
join order question
19410:
Sql Server 2000 - ADO adLockOptimistic adLockReadOnly
19411:
IF EXISTS?
19412:
Sql Server Professional Magazine
19413:
When to use scripting tools and when to manually code the script
19414:
prevent concurrent reads of a table...
19415:
how to get this resultset...
19416:
sql editor for 2005
19417:
Looking for an optimum way to get 2 result sets
19418:
What Service account to use in this situation?
19419:
Setting Windows Service "Local System Account" on Setup
19420:
help me with this Stored Proc
19421:
wat are temporary tables
19422:
how can the output from a stored proc be used in a calling stored
19423:
Can't Drop a Primary Index using SMO
19424:
Cross-database proc
19425:
2005: procedure for concurrent use
19426:
Need help with Indexing this join query
19427:
what to do with older data
19428:
Time Date
19429:
Help in date conversion please!
19430:
about select statement
19431:
Delete SQL Server 2005 programmatically (SQL-DMO)
19432:
how to exclude rows that are duplicate of primary key?
19433:
How to create covering index for query with multiple joined tables?
19434:
Default IN
19435:
Sending out E-Mail, one message every 3 seconds
19436:
Generically refering to a SP name
19437:
Get vbscript to keep the current_timestamp from SQL
19438:
sp_execsql vs EXECUTE()
19439:
Convert a number to use comma thousand seperator
19440:
Escaping from a trigger transaction
19441:
Can't Drop Inidex if a Primary Key
19442:
Problem passing SqlDataReader column value to web service
19443:
Sorted Data w/Identity
19444:
restoring with StopBeforeMark LSN
19445:
exec #jtds000030 'Sep 19 2006 1:27:55:000PM', 4219355
19446:
Input File with Multiple Header Records
19447:
Abort query question
19448:
How to sort this query
19449:
Syntax error converting the varchar value 'Audits' to a column of data type int.
19450:
User Defined Aggregate Function For Finding Median
19451:
Simple Query quetion
19452:
Column List
19453:
Performance Cost - Adding columns to SQL 2005 Table
19454:
DATE CONVERSION
19455:
List the disk space usage of all tables in a db?
19456:
Microsoft.Jet.OLEDB.4.0 - Error
19457:
A small puzzle
19458:
SQL Triggers and Updates
19459:
change SMO backup location
19460:
how to synchronize and compare two database in sql 2000?
19461:
How i can compare 2 database having same database structure?
19462:
Deadlocks when executing SELECT quarries only?
19463:
problem using oledb + informix
19464:
grant restore permission to db_owner
19465:
new database
19466:
Probs deploying CLR stored procedure
19467:
Sql Store procedure question
19468:
Performance different between follow 2 codes?
19469:
retrieving information against the encrypted password
19470:
Is is normal behaviour to see a table scan for this query?
19471:
Is is normal behaviour to see a table scan?
19472:
Nested Transactions in c#
19473:
Rows To column
19474:
Complex group issue
19475:
Left outer join/hash issue
19476:
Opportunity to provide feedback on performance improvements in SQL Server...
19477:
Like statements
19478:
select the smallest column
19479:
Get data out of excel file stored as an image data type
19480:
Fetching results of a stored procedure
19481:
Help with a date issue
19482:
Need SubQuery Syntax
19483:
Need help working with dates in SQL stored proc
19484:
PL/SQL to T-SQL
19485:
The speed impact of a 10-way JOIN?
19486:
get fields related to the last record added for each item
19487:
Agent Autostart in SMO
19488:
Questions about generated stored procedures by VS 2005 (TableAdapter).
19489:
BIDS - Cube calculation designer: Unexpected error occurred: 'Error in the application'
19490:
Table variable and dynamic sql statement?
19491:
SQL2005: Can a computed column which is derived from an XML column be indexed?
19492:
Can't Create PRIMARY Index using SMO
19493:
=?iso-8859-1?q?Allitcertkiller=AD.com_study_guides_now_more_cheaper_than_Realexamquestio=ADns.com?=
19494:
Query a foriegn key value in a database
19495:
How to make an Ordinal RS return descrete a range SQL 2K?
19496:
Connection pooling: Saving username against a @@spid
19497:
Looking for Opinions on Repeated Dataload Requirement
19498:
Help with query using group by
19499:
Query help for a beginner
19500:
Cannot drop table check constraint
19501:
Security Problem
19502:
date convert question
19503:
AFTER UPDATE trigger: rollback the update on error within trigger?
19504:
Could this be called a bug ?
19505:
integer division
19506:
this is prob. moronic, but....
19507:
When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030.
19508:
Processing Multiple Results Sets From A Stored Procedure
19509:
Concat
19510:
Using one stored procedure to update table created in another?
19511:
Doing an update and comparing date
19512:
msdn transact ref: boolean expressions versus predicates
19513:
=?iso-8859-1?q?select_=FCber_Stichworte_in_verbundenen_Tabelle?=
19514:
Is this the way to mislead the query optimizer?
19515:
How to get the password change date in SQL Server
19516:
Dyamic view/function based on table data (?)
19517:
Determin if values in one parameter are contained in the values of another parameter
19518:
Urgent Assistance
19519:
Create Procedure with Encryption
19520:
Need Help! Connection Count to Linked DB2 Server Reaches limit (SQL1040N) when execute dynamic generated OPENQUERY T-SQL
19521:
need help improving insert statement
19522:
Insert record to table with single identity column
19523:
Can I use conditional field in insert
19524:
Parameter Sniffing (Resolution???)
19525:
Constraining Data (sometimes)
19526:
Stored Procedures
19527:
Query or DTS Package?
19528:
calling sp from vb.net
19529:
Insert, Union, and Order By
19530:
T-SQL, HELP with Subqueries
19531:
Difficulty with inner query and dates
19532:
SQL Query help
19533:
Need to optimize update on linked server
19534:
Concatenate Null Fields SQL Server 2000
19535:
Visual Studio 2005
19536:
Problem With Stored Procedure vs Direct SQL Call
19537:
trigger
19538:
How to get YYYYMMDDHHMMSS
19539:
How to use EXISTS key word in my query?
19540:
Remove (Delete) SQL Server 2005 Logins - DMO
19541:
Query - Use subquery in place of an expression
19542:
how to do bcp in a table having identity column.
19543:
Issues using stored procedure update
19544:
Revenue split evenly into different quarters
19545:
Strip out Alpha Character
19546:
Possible to create a sql server 2005 table from an xsd file?
19547:
Need help with a query.
19548:
Date Difference
19549:
Connection string at asp.net app for data mirroring
19550:
Triggers and Stored Procedures
19551:
DB2 Import to SQL 2000
19552:
How do I Replace Strings in SQL
19553:
sql query
19554:
SSIS: FireAgain
19555:
PIvot statement, multiple agregation
19556:
truncate issue
19557:
Need help using converting function in a SQL query
19558:
Using If Statement in a Function that Returns a Table
19559:
time since last application
19560:
Passing and using an array of values to be used in an in statement
19561:
export SPs using 2005
19562:
WHAT IS THE EQUIVALENT OF EVALUATE() FUNCTION IN SQL
19563:
SQL Server Integration Services Expression
19564:
ORACLE database update trigger
19565:
select query
19566:
Stored Procedure/View to generate a new list of records.
19567:
generate a list of dates, better way of doing it
19568:
Data transfer between databases with different structures
19569:
PATINDEX from right to left?
19570:
concatenate fields from a select into 1 field
19571:
SQL function return table
19572:
Another SQL Query Question : TOP 1
19573:
I am in NewJersy and i am willing tolearn T-Sql Programming
19574:
I am in NewJersy and i am willing tolearn T-Sql Programming
19575:
How do I get the pending table like oracle's dba_2pc_pending?
19576:
Tough one
19577:
How to dynamically include DBCC INPUTBUFFER ?
19578:
null input paramater
19579:
need help with insert into table from two other tables
19580:
Advance Query Problem
19581:
Calculate Consecutive Days worked HELP!!!!
19582:
Using openrowset/sqloledb but excluding from a transaction?
19583:
Question
19584:
Using a stored procedure with xp_sendmail
19585:
Using "&" in a URL parameter field
19586:
Sql query for dynamic columns
19587:
SQL 2005 - Incorrect syntax near ','.
19588:
append results of a simple select to table without a cursor?
19589:
How to tell sql server to add generic system accoun at command pro
19590:
Question
19591:
annoying behavior of Log File Viewer in sql2k5
19592:
Studio runs slow.
19593:
generate script
19594:
Query question
19595:
SELECT WHERE IN Help
19596:
Query Help
19597:
sqlagent.out
19598:
way to disable trigger for a particular update
19599:
New Performance Issue
19600:
Need help with the sub query