12251:
Modifying date value (varchar)
12252:
Graphically creating Transact SQL Statements
12253:
Connecting to multiple Database Instances using CLR Integration
12254:
SQL2005: Stored Procedure parameters of Table type?
12255:
difficult select statement
12256:
Aggragation Question Part 2
12257:
Aggragation Question Part 2
12258:
Aggregation Question
12259:
Converting all char, varchar, and text to nchar, nvarchar, and nte
12260:
Why relational division is so uncommon?
12261:
How best store value/pair combinations?
12262:
ISNUMERIC Data Scrubbing Problem
12263:
NULL vs EMPTY
12264:
if condition in sql
12265:
help with Coalesce function
12266:
Nested xml query
12267:
rounding of decimals
12268:
WITH (NOLOCK)
12269:
Append date to a filename in DTS
12270:
Connect to server - list of servers
12271:
TRY..CATCH BLOCK...what am i not getting here.
12272:
Need a simple solution for this if possible
12273:
Optimize SQL 2005 Compact Edition
12274:
"cycles or multiple cascade paths" problem
12275:
Number of times a function is being used?
12276:
make > 1 display 1 ????
12277:
Comparing date with null values
12278:
Recovering deleted data
12279:
T-SQL Debugger Error
12280:
Server DDL Trigger problem
12281:
query with NEWID
12282:
IP Address, Port No in SQLOLEDB ConnectionString
12283:
Halle Berry in anal action!
12284:
Johnny Depp lesbian strip!
12285:
Updating a table In Stored Procedure is not happening
12286:
Is SQLCMD redistributable?
12287:
OPENROWSET
12288:
SPs in multiple similar DBs
12289:
UPDATES with joins
12290:
Trigger: Fill another Database and use their Stored Procedures (not able to catch the error)
12291:
Make Trigger update a specific row and not all of them?
12292:
Creating an Audit Database
12293:
Need help in a query
12294:
how to select every "n"th row from an ordered dataset?
12295:
Where is my F7
12296:
Log Ship
12297:
Getting the maximum value of a datatype
12298:
Backup Question
12299:
Searching for columns in views
12300:
User defined reports based on business objects?
12301:
Caching Image Data Type?
12302:
Attaching database
12303:
Restore with File Group
12304:
substring and replace
12305:
Any drawbacks to creating linked servers?
12306:
SQL Server - Remote Query problem
12307:
Restore database sql2000
12308:
function (like sp_helpText) to view table script?
12309:
EXEC SP inside a SELECT?
12310:
if statement
12311:
Modifying SQL Server 2000 Maintenance Plan through Scripting
12312:
Clr UDT double serialization
12313:
Suggestion: Tables used for reporting
12314:
Q: Data model change -> recompile all SP?
12315:
performance related transaction replication and trigger
12316:
Alter Table from SQL Management Studio
12317:
Create complete datetime
12318:
What's the logical difference between these queries?
12319:
sp_helpdb slow response time
12320:
Integrated Security
12321:
find a duplicated name and sum de result
12322:
SQL Server Data compare across data types
12323:
SQL needed
12324:
Any suggestions on how to do this
12325:
user logon action (SqlS2k)
12326:
inner join difference between on condition and where condition
12327:
How to debug a SP per remote SQL 2005?
12328:
SQL Select statement to retrieve last 12 or so values matching a criteria
12329:
Remote server
12330:
Sql 2005 err 233 ?
12331:
SP - insert statement error
12332:
Design related
12333:
SQL based Statistics
12334:
How to create reusable query in sql 2000?
12335:
Transferring tables via FTP?
12336:
column to row
12337:
Tricky Update
12338:
regarding blocking
12339:
JOIN vs Subquery Performance
12340:
Query Cost is different at different times
12341:
Flattening Tables
12342:
ExecuteScalar SQL Server 2005 - how can I test it? It's crashing in .Net 2005 in some instances
12343:
need help in query
12344:
recommendation for a simple replication scenario?
12345:
Last statement in a function must be a return statement
12346:
How to force a bookmark lookup and concatenation?
12347:
UPDATE statement for variable columns
12348:
UPDATE statement for variable columns
12349:
Add Columns to Table Variable Dynamically?
12350:
Stored Procedure - Clean Up Recommendations
12351:
Index Name vs Index_ID for Defraging
12352:
SQL CRL and Remoting
12353:
Create XML from table records
12354:
Populating a Schedule Table
12355:
column
12356:
Dynamic Update Trigger
12357:
Procedure to Automate Schedule Updating
12358:
graemesmith1@youbanking.com
12359:
check the modified date and time of file, if exists
12360:
CASE Statement: Space Truncation: Only Happening in Windows Vista
12361:
Giving everyone basic access to a single database
12362:
Advice - Production DB upgrade to 2005 or leave in 2000?
12363:
Try Catch link server connection failure
12364:
select top 1000 * from ... - how to get rows chronologically on da
12365:
Relation table
12366:
stored procedure slow
12367:
Strange problem, two servers, two different results??
12368:
Help with SELECT statement please.
12369:
Tracing Locking
12370:
Way to create a simple password on a database or server?
12371:
Table rows to result columns query problem
12372:
SMS 2003 SQL Hardcore Query
12373:
POST Method & XML
12374:
good database design
12375:
Set Id_Ins Across Linked Server
12376:
Problem with use of {d } syntax and SET LANGUAGE <> from english
12377:
Transactional Publication with Updatable Subscriptions
12378:
set nocount on to suppress rows affected but keep prints
12379:
Scheduling the Creation of a Text File
12380:
SSIS data export/import
12381:
Query to change table schema into new table
12382:
split one column into multiple columns based on a delimiter
12383:
Transaction is too large
12384:
QA not working
12385:
Default schema and Resolving table names in Stored Procs
12386:
Problems creating a stored procedure
12387:
Reporting Manager access in 2005
12388:
How change a sql view name ?
12389:
Behaviour of Blk insert with NOT NULL columns
12390:
programmatically creating a maintenance plan
12391:
How to clean up DTS 2000 package logs ?
12392:
database maintenance
12393:
Help with Logic
12394:
I need help with formatting date and time
12395:
How make a where clause conditional on something else?
12396:
Construct ??
12397:
SQL Server 2005: computed columns
12398:
SQL Server 2000 DTS can I use global variables to rfer to tables
12399:
Copy database
12400:
How model for products given different attributes for different types?
12401:
Error 14274: Cannot add, update, or delete a job (or it
12402:
select based on criteria
12403:
How return records with search word param like 'value1, value2'?
12404:
Login performance
12405:
Skip to end of SQL Script
12406:
Obtain msinfo32 info + am I SAN attached ?
12407:
Cursor trouble 2005
12408:
How to prepare a valid value for unique identifier column?
12409:
BCP question
12410:
A problem with indexing
12411:
NOT EXISTS
12412:
(SQL Server 2005) newbie: join in DELETE
12413:
Why doesn't this SQL query append a field to the table?
12414:
2005: formating text in RAISERROR
12415:
Trigger problem:
12416:
One Row into Many?
12417:
Parameter Sniffing - Local Variables - OPTION (RECOMPILE)
12418:
Export to Access - Varchar(3) becomes Longtext
12419:
Apache instances and CAL licensing
12420:
TimeOut Expired - Tracing historically.
12421:
set up scheduler on step basis
12422:
Help with XML EXPLICIT to get output in desired schema
12423:
ALTER TABLE doc_exa ADD @variable?
12424:
possible to limit database listing to those of which you are a user?
12425:
Connecting to Informix
12426:
Subquery Logic Puzzler
12427:
DELETE 1 FROM MyTable WHERE ID=123?
12428:
Return metadata information about a query
12429:
Return metadata information about a query
12430:
Deal with NULLs
12431:
Find whole numbers
12432:
permissions on SP and view
12433:
openxml - attribute and value
12434:
CR report - connection can't dispose
12435:
split
12436:
Interesting SQL problem : How to track movement history
12437:
openxml
12438:
[newbie] Is it possible to execute SP from a SP??
12439:
SQLMail varbinary as mail attachment
12440:
Join Hint in DTS
12441:
Help with padding!
12442:
Check if record is full-text indexed
12443:
Are there any PhpMyAdmin clone for ASP.net and SQL Server?
12444:
Opposite of Union Select query
12445:
dynamically change column name when displaying
12446:
Tools to help analyze SQL Profiler Traces in SQL Server 2005
12447:
Query Syntax Error
12448:
Group By Column with Natural Number Values ( 1 , 2 , 3, N) ...
12449:
Seconds to mm:ss
12450:
Outline number sorting
12451:
Update statement performance issue
12452:
query by sub-categories with category totals
12453:
case stmt - need to select subset
12454:
problem understanding coalesce function
12455:
I Refuse.......
12456:
How to change collate system?
12457:
Calculate rate by line item
12458:
creating a new user for database
12459:
Cannot BCP in from a view
12460:
select and display 1:many
12461:
Hi Need Help with Access and XML data islands as prep to SQLServer
12462:
Can I JOIN Database Tables on Different SQL Servers
12463:
Absolute time diff
12464:
Script for moving and comparing tables from one database to another
12465:
Creating report and sending it in an email.
12466:
select then update in stored procedure
12467:
diff at a glance
12468:
Question about standard restore procedures
12469:
removing full-text index
12470:
How to get the first and last day of the previous month
12471:
Backup/Restore of non-standard databases for beginners
12472:
Challange With Search Stored Procedure and Like Operator
12473:
MSDTC on server '' is unavailable - INSERT to #tmp EXEC sproc
12474:
xp_cmdshell
12475:
SUBSTRING FUNCTION
12476:
RETURN vs OUTPUT
12477:
How to implement multiple assignment?
12478:
DateTime
12479:
Determine if SQL Server in recovery process from code
12480:
Assign a select ...case.. to a variable
12481:
Trigger on master - detail tables
12482:
Four tables (dbf files) problem with JOIN
12483:
Evalute formula string
12484:
DISTINCT vs GROUP BY with multiple columns
12485:
Really well locked down sqlserver
12486:
getting row count of three different queries..
12487:
Flattening table
12488:
copy a view with new name
12489:
SELECT Multiplicate rows : SELECT X times same record where X is a value in some column
12490:
is temp table present in db
12491:
breaking down a stored procedure
12492:
Basic question
12493:
Same Query, Same Server, Same User, Different Plan
12494:
DISTINCT Clause Problems - Urgent.. Helps needed
12495:
Programming Specification
12496:
BeginExecuteNonQuery IAsyncResult is signalling before cmd complet
12497:
DELETE and UPDATE query on linked server
12498:
Left outer join v. Union
12499:
Blocking/Blocked SPIDs
12500:
Union Grouping across multiple tables
12501:
Retrieve rows from un-Normalized table - ?
12502:
Security issue with DecryptByCert function in sql 05
12503:
Retrieve data SQL 2005
12504:
Transaction log Job
12505:
Firing Triggers in a dtsx package
12506:
Deleting / Merging Partitions SQL 2005
12507:
CLR stored procedures and garbage collection
12508:
History Table Question
12509:
FTP quetion
12510:
Backup Query
12511:
locking rows exclusively
12512:
How to: Converting a uniqueidentifier to an integer...
12513:
Convert varbinary into varchar
12514:
Simple Aggregate question
12515:
to find if servername exist or not
12516:
Formating Datediff results
12517:
Need help with the query
12518:
Beginner's question about jobs and error trapping
12519:
Fulltext search question
12520:
sp_attach_db
12521:
Is there a better way to write this SELECT statement.?
12522:
Using GROUP BY with correlated subquery
12523:
SQL insert issue
12524:
MS Access Concurrency Error
12525:
unresolved external symbol .srv_senddone
12526:
Database Mirroring Question
12527:
Capture statistics about Insert and Updates in Stored Procedure
12528:
Can this be done with an SQL statement?
12529:
ASP ans sql server 2005
12530:
Can this be done with an SQL statement?
12531:
Delete from multiple tables...
12532:
SP Recompile and Index Weird Problem
12533:
SQL SERVER 2000 DBA
12534:
Combinations
12535:
row into column
12536:
Recursion in sql server 2005
12537:
What went wrong with my scripts?
12538:
What is the N for?
12539:
query of a big tabler of 70,000,000 rows
12540:
trigger question
12541:
SQL Delema
12542:
Querying ##tables
12543:
Missing comma in query select
12544:
Best Practices for Count(*)
12545:
List of common SID for SQL?
12546:
T-SQL assigning variables
12547:
Would Like Fresh Perspective On Stored Procedure Design
12548:
Detect datetime of last change to a database
12549:
2005: How to SELECT a Bitmask?
12550:
SQL Server 2005 - Default Values
12551:
Change Server Name
12552:
select only rows with the highest value?
12553:
Is there an equivalent to a VB CHOOSE statement in SQL?
12554:
Converting varchar to datatime
12555:
Get the latest record in a group....
12556:
Search for underscore literal within PATINDEX command
12557:
last execution time of a stored procedure
12558:
Portable SQL to fetch only one, latest record from join result?
12559:
What does ON 'PRIMARY' mean?
12560:
View from a stored procedure
12561:
nvarchar or varchar in SQL?
12562:
Pivoting a v. large table without aggregation
12563:
Cursors VS Temp tables
12564:
Self Join
12565:
Coun # of non-null values in a row.
12566:
Returning a result set from one stored procedure to another
12567:
Switching INSERT between two tables
12568:
Create new Table from two non related tables
12569:
Newbie: Why does my @@CURSOR_ROWS = -1?
12570:
OPENROWSET error
12571:
No gain from distributed partitioned view
12572:
Auto update statistics
12573:
Return identity in sp
12574:
Copying Records
12575:
desperate help needed. sql2005 and WMI/vbscript
12576:
Trigger after rollback
12577:
poor performance
12578:
INSERT EXEC statement cannot be nested
12579:
Give output file a timestamp in file name
12580:
Malformed CSV File & Bulk Insert
12581:
Scripting pb
12582:
AdoMd.Net - Cannot connect on Vista.
12583:
job in top company
12584:
job in top company
12585:
Cluster Index
12586:
For performance: How to buld the where condition better?
12587:
Query Analyzer - F5 Executing all the script. which hotkey will execute specific line wihout mark it?
12588:
How to run script on server B from query analyzer connected to server B
12589:
SQL Server 2005 - Error deploying an Assembly
12590:
Insertion of Text Column
12591:
Helpful, very helpful
12592:
select ntext with length greater than 8000
12593:
Help Needed: inet_ntoa equivalent in MSSQL?
12594:
Database Mirroring Across Internet
12595:
changing a Primary key value
12596:
Error
12597:
Halle Berry in anal action!
12598:
Multiple result sets?
12599:
DBCC IND
12600:
Copy files Issue