6651:
QUERY WITH (Index =0)
6652:
update statement
6653:
Is there a way to do this?
6654:
The Tears Of Finding The Truth
6655:
How to avoid UNION
6656:
How to avoid UNION
6657:
Scaling oltp application
6658:
A new type of aliasing in 2005?
6659:
Is is possible to create a stored procedure to backup a database in MSSQL EXPRESS?L
6660:
Permission to assign user permission to database
6661:
Another query help needed...
6662:
Help with pivot query
6663:
Cannot truncate a table because of foreign key
6664:
Another SQL query question
6665:
Parsing question
6666:
SQL Server problem
6667:
:::@@==>>3 FREE LIVE CAMS<<==@@:::
6668:
Welcome to my webside that provides help in English Study for
6669:
check for values in a table
6670:
Parse output of a command file
6671:
cant get this to execute
6672:
SQL server message
6673:
xp_cmdshell to include variable
6674:
@@servername vs machinename and triggers
6675:
Dynamic tables and classes
6676:
Check constraint
6677:
sys.dm_exec_query_stats total_elaspsed_time negative value
6678:
Check constraint expression between 2 columns
6679:
Earn $5000 and more per month
6680:
cumulative change query
6681:
find second entry date for each user
6682:
When to use multiple databases?
6683:
HTTP Post from SQL server side
6684:
Update the Select Query within a View
6685:
update date using trigger?
6686:
Select * question
6687:
Best way to Secure connection string
6688:
Get sqlcmd output into a table?
6689:
how to trim off linefeed characters <br> from a string?
6690:
SQL Requirements for Workflow Foundation
6691:
Create Schema Version of the Entire DB
6692:
Calculate Shift from Date Time
6693:
prevent from SQL Server from deoptimizng the query... FORCE ORDER
6694:
selecting top rows with unique column
6695:
Index recommendation
6696:
T-SQL: Cursor doesn't work correctly...
6697:
how can i create some dynamic execute SQL task inside DTS package
6698:
Get Constaints of a table
6699:
view inside with IF statement
6700:
Find unique counts of logon sessions
6701:
How to save xml resultset of stored procedure as a xml file
6702:
Query Help
6703:
Clustered Index Scan Operator has like a warning sign
6704:
Pivot Cross Tab columns to one row
6705:
Trying to show 4.950000 as 4.95
6706:
total_elapsed_time
6707:
Error showing after adding new fields to a stored procedure
6708:
ASP.NET Membership
6709:
check for identity type
6710:
need query
6711:
Select random records dilemma
6712:
Alteration of UDT
6713:
Add 2008 partitions
6714:
SEX, SEX, AND SEX
6715:
Partitioning problem
6716:
Syntax error converting datetime from from character string
6717:
Loss of data in sqlserver
6718:
WHERE myCol IN (@myParam)
6719:
Self join table and group fields
6720:
urgent! about integration services LOG
6721:
Help understand and then write a query
6722:
PageRank Explained - Keeping SEO Simple
6723:
T-SQL Query When String variable is NULL in the WHERE Clause
6724:
No. of times entries are made
6725:
updatable views win SQL server 2000 or 2005
6726:
Change operator email on 28 SQL Servers 2000
6727:
howt to declare a variable for a table
6728:
howt to declare a variable for a table
6729:
change timestamp on SP
6730:
MDMP Files
6731:
Need help with SQL Statement
6732:
List all tables without a certain column
6733:
how to read from and write to sql server mobile
6734:
Extended Stored Procedures Can be Executed
6735:
Alter Table - for memory table?
6736:
help hisham to set up an online business
6737:
M`I,5`Persecution . BB C Newscaste rs Li e & D eny They re Watchin g Me
6738:
M`I'5-Pers ecution - Four Years of MI 5 P ersecution P osts on Inter net Ne wsgroups
6739:
M'I-5 Pe rsecution ' MI 5 Wast e Taxpaye r Millions on Point less Hate-Campai gn
6740:
M'I`5'P ersecution Com paring th e MI 5 P ersecution wit h Germ an Fin al Soluti on
6741:
i want to make a select
6742:
Find growth rate
6743:
Database role question
6744:
sequence with no hole?
6745:
buy cheap shoes (www.shoes-ec.com)
6746:
Histogram report
6747:
do case sensetive compare
6748:
Buy viagra where order Viagra online Buy Generic Viagra
6749:
Corporate Moving Relocation Service.
6750:
buy cheap shoes ( www.shoes-ec.com)
6751:
one large vs several small tables
6752:
find database by sql_handle from dm views?
6753:
Find nearest values above and below x
6754:
PLZ HELP!! update value in one table through count of string in
6755:
Shopping Discounts
6756:
Positioning
6757:
How seo effect search engines results ?
6758:
trigger nesting level exceeded
6759:
Stored procedure, insert into, could be a lot of things
6760:
Stored procedures
6761:
Los Angeles Movers Moving Services Company in California
6762:
RESEED identity to zero
6763:
Check for temp table existence
6764:
programmatically accessing the profiler
6765:
need to join hex value stored as string with equivalent integer va
6766:
sysprocesses says my app still connected after close connction in
6767:
store proc Timeut Expired.
6768:
Splitting out a field results into colums
6769:
insert into a dynamic table name
6770:
problem to login SQL 2000 server.
6771:
Debugging C# stored procedures - 64 OS, 32 bit SQL Express
6772:
Create nested stored procedure help
6773:
Trying to combine a "Running Total" calculation with an UPDATE in one
6774:
proc in SS2005 that can execute statement on SSAS?
6775:
varchar
6776:
Collation Issue When Using Print in SQL 2000
6777:
Moving staging data to a staging database
6778:
possible in 1 query?
6779:
build cubes
6780:
Remove <> brackets
6781:
Design tags functionality
6782:
Remote tables and WHERE clauses
6783:
Deficiencies in T-SQL language
6784:
need way to script out users and their roles
6785:
[WORKAROUND] How to find out who is currently holding an application lock
6786:
Design question for survey/questionnaire type application
6787:
String comparisons
6788:
Left Join using subquery?
6789:
generic script to delete data from set of tables
6790:
How Do I append a table in SQL Server
6791:
Naming foreign key constraints in SQL 2000 / 2005?
6792:
Counts and group by
6793:
SQL 2008 Change Tracking
6794:
Help With Custom Job Queue
6795:
Return Timestamp after insert or update
6796:
Table size
6797:
Searching for Happiness ?
6798:
setting parameters on cmdShell
6799:
refresh a passthrough query without runing it again
6800:
VB with SQL Server Compact 3.5
6801:
How to get number of days of a Particular month in SQL-SERVER 2005
6802:
sql query
6803:
unpivot table in 2005
6804:
Prevent - The log file of TempDB is full?
6805:
Reading Rows Sequentially
6806:
how to display Raiserror() generated in Trigger
6807:
proc perf question
6808:
Trigger to capture Inserted error data
6809:
TimeStamp
6810:
Stored Procedure Programming
6811:
Running total - output.txt (0/1)
6812:
Sql2005 and IIS6 Search Index
6813:
Question about using .Net assemblies in SQL Server 2005
6814:
Making OPENROWSET configurable and using a cursor
6815:
=?GB2312?Q?=A1=D1_=A1=D1do_business_by_internet?=
6816:
Security issue - user logging into my development machine
6817:
Req: SQL Developer / DBA
6818:
report a list
6819:
Connecting to SQL Server (directly) from Compact Framework
6820:
Copy database using stored procedure ?
6821:
Query Help for combining data
6822:
SQL Query without using temp table
6823:
Error : Incorrect syntax near '('.
6824:
The media set has 2 media families but only 1 are provided.
6825:
Unexpected return from web service
6826:
The log file for database 'Administration' is full. Back up the
6827:
Question about a query
6828:
SQL Field Polulation Help
6829:
Query with read perrmissions on RowLevel
6830:
Strange Behavior with Bulk Insert
6831:
ResultSet Paging and count(*) performance
6832:
Gaps in IDENTITY When Insert Fails
6833:
Matching Users/Logins to AD renames
6834:
Live data architecture
6835:
Can't close DataReader
6836:
store procedure run parallel
6837:
Primary Key with two columns
6838:
SQL Server 2000 PK Indexes and Constraints
6839:
trigger + rollback
6840:
T-SQL: what was the date of the 17th Sunday in 2002? (for example)
6841:
Creating Package for SqlMgmt studio
6842:
temporarily disable constraint to allow data delete
6843:
SQL 2005 - User account confusion for converting from Mixed mode to
6844:
calling the same sp on with different users
6845:
buy product send web
6846:
Ways to improve speed of this query
6847:
how to use looping conditions
6848:
OPENDATASOURCE to Active Directory w/out a linked server
6849:
SQL Syntax Check
6850:
2 queries in a stored procedure
6851:
Nolock hint and remote database.
6852:
Query Help for total Novice
6853:
Select a column dynamically?
6854:
Query Help - SQL Server 2000
6855:
newbie - caculating value question
6856:
Create Temporary Table from results of Query
6857:
Object Reference
6858:
rebuild index fails
6859:
Query one database with list acquired from another database
6860:
CASE function, time-consuming or not?
6861:
ExecuteXMLReader and FOR XML
6862:
Replace a substring at specified position
6863:
mail
6864:
Viewing large queries
6865:
Adding data
6866:
sql server 2005 job failure information
6867:
add another column to output of a stored proc
6868:
poor prepared SQL execution speed problem
6869:
One Fact or Two?
6870:
MAXDOP and DBCC
6871:
Multi server maintenance plan errors
6872:
Script for Permissions
6873:
sql statement for numbering wanted
6874:
sp_OAMethod returns result set
6875:
DELETE trigger
6876:
installing sqlserver 2005 on low spec machine
6877:
Is it possible to use an optional parameter in a stored procedure?
6878:
patindex query question
6879:
Pivot Function Question
6880:
appending a table to a master table
6881:
Auto increment
6882:
delete records in mssql2005
6883:
how to remove seconds from the getdate() function
6884:
Why Stored Procedure slow?
6885:
Word Count
6886:
Is parameter sniffing making by stored proce slow?
6887:
sqlcmd and bcp won't fit the bill - Bulk Import help please!
6888:
Please help with this query
6889:
=?ISO-8859-1?Q?**_**The_Grand_Bazaar*_<http://turkeyphotogallery.?=
6890:
how to remove spaces while exporting a table into excel
6891:
I have Installed Sql Server 2005 but cant find Query analyser | Help
6892:
The package execution failed, the step failed... help
6893:
#### How To Turn Your Dull Website into Money Making Website####
6894:
doubts in using cusors
6895:
Help with Sql Server 2005 Integration Services (SSIS)
6896:
Store procedure
6897:
A question of style
6898:
INNER JOIN vs. WHERE for performance issue
6899:
Stored procedure. Finding data between two dates
6900:
Problem with CONTAINS clause and single-quote
6901:
Param driven Order By on three columns of different data types
6902:
Recursive CTE
6903:
Trigger to block negative values in a column
6904:
sys.dm_exec_cached_plans "usecount" wrong for CLR SPs
6905:
Delete a record with an empty text field
6906:
Inserting Into a Table
6907:
CURRENT_TIMESTAMP vs GETDATE
6908:
if you have a warm winter
6909:
Is this Possible in SQL
6910:
=?ISO-2022-JP?B?KHd3dy5nbG9id2hvbGVzYWxlLmNvbSkbJEIiKxsoQkNoZWFwIFdob2xlc2FsZSBTaG9lcy1IYW5k?=
6911:
Unused Indexes DMV - query help
6912:
Can not get value of textbox in footertemplate of repeater
6913:
gouping counting
6914:
Retriving Records By Date (Current Month)
6915:
Architecture question...can this be done?
6916:
Help Changing Database Owner on New Database
6917:
Adding multiple constraints.
6918:
VIEW question
6919:
SQL Server BCP utility to copy a table in and out of SQL Server to a CVS file
6920:
Copy DTS package from one server to another
6921:
Convert Money on Sum not working
6922:
Sub Query Help
6923:
Query Help ( Almost finished! some help is needed )
6924:
Which version of SQL Server did the INTERSECT operand become avail
6925:
repeating WHERE conditions in nested select
6926:
SSIS import doesn't fire trigger
6927:
=?ISO-8859-1?Q?Hot_sell_Cheap_Shoes_Handbags_Hoody_Jeans_Watches_MP?=
6928:
identity columns - use of with ADO (not ADO.NET)
6929:
newbie DISTINCT problem
6930:
Creating INSERT statement in trigger using INFORMATION_SCHEMA.COLUMNS
6931:
Trouble with Alter Table / Alter Column adding defaults.
6932:
EM: How to restore a database?
6933:
Runtime
6934:
Deploying SQL Server Databases to clients can be a pain
6935:
SQL rollback scipt?
6936:
Problem joining table A with lastest row in table B
6937:
Help with Internal SQL Server error?
6938:
drop constraint, problem
6939:
Logic in WHERE portion of SELECT statement
6940:
Issue in Sending Large Unicode data Through xp_smtp_sendmail
6941:
Issue in Sending Large Unicode data Through Mail
6942:
Optimisation - help with indexes
6943:
I have an old .mdf file that I can attach to SQL Server Studio
6944:
Backup error
6945:
Trigger help!
6946:
Upsizing Access Queries with Parameters
6947:
You tried to assign null to a variable that is not a variant data type
6948:
need help with writing a query
6949:
Dynamic sorting by column name passed into stored procedure
6950:
T-Sql to return multiple "hard coded" rows....
6951:
getting most recent Order
6952:
full calendar dates in sql
6953:
Error opening datafile: Access is denied.
6954:
auto translate=false in ADO.NET 2.0
6955:
Problem with restore - SQL Server Login access problem
6956:
how to duplicate a existing row
6957:
Using a stored procedure to create a table.
6958:
Trying to tune a query
6959:
Re-Inventing the Wheel
6960:
A simple way to audit select statements
6961:
Convering year, month, and day integers to a datetime value
6962:
SQL Error Log : OT
6963:
Trying to get job to send email when done. Failed to notify 'opera
6964:
Select only fields that match the query
6965:
How to select
6966:
excessive paging displayed in Performance Monitor...now what?
6967:
ADO Connection to SQL server is timing out
6968:
View include table index ? -- SQL 2000
6969:
Inconsistent Stored Procedure
6970:
null constraint on field
6971:
CASE and IS NULL
6972:
Programatically Import Text File Into SQL Server 2005
6973:
how to run sp for each record in a table
6974:
Column Output Length
6975:
SQL SNC Native Client
6976:
Christmas Shopping Deals
6977:
Strange OR vs UNION performance
6978:
Collation settings between Countries
6979:
trigger to Oracle database ...
6980:
Re-inventing: scripting of indexes
6981:
problem with while loop
6982:
Notify when query is running more than 100 min
6983:
Best book on TSQL?
6984:
Error trapping in T-Sql
6985:
SQL 2005 to Sybase
6986:
Why do connections from Access change UID to dbo?
6987:
User() always returns "dbo" when using MS Access Pass-Thru
6988:
Deadlock on an update affecting a single table
6989:
CLR User-Defined Function in VB.NET for NT Group Lookup
6990:
Collation Level conflict
6991:
How to not show repetitive data
6992:
Audit Trigger
6993:
Saving stored procedure - sql 2005
6994:
how to get values for missing datas while joining tables
6995:
performance question
6996:
Creating and aclling a function
6997:
Cursor behaviour
6998:
@@error
6999:
dts-package sends files before the task finishes
7000:
Re: sp_OACreate in SQL Server 2005, Fails with 'Not enough storage is