29751:
Calculations
29752:
Joining tbls from different db's with WHERE statement
29753:
Diffrent between UNIQUE KEY and UNIQUE Indexes
29754:
Diffrent between UNIQUE KEY and UNIQUE Indexes
29755:
Is it possible? dts encrypted
29756:
Easy Query
29757:
synching between 2 sql server
29758:
sproc help needed
29759:
Complicate select statement (I think)
29760:
In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables.
29761:
Enterprise Manager causing blocking
29762:
User Defined Function returns table
29763:
Returning Scope_Identity() for GUID
29764:
Yukon xp_cmdshell setting
29765:
Regarding Data Transpose
29766:
SQL Query Question
29767:
ImpersonateClient Property in DMO / SMO
29768:
Inserting regional settings specific data into sql server
29769:
Inserting Regional setting specific data into sql server
29770:
SQL Profiler not tracing errors
29771:
Index and view
29772:
OT: Dev Box Configuration
29773:
an aggregate may not appear in the set list of an update statement
29774:
Determining Relevance with Least Amount of Queries
29775:
Partitioned View - Errors after bulk insert
29776:
SQL 2005 User DB Permissions
29777:
Move record according the time field of the record
29778:
Question
29779:
parent-child relations table...
29780:
enumerate suffixes and counts in varchar column
29781:
SQL Server Express 2005 user instance w/OLE DB?
29782:
SQL Server Express 2005 user instance w/OLE DB?
29783:
Cast datetime to smalldatetime error
29784:
would all of you recommend a book in terms of SQL 2005???
29785:
Cursors with UNION in select doesn't work?
29786:
data mining
29787:
Stored Procedure question
29788:
Importing a word document into SQL Server
29789:
trunc or drop & create/log file
29790:
Inserting NULL Into An IDENTITY Column
29791:
Updating Schemas
29792:
Complex(?) SQL Query
29793:
SQL Query
29794:
SQLAgent - Initial Boot Probe
29795:
Active Directory and SQL 2000
29796:
SSIS Problem with Excel
29797:
SSIS Problem with Excel
29798:
Partitioned Views
29799:
SSIS Problem with Excel
29800:
Sql Query Question
29801:
interacting with C++ as programming language and SQL SErver as DB
29802:
ARITHABORT and Indexed Views
29803:
Need some assistance
29804:
MSWord smart quotes and SQL Server
29805:
variable in case statement
29806:
Tuning my SP or UDF
29807:
URGENT - Removing spaces using T-SQL!
29808:
DTS package workflow
29809:
select filtering with NULL values
29810:
Best hw recommendation for a sql server - server.
29811:
SQL Server 2000 on Windows Server 2003
29812:
Is a trigger the best way to achieve this?
29813:
Is my UPDATE statement buggy?
29814:
Query Help
29815:
Declaring Large Variables In SProc
29816:
Selecting one row or the other, not both
29817:
SQL Server 2005 Taspad
29818:
Clustered Indexes
29819:
Reference another database without hardcoding the name of it...
29820:
Group by bi-weekly
29821:
Table design problems
29822:
change the data results from vertical to horizontally
29823:
Updating a table on another server
29824:
Problem with Excel to SQL 2000 Data flow
29825:
Performance Problem
29826:
Different Port
29827:
Simply performance/index query
29828:
How to find the Froiengn key refrence column and refrence table through T-SQL
29829:
BCP generates 0x00 characters
29830:
Query Help
29831:
What to do with multiple table joins
29832:
Database Size Limitations
29833:
assigning sysadmin rights to login through O-SQL
29834:
WHERE clause two parts - execture second part with OR if first part returns 0 records
29835:
how to get minimum value from a list of user defined values
29836:
Passing DateAdd Parameters Via Sproc
29837:
SQLDMO and application role
29838:
script indexes
29839:
GROUP BY/select list error
29840:
SQL Server 2005 Enterprise Manager x64
29841:
2000/2005 Handling UPDATE with mixed locking hints differently
29842:
validate e-mail in SELECT
29843:
Sql Server 2005 64-bit and IFilters/Wordbreakers
29844:
Setting SQLAgent Job History
29845:
HOWTO Pass TEXT and NTEXT to extended stored procedures.
29846:
date time transformation
29847:
Developer edition 2005 upgrade to standard 2005?
29848:
CSession accessed by multiple threads?
29849:
date query when date field is char and mmyy format
29850:
Not using cursors??
29851:
SQL Server 2005 insert / update fails
29852:
Performance question
29853:
SQLServer 2005 64-bit Linked Server to Oracle
29854:
Trigger taking long time to be updated?
29855:
T-sql error handling when using sp_executsql
29856:
Incorrect syntax near 'E' in SQL Server 2005
29857:
Joining different data types
29858:
Advance SQL Statement Help
29859:
cursor is running too slow
29860:
help with a simple query
29861:
capture database logins
29862:
data design question
29863:
New Version of SqlClrProject (again)
29864:
Importing XML
29865:
User Server Roles
29866:
Maintenance plan issue
29867:
QUERY Help
29868:
Loss of unicode symbols
29869:
Suspect status. Critical issue
29870:
SQL Server Version Identification using SQLDMO.dll
29871:
Stored Procedures . parameters and Linked Servers
29872:
[OT] User-Defined string Functions MS SQL Server 2005 Transact-SQL
29873:
xp_sendmail: failed with operating system error 5
29874:
Date question
29875:
Another way than using a Cursor
29876:
Help optimising a stored proc
29877:
help with trigger. insert date1 into date2
29878:
trigger to insert date1field into date2field.
29879:
a TSQL question
29880:
Dateproblem
29881:
altering temporary tables
29882:
DTS Package - Execute Sql Task
29883:
Using SELECT DISTINCT
29884:
name of the variable (228 row(s) affected)
29885:
sp_fkeys slow in SQL 2005
29886:
one for the SQL experts - dare I say TRICKY SQL!
29887:
Could sp_addlinkedsrvlogin works for a windows login?
29888:
Declare a variable in an SP
29889:
Convert HH,MM to decimal ?
29890:
find all users in a sql server group
29891:
Can this stored procedure be optimised?
29892:
Help with OpenXML
29893:
Adding a new column in a certain position....
29894:
how to optimise a select joined select statement
29895:
best practice retrieveing current identity value
29896:
Ambiguos of the ORDER BY
29897:
calculated value based on values in other row
29898:
CDO mail attachment is not working
29899:
can't alter column to NOT NULL
29900:
Minute table?
29901:
Creating a link between 7.0 and 2000
29902:
audit trails
29903:
nested update triggers
29904:
stop a column from being updated
29905:
"ImpersonateClient" property in Yukon
29906:
Outer Join - Returning Customers Who Haven't ordered a product
29907:
Summarizing and changing the direction from vertical to horizontal of DATA
29908:
Need help with SP
29909:
What the CHECKIDENT() checked??
29910:
Using ID from an Inserted record in a second insert
29911:
View breaks when I add a column to an underlying table
29912:
Editing views in 2005 Management Studio
29913:
Transact SQL: Urgent (simple) algorithm help needed
29914:
SELECT CASE WHEN ... problem.
29915:
Naming Conventions: PK/FK Column Names
29916:
Execution plan says statistics are missing but they do exist
29917:
Internal SQL Server error. Error 8624
29918:
SQLDMO question
29919:
OPTIMIZING QUERY
29920:
Linked Server Question
29921:
how to insert records where PK is being violated on some records?
29922:
Maximum date with a twist
29923:
Complex query I need help with.
29924:
transaction log grows at twice the rate of our data
29925:
Unique index problem
29926:
how to find out reporting services version?
29927:
Stored Procedure parameter(s) for an IN operator
29928:
Security flowing into a SP
29929:
Trying to modufy column
29930:
Multiple variables in fetch
29931:
SP_MultipleRecord_Sets --> One Record Set
29932:
Persisting a recordset to XML efficiently
29933:
Copying a column names from one Database to another Database
29934:
Creating Defaults using Column Names
29935:
Complex SELECT pulling data from three tables
29936:
express EM
29937:
Huge number of exception events related to temporary tables
29938:
CTE Optimization
29939:
Uniqueness of a column allowing NULL values
29940:
T-SQL to implement the DTS transform task for large tables?
29941:
Viewing Particular Databases
29942:
CHARINDEX doesn't work
29943:
enforcing unique
29944:
Group By then Concatenate strings
29945:
Help with SQL Query
29946:
SQL query to test for a Filters existance with smallest performance hit..
29947:
Function to Convert Char to Hexadecimal
29948:
comparing dates
29949:
Debugging Stored Procedure
29950:
I need Optimised duplicate finding query
29951:
Joining when rows don't exist.
29952:
SELECT right after INSERT returns empty
29953:
Client user timeout
29954:
Sql Sever Property
29955:
FIND THE FOREIGN KEY FOR A TABLE
29956:
Case Statement!
29957:
Can I use Unicode as Primary Key? For example, Chinese Character. <eom>
29958:
Deleting duplicate data
29959:
Organization Chart (Database Design Problem)
29960:
Sql Server 2005 Full Text Catalog Question
29961:
project deployment issues
29962:
combining 2 or more columns "as" one column in a select statement
29963:
Where is the OpenFileDialog?
29964:
Stored procedure performance
29965:
Violation of PRIMARY KEY constraint - can SQL give row details?
29966:
Number Generator?
29967:
Select statement based on Lenght of another field
29968:
Bound control timing issues in Visual Basic
29969:
SQL 2005
29970:
Last time a table was used..
29971:
Please help! Insert a picture in an MS SQL Server table
29972:
Insert a GUID Value
29973:
Help on DTS-Openquery timeout on linked server
29974:
use of inheritance
29975:
Return # of results that would have been returned without TOP
29976:
UDT Index
29977:
How can we call Function into Select qry ?
29978:
When does DATETIME() assume its value?
29979:
Very Interesting problem for Dropping SP & Index between databases
29980:
Reading SQL Deadlock-
29981:
set datefield default to a specific date
29982:
Automatic record counter in MS-SQL
29983:
Query - pop-up menu for user data entry
29984:
query performance
29985:
How do I suppress MS SQL result information
29986:
Ranking Functions: ROW_NUMBER() Performance
29987:
Qualifing table names with dbo
29988:
Help - Simple DataGrid Problem in Vis. Studio 2003
29989:
Look for differences
29990:
1 database, 2 threads
29991:
using crystal reports
29992:
linked server problem on SQL Server 2000 sp3
29993:
Group By (part of a field)
29994:
Stored procedures, nullable parameters, COALESCE
29995:
Putting SQL Artifacts Into Source Code Control
29996:
I want to store file's data into data base using MFC
29997:
Query Question ...
29998:
SQLDEvPRO What Happened to Aaron Goldman
29999:
Counting in Self Joins
30000:
Isolation levels and SELECT's (even when using SERIALIZABLE!)
30001:
Naming Conventions: Prefixing Columns w/ Table Names
30002:
Help with triggers
30003:
cascade delete ...
30004:
Lost Trigger
30005:
@@RowCount
30006:
design question : the sub-entities cohesion problem
30007:
Question about Converting Crystal syntax into SQL or VB
30008:
2005 Create new instance, replace sqlexpress
30009:
comparible match for numbers similer to Like and %
30010:
Need help grouping by year
30011:
Stats in backup / restore
30012:
Group By
30013:
Generating an SQL script for a DTS Package
30014:
@@Error and @@RowCount
30015:
Generate foreign key's DROP by ScriptTransfer
30016:
high-speed insert
30017:
Delete large amount of records
30018:
Return Related ID filed in MIN() Function
30019:
Connecting to SQL Server 2000 on Windows 2003 Server using sql-dmo
30020:
Deadlock on SQL SELECT statement
30021:
Importing csv File into SqlExpress .MDF file.
30022:
CLR function slow down with lilke statement
30023:
UPDATE values in a table with values from another table
30024:
pass thru queries to Oracle
30025:
UDT - how do i drop my type in sql server 2005
30026:
alias for variable [memory] table?
30027:
Complex query
30028:
DTSInstall.EXE is not created in my Deployment catalog
30029:
column info from temp table
30030:
some simple proc help
30031:
TSQL - Address cleaning
30032:
Query slow with hardcoded dates
30033:
thanks for the help, both solution works. best regards
30034:
how to specify mail sender when exec xp_sendmail from sql analyze
30035:
Advance TSQL question
30036:
Oracle MINUS equivalent in MSSQL2000 ?
30037:
Using VS2003/2005 to write a 2000 Custom DTS Task in C++
30038:
special caracters
30039:
unique records
30040:
Best Practice
30041:
How to Compare Date every day automatically?
30042:
How to list the names of check constraint of a table and how to show it's content?
30043:
Executing a DTS package
30044:
wsid() help
30045:
SQL Query - Isolating last row in customer record
30046:
Full Text Search on Encrypted columns
30047:
Foreign Key from two tables to one?
30048:
UDT in SQL server 2005 need help
30049:
Running low on drive space frequently.
30050:
Pintable with full-text search
30051:
Recurring Sequence Help
30052:
Can a CASE Staement be used in the WHERE clause
30053:
Encryption question
30054:
Problem with Bulk Upload. Uploads twice.
30055:
ORDER BY in a SP
30056:
Search for a field within an SP
30057:
Best practice BIT or SET('no','yes') ?
30058:
Composite Index and Query Optimizer
30059:
nvarchar(max) equivalent in C#
30060:
database object hierarchy
30061:
How are views used each time it is requested.
30062:
will a client application using ado.net get an exception if the command is executing a stored procedure that does a RAISEERROR in its tsql?
30063:
Disable Trigger Question
30064:
How can you prevent the data changes message during editing a row
30065:
Moving data thru linked server
30066:
problem with SP to return last @@Identity
30067:
How do I know if my sql server needs more memroy ?
30068:
trying to group by day without splitting day out in the select list
30069:
SQL2005 CLR Framework
30070:
T-sql
30071:
Function for Determining Completion Time
30072:
checkpoint
30073:
Is "SQL Server Management Studio" an OLE Automation Server?
30074:
Can I use dynamic SQL in a stored procedure to call another stored
30075:
ntext field is blank after insertion,all other fields are populate
30076:
Namespace
30077:
SQLServer Express Service Fails to Start
30078:
getting dates between start date and end date
30079:
how to optimize this procedure
30080:
How to make two filegroups to one filegroup
30081:
running a vb.net dll from sql server
30082:
Add two result values to a new result?
30083:
Update Query in stored proc
30084:
user permissions in a database.
30085:
multiple cascade
30086:
¿ Can you change a column id with statement ?
30087:
Exec a resultset to .txt file directly.
30088:
Persisting data in custom aggregate
30089:
trigger update on master-detail
30090:
Copy a table minimizing log space
30091:
Table Variable Problem, Please help!!!!!!
30092:
More info along w/max(ondate)....
30093:
Oracle "Dual" table equivalent in SQL Server
30094:
Extracting Data from Badly Designed Table
30095:
UDF to open xml file and return as table
30096:
How to parse millions of rows?
30097:
Executing SP for all results
30098:
Executing SP for all results
30099:
Conditional Where Clause
30100:
forcing a truncate