19951:
Synonym Schema Issue (Change in Schema Version)
19952:
How to pass a list of parameters from Select Table
19953:
Read system catalogs for a from another user
19954:
Storing all Upper Case value
19955:
SELECT IIF(True,Null,'' ) equvalent in sqlserver
19956:
Backup of mssql server in LAN
19957:
Application design help: ADO.NET
19958:
VARCHAR(8000) Does Not Work
19959:
Database design question
19960:
Selecting minimum between 2 values - Sybase SQL
19961:
What is it that I don't understand about varbinary and datatype co
19962:
best way to bulk update
19963:
sproc variable question-newbe
19964:
Running Average Query ? A Challenge
19965:
SQL 2005: Pivot question
19966:
Problem with full text index in farsi language
19967:
Which function can convert number value to string with lead zero?
19968:
Displaying time as 1:20 PM
19969:
I have no blog
19970:
Trigger logic - this ok
19971:
Trigger question
19972:
xml file into table
19973:
'System.OutOfMemoryException' ?
19974:
Formatting and returning Time from Text
19975:
Deferred drop
19976:
rows to column sql server 2000
19977:
Copying data from 2000 to 2005. Indentity insert not working
19978:
Views Vs Stored Procedures!
19979:
"Order By" Parameter to a Stored Procedure
19980:
Migrate data from Access to SQL 2005
19981:
Migrate data from Access SQL 2005
19982:
Can an email trigger a DTS Package?
19983:
ALTER TABLE
19984:
HOW TO CALL A USD IN A SP
19985:
Alter Seed value of Identity column
19986:
Order by causing query to return very slow
19987:
SELECT INTO temp table - Pros and Cons
19988:
Even after year of coding I ask...
19989:
SQL Server 2000 setup issues
19990:
can't connect to sql2k5 server remotely
19991:
Challenging query
19992:
How to implement transactions
19993:
Making Sql Server public?
19994:
how to return only numeric chars from column?
19995:
Top 2 max operations
19996:
error debugging in query analyzer
19997:
Is it possible to return all parent rows but only first child row of each parent for a t-sql join?
19998:
How to tell if an Index has ever been used...
19999:
Passing a table into a function
20000:
Help with SELECT statement
20001:
can Case test for < or > values?
20002:
Mdf and Ldf files
20003:
Trigger testing
20004:
Can I create an index on a varable table
20005:
Trigger Tricks ?
20006:
Case-Sensitive Text Comparissons
20007:
UDF function
20008:
Update row with cursor joining to another table
20009:
Exec cannot see Inserted?
20010:
INSERT LOTS of values
20011:
Query Works fine in Access but not in SQL Server
20012:
Query Works fine in Access but not in SQL Server
20013:
Query Analyser Debugger
20014:
pull table Schema
20015:
Query Problem
20016:
Update/Insert and Delete Query Optimisations
20017:
Check constraint script problem
20018:
Get last date in result set
20019:
Managed Stored Procedures
20020:
Rounding datetime
20021:
Deallocate cursor overhead
20022:
query same table twice for different users in one query?
20023:
How to limit date Range
20024:
Log Shipping & Query Plans
20025:
Access current active workbook from DLL
20026:
DECLARE and table strucutres
20027:
Visual Basic 6.0 vs .NET Framework
20028:
SQL Guru's - please help paging with a distinct recordset
20029:
Attach and detach a standby database in SQL 2K5
20030:
use sp as default column value
20031:
Are SProc parameters stored in a system (2005) table!
20032:
Import XML using FOREACH Loop container
20033:
xp_smtp_sendmail send out corrupted email message for large attach
20034:
inner join in an update
20035:
TOP 10 for each group
20036:
Computing Medians The Joe Celko Way
20037:
UDF that take a UDT as a parameter (CLR)
20038:
Help with SQLServer2.Connect()
20039:
Table reaching max value of identity very early
20040:
Crosstab, Pivot?
20041:
using variable as servername?
20042:
conditional driven Stored Procedure
20043:
Paging with ROW_NUMBER on filtered records (SQL SERVER 2005)
20044:
encrypt a field in a table
20045:
FOR XML AUTO, ELEMENTS Problem
20046:
how do I test the cost of udf?
20047:
trying unsuccessfully to produce OSQL error
20048:
sql query similar to excel pivot table
20049:
Question: How to pass ADS username from C# to trigger
20050:
Delete with inner join
20051:
current Date query
20052:
Unable to debug Stored procedure with VS 2003
20053:
Problem tuning procedures with temporary tables
20054:
INSERT query
20055:
Swap field values in UPDATE
20056:
SQL Server 2000 Driver for JDBC SP3
20057:
SubtractWorkingDays
20058:
Number of page per table in the cache
20059:
Select from a diffrent database in a Stored procedure.
20060:
XP_CMDSHELL error
20061:
From a browser insert or update data to a SQL Server 2005 table?
20062:
My scheduled task failed!
20063:
Split zipcode + city
20064:
Working Days
20065:
Retrieve PDF Image in Sql Server
20066:
Error Message
20067:
SQL 2000 Database Performance
20068:
Best table structure for that?
20069:
Slow data transformations from Oracle into SQL Server 2000
20070:
How does a view work
20071:
Feed Newline Character Into SQL Command?
20072:
Create Table code by Sql Management Studio has error
20073:
CONCAT Function
20074:
Help - How to Evaluate for and Strip Duplicates?
20075:
Change Query Table
20076:
Getting latest status record
20077:
Duplicate Database Table Names
20078:
Best way to insert data into tables without primary keys
20079:
Consolidating Rows into Columns
20080:
Changing data
20081:
Adding fields to a select into
20082:
Multi-User insert issue
20083:
What is new in Sql Server 2005 cursors?
20084:
Dynamic SQL Limitation
20085:
Logging an error during a transaction
20086:
Managin encrypted data
20087:
Select Query Help Needed
20088:
Create dynamic denormalized view
20089:
Cloning Datasets
20090:
Query Help
20091:
XQuery and Hierarchical Data
20092:
Syntax Error
20093:
error converting datatype varchar to numeric
20094:
Update Query in SQL 2005 with inner join
20095:
nesting select statements
20096:
Constraint such that only one record per group may be flagged
20097:
Viewing large fixed-formatted files
20098:
Do not rollback sql stmts executed before RAISE ERROR
20099:
VB running an executable
20100:
IF ELSE Statement
20101:
SELECT ... FROM TB_X WHERE FIELD1 IN (@PARAM1) @PARAM1 = 'A','B',
20102:
Help with Multiple Joins
20103:
insert statement problem
20104:
Add not null column without default
20105:
money vs decimal
20106:
How much impact to join table by isnull() or case when
20107:
How to do sizing on Memory requirement of SQL Server 2000 ?
20108:
syscolumns
20109:
SQL statement - Trim parentheses
20110:
When to do index maintenance, the cost of not doing it.
20111:
exec question
20112:
Time difference between two values SQL SP
20113:
Weighted Parameter Options
20114:
Joining to a one-to-many
20115:
SQL Server 2005 - Recursive CTE
20116:
SQL Server 2005: testing if user / schema exists
20117:
updating data with stored procedure value
20118:
problems sending email from a trigger
20119:
Accessing session specific data from a view
20120:
Backup Question
20121:
REVOKE ALL not working in 2005
20122:
MySQL as linked server
20123:
why does this not work: parameters on SqlCommand 'grant'
20124:
working with gaps in date series
20125:
Decimal value issue
20126:
How to get table data ?
20127:
updating data from different table
20128:
Where can deadlock exceptions occur with SQL Server (MSDE)?
20129:
cannot open table in sql server management studio express
20130:
=?ISO-8859-1?Q?=5B2000=5D_Looking_for_a_script_=3A_l?=
20131:
Parameter Array
20132:
DBO ID on a table
20133:
Join two tables on two databases, but no common field???
20134:
Generic function
20135:
Send Mail Using SMTP
20136:
normalization materials
20137:
Why the database data file is lost?
20138:
newbie needs help deciphering Sql Profiler Trace
20139:
Blocked by sysobjects?
20140:
Query Dilemma
20141:
Logins
20142:
Use T-SQL to restore DB with the latest backup set
20143:
How do I get the "xa_switch_t" exported by Sql Server
20144:
17207: udopen: OS error 32 occured while create/open physical device
20145:
Report help
20146:
Question on In-Line Table Functions
20147:
Is this dumb?
20148:
Locating Data Discrepencies
20149:
Why do I get different results with this?
20150:
Database partition clearification?
20151:
newbie: sending email from stored procedure
20152:
Sql 2005 ranking functions: super kewl or just ok?
20153:
decimal (11,2) to a fixed-formate
20154:
Request data replication/warehouse advice
20155:
using unknown number of parameters to filter query
20156:
SQL Server and Active Directory
20157:
Where to Store Lookup Values
20158:
OpenRowset SP call erroring out
20159:
stored proc insert,update and cursor
20160:
Need help with my stored proc
20161:
Combination and count problem
20162:
If NOT EXISTS
20163:
import from a spreadsheet be
20164:
SELECTing out duplicate rows
20165:
Where to store text files that contains embedded html
20166:
Update Records
20167:
1.9 million line transaction in profiler with no begin end using WAITFOR
20168:
changing column definition
20169:
SP random order
20170:
Storing Files in Database
20171:
Passing a set SQL statements to a SQL Server Stored Procedure from
20172:
List *MY* items that don't appear in the database
20173:
output parameter with default value needs to be specified in sp
20174:
Converting varchar to numeric problems
20175:
try catch....
20176:
Identity column as a foreign key - help needed in logic
20177:
Passing Array/Table Parameter to Stored Procedure
20178:
index size question
20179:
Field name parameter query in sql server 2000
20180:
Retrieving all order details for a specific product?
20181:
exec sproc within sproc fails to commit
20182:
Strange blocking problems
20183:
How do I get the "xa_switch_t" exported by Sql Server
20184:
Query pblm
20185:
get all month...
20186:
SQL Date Format
20187:
SQL Server Express w/ C# 2.0... Cannot find stored procedure...
20188:
using dbcc on linked server
20189:
xp_cmdshell doesn't work
20190:
arranging month from january to december
20191:
TSEqual 2005 & compatibility levels
20192:
Unicode Comparison.
20193:
Query help in Datatime
20194:
SQL Profiler "Server processes SQL server trace data" option info
20195:
problem about adding columns "alter table" statement in t_sql
20196:
Stored procedure help
20197:
What is the search query for that?
20198:
How do I place multiple records of a sub-query in one record?
20199:
Primary Key
20200:
Query working in EM and QA but not in Store proc
20201:
Please help me with a SELECT
20202:
Triggers: using checksum()
20203:
Security (How to protect SQL Server)
20204:
Postcode problem
20205:
Implicit conversion from datetime to int not allowed
20206:
Mitery variable
20207:
Query Problem
20208:
String concatenations
20209:
Query Problem!
20210:
DATEPART Gives different answers on different machines?!
20211:
Deadlock problem
20212:
Numbering rows in SELECT query?
20213:
About Cursor on Dynamically created Tables.
20214:
SQL Emergency! Need Help
20215:
Incorrect syntax near the keyword 'End'.
20216:
Union-Record count difference when a column is used in the select
20217:
Creating 2nd transaction form inside db ?
20218:
Restoring data from SQL2005
20219:
Windows Integrated Security
20220:
Requesting network information
20221:
Date between two wildcards
20222:
Record searching question
20223:
Unicode Comparison.
20224:
SQL server 2005 query problem
20225:
Add a Column at Particullar Position n MS SQL Server
20226:
newbie: comparing dates in sql
20227:
SQL 2005 Ordering in 2 directions
20228:
testApp error LNK2005: "unsigned long * Table_CRC16" (?Table_CRC16@@3PAKA) already defined in CRCTest.obj
20229:
get data between specific rows
20230:
SQL server connection problem
20231:
HOW TO TURN $6 INTO $6,000!!!!!! READING THIS COULD
20232:
Query question
20233:
newbie needs help with trouble shooting
20234:
Problem updating large number of records
20235:
Trigger When Row Changes
20236:
How to list all indexs from a table?
20237:
import 1 mln records = problem
20238:
Displaying numeric values
20239:
Doing JOIN with multiple table on multiple fields in each table
20240:
I found a tickets site
20241:
½«SQL 2000 ǨÒÆÖÁ2005¼¯Èº
20242:
I found a tickets site
20243:
SQL Server 2000 - 64bit version - extended procedures
20244:
concatenate column from rows
20245:
Need stored proc. Add record to Tbl2 if it exists in Tbl1 and not
20246:
Scheduled VS Made
20247:
select last row for each value
20248:
Processing rows in a trigger
20249:
Smalldatetime problem during INSERT to DB
20250:
Some records in a column imported as null
20251:
Get the script for an object using T-SQL (without using SQL-DMO)
20252:
Divide By Zero - How to Prevent with the following statement
20253:
Data Modeling: Variable Number of Attributes
20254:
CASE in WHERE clause
20255:
Job and Exe
20256:
Determine Index Usage...
20257:
Query Help
20258:
advanced proximity search
20259:
Fixed Formatted File
20260:
IF Statement - Whats Next
20261:
Grouping sysjobhistory
20262:
SQL server returns error in query analyzer
20263:
slow Table function fixed by resaving
20264:
command REPLICATE in sqlexpress2005
20265:
install sqlexpress 2005 with specific collate
20266:
Marking (Not just Finding) Duplicate Values ......
20267:
SQL update from itself
20268:
(repost) How is the design for this complex requirement ?
20269:
Help: RAISERROR, RETURN value and application level database interface question.
20270:
Select part of a string
20271:
Restore problem using SMO and SqlRestore
20272:
Order details table reference live data
20273:
UPDATE in a SQL script file is not working.
20274:
Problem with WHERE clause
20275:
Re: If Else Statement
20276:
If Else Statement
20277:
query mistake
20278:
Installing stored procedures and functions
20279:
Data Merging
20280:
Get the latest date for each ID
20281:
Are there any online instructors in sql server?
20282:
Adding references to CLR User defined functions
20283:
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
20284:
How to list all Procedures and Functions with sp_xxxx?
20285:
instead of insert trigger
20286:
Phantom Transaction
20287:
Round Function 2dp
20288:
About query performance
20289:
SET/SELECT truncate string
20290:
IP address problem
20291:
I found a tickets site
20292:
INNER JOIN With more than one join condition
20293:
Case expression
20294:
Chunk of rows in without using FETCH NEXT.
20295:
DERIVEDTBL question
20296:
Same databases on two different servers...I get different execution plans on each database...why?
20297:
SQL 2005 versus 2000 performance - things to watch out for?
20298:
INSERT based on a date range
20299:
how to display unicode data
20300:
JOIN Confusion