24501:
Create Procedure in an IF block?
24502:
Convert Image Datatype To Int
24503:
query to get sales person and count of sales who did a sale each month since 2003
24504:
Hacking around with a prototype
24505:
How to save query execution plan?
24506:
Running SQL Server job from Access
24507:
connecting to database from script component
24508:
different behavior
24509:
Need help with testing data conversion and related update
24510:
Is there an easy way to synchronize two tables in different databaes using a SQL query?
24511:
temp table name and multiple session
24512:
To update the table with 2 primary keys
24513:
Transaction locks forever
24514:
SQL server error: double quotes inside a string, inside a stored procedure
24515:
xp_sendmail, how to populate the @recipients list from a table
24516:
DATEDIFF
24517:
Inserting records
24518:
SQL INSERT Stored procedure and return values
24519:
Opposite of union - Stupid question for a common problem
24520:
enumerating registered sqlservers does not fill datatable complete
24521:
How to name Tables & Fields (pk - fk) ?
24522:
Execute as Caller
24523:
help with query
24524:
Audit Design Question
24525:
'[object name]' - what is the purpose of '[]' in t-sql?
24526:
Determening the setting
24527:
calculating query cost
24528:
Trigger, multiple tables and transactions best practices?
24529:
External stored procedure, performance?
24530:
Merging 2 tables
24531:
help with simple query
24532:
Dynamic Data Driven Query Task
24533:
How to Use SMO to Create Primary Key
24534:
SP4 self blocking
24535:
Error:-Server: Msg 403, Level 16, State 1.
24536:
Urgent: How to call SP for all records in a result set?
24537:
db maintenance issues with connection pooling
24538:
Creating one row view help
24539:
Common Database Management Info
24540:
Current User
24541:
SQL Server Express Edition
24542:
New Free Ads Post Service - sell your products for FREE
24543:
reclaim unused space in SQL Server tables
24544:
sp_password - keeping the old password
24545:
SQL statement for Getting Children from Parent
24546:
Changing Letter Case in SProc
24547:
Stored procedure debugger SQL2005
24548:
how create table with variable name
24549:
Select certain data from field
24550:
XML Output
24551:
canceling parallelism
24552:
returning only first record of partition that exceeds threshold
24553:
VBA Access Insert New
24554:
Transaction
24555:
How get the last day of each month?
24556:
Can we use reporting services 2005 with sql server 2000
24557:
Converting Access Code - FORMAT
24558:
how to replace a character with line break in sql column's data?
24559:
SSIS burning issue
24560:
Use Stored Procedure on Multiple Schemas
24561:
Date less then 13 months
24562:
Easy SQL query question
24563:
log stored procedure execution
24564:
Outputting to a flat file
24565:
many as one to many
24566:
Input Parameter as Collection?
24567:
Reading Backup Schedule info for SQL 2K
24568:
t-sql to merge tables and summary report
24569:
How and where do you debug stored procedures in SQL Server 2005?
24570:
Transaction Logs
24571:
Get the column name of dynamical SQL?
24572:
ISNULL(check-expression, replace-expression)
24573:
Service Broker Issue: User Connections Out Of Control
24574:
SQL Server 2005 - Deleting records
24575:
using Case Statement inside Group By Clause?
24576:
Debugging Custom Assemblies in SQL Server 2005
24577:
Sending Website Notifications
24578:
Creating New Table & Linking to Datas
24579:
How to use the return of select .... for xml auto...?
24580:
Enable SQL Server Remote Connections via Script
24581:
TOP 10 Distinct statement
24582:
Auto Increment Starting 1 after deleting records
24583:
problem with like [^]
24584:
SmallDateTime- the mistery of the null data..
24585:
Crosstab Help in Sql Server
24586:
random runtime error 3021
24587:
example of srv_message_handler
24588:
Lookup task problem in SSIS
24589:
Auto field calculation
24590:
Exists T-SQL
24591:
List of SQL Server Proprietary Data Types?
24592:
Problem calling an Assembly in SQL Server 2005
24593:
Trying to do a single to many join but only want the first record of the join.
24594:
Need Help on Query, Join or Union?
24595:
Insert into 10000+ tables
24596:
INSERT Statement Question
24597:
Questions for Taking Over SQL Support
24598:
Triggers on one or more rows
24599:
timeout during backup
24600:
Conditional Column Filter
24601:
Crystal Reports Server XI: Logon to CMS
24602:
Windows Integrated Authentication via IIS
24603:
SQL Server 2005 - CREATE ASSEMBLY
24604:
Joining date and time
24605:
Concat Null Yields Null Woes..
24606:
What is the best connection ODBC/ADO or something else
24607:
Full-text on text-data and
24608:
Delay command execution
24609:
Connection timeout/ODBC failed
24610:
Replace Function? SQL2K/EM
24611:
dataset and xml problem
24612:
Sql Server 2005 - Intellisense
24613:
Dynamic WHERE clause
24614:
Sql Log file
24615:
Extended Property - Sql Server 2005
24616:
INvariant part inside SELECT
24617:
Data Modeling Question: One Entity or Two
24618:
Need help with report
24619:
Conventions, Style, and Best Practices
24620:
Server login using code
24621:
Major Version number
24622:
Group By on a redundant column
24623:
Transaction Log
24624:
MD5 function ?
24625:
confused about date values
24626:
UDF using FROM @gettab?
24627:
Help! Computed Column
24628:
SQL Statement question, eliminating a field in Group by Clause
24629:
Help required to update SQL
24630:
Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure
24631:
passing in a value to use as a column 'as name' in a stored proc
24632:
Create Excel doc from SQL sp
24633:
SQLDataset.WriteXml and filtering bad characters
24634:
locking behaviour 2005?
24635:
Separate business database from authentication DB ?
24636:
Alter Table Alter Column sometimes fails when changing to Not Null
24637:
Propagating results of Alter Table to its views
24638:
reproducing deadlock
24639:
Connect to SQL Server 2005 Using Visual Studio C++ 2005 ?
24640:
Timestamp Question
24641:
save results to multiple files
24642:
Is it possible to make a HTTP Post in TSQL? (SQL Server 2000)
24643:
Procedure/cursor question about returning results (started by Tony Murunion)
24644:
WHERE clause optimization
24645:
Procedure/Cursor Question about returning results (Started by Tony Murnion)
24646:
Using break with nested cursors
24647:
replacing Apostrophe
24648:
Add auto number field to view
24649:
backing up 2005 to something I can restore to 2000
24650:
distributed transaction with loopback linked server
24651:
Startup stored procedures
24652:
Datetime problem
24653:
Primary Information
24654:
how to convert varchar into datetime field
24655:
Return ADO recordset to worksheet
24656:
Cursor doesn't loop properly???
24657:
create function
24658:
How to use getdate() and user_name() functions with Windows NT login
24659:
SQL-92 varchar maxlength
24660:
No transaction is active
24661:
use go on varriable
24662:
Compatibility level, SQL 2005
24663:
EXEC(@SQL) And Unicode Result Bug
24664:
Update statment problem
24665:
stop using dynamic sql
24666:
UDT, what's the point?
24667:
SQL use of processes.
24668:
how to write extended stored procedure to generate sequences.
24669:
Number of days in previous quarter?
24670:
dll & Web Service in VB.Net 2005 Stored Procedure
24671:
What is wrong with this code?
24672:
permission to execution stored procedure
24673:
Sorting a parent-child list
24674:
Running MS SQL query from Excel VBA
24675:
In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO.net?
24676:
In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT field is many megabytes but i only wat 10k at a time? how to do this in ADO.net?
24677:
Can deadlocks caused by creating functions in SQL Server?
24678:
UDF's in SQL2005
24679:
DTS task logic
24680:
Need help understanding fn_get_sql and the stmt_start and stmt_end columns
24681:
UNION problem
24682:
SQLXML
24683:
Optimize the Query
24684:
truth or fiction about writing correct queries
24685:
Adding Unique data
24686:
process is blocking itself
24687:
SELECT Query With Sum
24688:
Procedure/cursor question about returning results
24689:
alert e-mail
24690:
Global Property in SQL?
24691:
remote stored procedure call
24692:
Problem with a where clause
24693:
How to construct a like compariso when there are special characts
24694:
SQL SELECT INTO ... IN external_database - syntax error
24695:
Default constraints in SQL Server 2000
24696:
How to Move Sql2000 DTS into Sql2005 legacy folder
24697:
SQL Server Linked Server problem (with AS400/DB2)
24698:
How to work with SQL Server reporting services.
24699:
How to generate reports !!! some basic question
24700:
How to generate a table script in T-SQL?
24701:
SQL Query to get the result
24702:
log shipping
24703:
Collections in UDT?
24704:
Using FileCopy to Copy Files via T-SQL
24705:
Simple distributed transaction example does not work
24706:
Cursors and Temp Table : in SQL Server
24707:
Calculated columns...
24708:
Latin to Cyrillic
24709:
Check box in a Combo Box
24710:
ADO Connection terminates automatically after one hour
24711:
Execute an sp by via a trigger?
24712:
HOW "TOP" is interpreted??
24713:
Bring back Query Analyser
24714:
MDX: Rolling YTD
24715:
Comparing databases
24716:
how to display 10 rows at a time when 1000's returned form sql query
24717:
SQL 2005 - Select XML Data Field
24718:
Select all Rows on distinct only on one column
24719:
sql x sysbase
24720:
Use of SELECT...,0 FROM
24721:
SQL Query
24722:
which query is more efficent? (oppinion time!)
24723:
MERGE
24724:
Help! Users can't connect to database
24725:
Need help with this
24726:
automatic backup / restore to another db
24727:
Stored Procedure Help
24728:
Dynamically use variables in SQL in EXECUTE
24729:
select with no Result set
24730:
No Result set
24731:
SQL2005: "Registered Owner" and "Registered Organization" available?
24732:
Help with stored procedure using "IN"
24733:
Sql Server - TRN Log shrink or truncate.
24734:
Finding last instance of string
24735:
Convert Money to Char
24736:
Microsoft's AdventureWorks CTE example - different ordering desired
24737:
DMO defaults scripting question
24738:
Implementing Version Control on Database Scripts
24739:
Concatenation
24740:
bcp queryout a stored procedure return multiple result set
24741:
Can I just import first several rows of Text file to Table using DTS
24742:
Retieving Column Names of Table Valued UDF
24743:
Cascading updates question
24744:
Sql Server 2005 - Schema Object
24745:
xp_logevent - how to put only one message?
24746:
sp_OAMethod & access violation errors
24747:
Trigger causing Sch-M Lock!? Server trace shows Create Trigger
24748:
same code in stored procedure 3 times slower than as transact sql
24749:
How to enable ansi_nulls on existing table?
24750:
force sql to ignore dependancies
24751:
Insert a IF stmt in a stored proc
24752:
Problem with double commas...
24753:
Insert Data between tables
24754:
the code behind sum()
24755:
Help on grouping time
24756:
if statement in where?
24757:
sqltrigger & CLR debugging
24758:
Automatically logging T-SQL errors.
24759:
IDENTITY column?
24760:
pivot table, calculated rows?
24761:
IN() and duplicates
24762:
good practice?
24763:
Transform outer join statement
24764:
Unique Constraint Error
24765:
Exporting data as insert statements
24766:
SQL Server 2000 PIVOT?
24767:
SQL 2005/2000 on same machine???
24768:
Storing Enhanced Metadata
24769:
link/banner exchange select query
24770:
Could not find server 'x' in sysservers
24771:
SQL 2005 newbie - execute CLR stored procedure at time specified by table data
24772:
Question about Group By
24773:
Select @Variable problem/observation
24774:
T-SQL procedure need help
24775:
Join Filter to find mismathced replica records
24776:
SqlServer 2000 SP4
24777:
Problem with DateTime
24778:
Question regarding returning data from stored procedure.
24779:
Discover exactly what is causing a block
24780:
Help Converting Character string to smalldatetime data type
24781:
dynamic audit trigger
24782:
Get top 20 from aggregated records???
24783:
How can this be done...
24784:
DTS Package
24785:
Sql Server 2005 and Sql Server 2000
24786:
SQL2006 CLR calling webservice
24787:
SQL Express Table and Column limit.
24788:
Help! Can't pass names with apostrophe from ASP to SQL7 proc
24789:
Help! Can't pass names with apostrophe from ASP to SQL7 proc
24790:
Help - Sql Server 2005 at a crawl on Win 2000 Server
24791:
Connecting to a remote SQL Instance
24792:
Is IDENTITY_INSERT OFF safe?
24793:
2 questions on Sql server query
24794:
Help with looping through records in stored procedure
24795:
Turn this SP into a view!
24796:
View Current Position of Transaction Log Restore..
24797:
Table organization with different types of IDs
24798:
Date Parsing using T-SQL
24799:
find the first row of ordered records that sum is less than a cert
24800:
Tough SQL problem, need expert advice!!!
24801:
Advice Requested : Trying to write portable SQL
24802:
Any good way to convert a row to one varchar column?
24803:
decimal data type
24804:
pros and cons of a shared data architecture
24805:
Insert by Parameter
24806:
trigger will not execute
24807:
Using LIKE operator and spacing to search SPs
24808:
udf timing out from stored proc
24809:
Unable to bind SQL Breakpoint at this time
24810:
Selecting and running multiple SQL scripts
24811:
ALL IN ONE SQL STATEMENT?
24812:
Running package using dtexec
24813:
Comparing dates in one field
24814:
Obtain values from different tables
24815:
How can I update the col value using extended stored procedure
24816:
Maintenance Plan Wizard
24817:
Dynamic View
24818:
How to add separator blank rows by SQL Query?
24819:
Identity or GUID?
24820:
Using charset iso-8859-2 (Latin2) ??
24821:
Make 1 query from 2 tables
24822:
xp_regread problem on Windows XP
24823:
Identity Columns - Design Question
24824:
User defined fields via application
24825:
Lookup in SSIS package
24826:
Access "inserted" / "deleted" from stored procedure
24827:
Scripting Result of a query
24828:
query plan on sql server 2005
24829:
Index Tuning
24830:
Web design High-quality web & graphics Designs.
24831:
Running Sum Query ?
24832:
Error: 50001
24833:
Custom SQL library ?
24834:
Connection from command prompt
24835:
Creating dynamic table in SP
24836:
nvarchar = utf-16?
24837:
Passing Date Variables
24838:
SQL 2005: How to store output from Stored Proc in a Table?
24839:
Permissions
24840:
Why do triggers fire?
24841:
how to update time portion of datevalue to 00:00:00?
24842:
finding lower case data
24843:
Converting to ANSI joins
24844:
Simple select question
24845:
syntax of UDF
24846:
Rescursive Sort Sql Server 2005. How to sort by name in a function (see example)
24847:
How to get missing rows?
24848:
Update Question
24849:
Ansi_Padding - how to get rid of
24850:
complicated query