|
1664
|
Concurrecny vs Transaction
|
|
1663
|
TempDB
|
|
1662
|
shrinking database
|
|
1215
|
Date Only from Date/Time data
|
|
1214
|
Is SELECT MAX(ID) expensive when you have an index on ID?
|
|
1213
|
Yesterday excluding weekends
|
|
1212
|
How to not use distributed transaction?
|
|
1211
|
ADO XML (XHTML) SQL and DOM
|
|
1210
|
Question about Group By
|
|
1209
|
Create new table and insert records from another table
|
|
1208
|
Cannot add parameter to stored procedure, causes sp failure called from old ASP page
|
|
1207
|
Using EXEC + UNION
|
|
1206
|
Help required for a query ..
|
|
1205
|
troubleshooting ado.net ?? displaying parsed sqlcommand commandtext?
|
|
1204
|
Which Column Has the Data?
|
|
1203
|
intermittant OLEDB query failure
|
|
1202
|
Explain this query please
|
|
1201
|
Behaviour of Query with "not in"
|
|
1200
|
reporting services on flat files...
|
|
1199
|
Auditing Tbale Changes
|
|
1198
|
select 5 from UK, 5 from Germany etc...
|
|
1197
|
Query Help
|
|
1196
|
xml cdata outuput
|
|
1195
|
Uniqueidentifier Type, Keys and Efficiency
|
|
1194
|
xml explicit cdata
|
|
1193
|
Converting character to decimal for calculating and using math fun
|
|
1192
|
Recursive Triggers
|
|
1191
|
How to generate Sequence numbers for a primarykey (string datatype)
|
|
1190
|
Get Hierarchy
|
|
1189
|
Time lapse in sql
|
|
1188
|
uniqueidentifier vs IDENTITY ... not the same old questions
|
|
1187
|
CASE function in SQL
|
|
1186
|
Unique constraint on column allowing nulls
|
|
1185
|
attn: julina - truly beautiful active newsgroups - comzo ug ukga uzhe - (1/1)
|
|
1184
|
Paging records on SQL server using derived tables
|
|
1183
|
Query how to
|
|
1182
|
Swithcing Filegroups for a table
|
|
1181
|
bulk caching Smo Collections (Triggers, Indexes, Columns)
|
|
1180
|
T-SQL Identity
|
|
1179
|
CDOSYS
|
|
1178
|
INNER JOIN
|
|
1177
|
SQL Query Help
|
|
1176
|
Urgent - select statement
|
|
1175
|
VB remote connection to SQL 2005
|
|
1174
|
Subquery returned more than 1 value.
|
|
1173
|
SQL Server 2000 Sluggish Performance After Multiple Imports
|
|
1172
|
Cross Server Join
|
|
1171
|
Recurring orders database layout
|
|
1170
|
How to drop PK and FK constraints names generated by SQL Server 20
|
|
1169
|
The blog on Pc trouble shooting skills,Networking,Linux
|
|
1168
|
Instead Of trigger and accessing inserted virtual table from dynamic query
|
|
1167
|
Scripting roles with sproc?
|
|
1166
|
Is this a limitation ?
|
|
967
|
datetime null problem.
|
|
966
|
Forward engineer stored procedures from vss SQL 2005
|
|
965
|
Specs for SQL Server client machine
|
|
964
|
problems with distributed transaction
|
|
963
|
dbcc checkident to external server
|
|
962
|
SQL Query
|
|
961
|
Check job execution status with msdb.dbo.sp_start_job
|
|
960
|
Help with Select
|
|
959
|
MilliSecond Question
|
|
958
|
How to read text field in a stored procedure ?
|
|
957
|
Help with pro-rating annual amount
|
|
956
|
Listing all Functions in a Database
|
|
955
|
Domain Level Group
|
|
954
|
SQL Server 2000 Ranking
|
|
953
|
Tricky Query ( For me at leaset )
|
|
952
|
Suspect
|
|
951
|
How to get the database names with the active connections to the server?
|
|
950
|
How to pass result into another SProc
|
|
949
|
SQL Server 2005 Import and Export Wizard is hiding.
|
|
948
|
Debugging sql server Stored Procedure...
|
|
947
|
getting job_id from sp_start_job
|
|
946
|
SQL Code to Retrieve last week's data.
|
|
945
|
Handling Nulls in several columns
|
|
944
|
Creating a Custom Warning/Message
|
|
943
|
SQL Date Query help
|
|
942
|
Append Room numbers fields by Building
|
|
941
|
2005 backward compatibility question
|
|
940
|
Fatal Error 8520 (SQL Server 2000)
|
|
939
|
Averaging time
|
|
938
|
Problem with view
|
|
937
|
aggregate problem
|
|
936
|
URGENT - Update Query Help needed
|
|
935
|
Insert Record
|
|
934
|
Insert New Record
|
|
933
|
Migrate / Read Access data file(s) in SQL Server
|
|
932
|
Adding a select into SQL statement
|
|
931
|
"Best practice" table/query structure sought
|
|
930
|
Could not find stored procedure
|
|
929
|
expression for "anything"
|
|
928
|
openrowset or opendatasource
|
|
927
|
error executing create store procedure statement
|
|
926
|
Newbie, sending text message to mobile device and SQL Server
|
|
925
|
Error when users Increases
|
|
924
|
Removing triplets
|
|
923
|
LEFT JOIN & RIGHT JOIN
|
|
922
|
Jion with null values
|
|
921
|
Empty out all tables
|
|
920
|
Deploying sql server databases
|
|
919
|
Handling osql error within batch file
|
|
918
|
Finding the rows that do not match
|
|
917
|
Accessing AS/400 Db2 with IBM's OLE/DB driver
|
|
916
|
LOGIN Scripting
|
|
915
|
Backup database permissions problem
|
|
914
|
Percentages -- incorrect return values
|
|
913
|
IF EXISTS then Update ELSE Insert
|
|
912
|
SqlConnection
|
|
911
|
Match your Design site data schema and SQL statement to Application site
|
|
910
|
Insert multiple records in a table
|
|
909
|
Undo Update
|
|
908
|
Query Analyzer bug??
|
|
907
|
null value issue in stored procedure...
|
|
906
|
Is this possible?
|
|
905
|
FAQ System
|
|
904
|
Searching for a field in the tables
|
|
903
|
Sequence of dates in a query
|
|
902
|
Length of string
|
|
901
|
SQL sum statment
|
|
900
|
How to create SQL Server Job from script
|
|
899
|
Stored Procedure to delete duplicate records
|
|
898
|
Format Date predefined
|
|
897
|
Parameters in Stored Procedures
|
|
896
|
Complicated Insert question...
|
|
895
|
cybiz Orthogonal Design , dynamic sql alternative
|
|
894
|
cybiz Orthogonal design,dynamic sql
|
|
893
|
Stored Procedure Syntax
|
|
892
|
Outputting the number of records returned from a stored procedure
|
|
891
|
Complex Select
|
|
890
|
Complicated SELECT question
|
|
889
|
install sql 20005 to specified drive
|
|
888
|
How to save record set from a stored procedure to a view?
|
|
887
|
SQL Syntax question
|
|
886
|
sp_send_dbmail
|
|
885
|
Help with a sql statement, grouping and Count
|
|
884
|
Alternative to a cursor
|
|
883
|
Error with Microsoft.SqlServer.BatchParse r
|
|
882
|
View SQLServer Linked Server Processes
|
|
881
|
How to find and file's date and version using SQL server queries
|
|
880
|
How to check for full backup before a log backup
|
|
879
|
DTS help
|
|
878
|
Calculate Averages
|
|
877
|
Column Names
|
|
876
|
Rollback a "Force restore over existing database"
|
|
875
|
Records in table 1 but not table 2 with a composite primary key
|
|
874
|
Select all but one column
|
|
873
|
How can I use the ODP.NET at the TVF in my SQL Server 2k5?
|
|
872
|
Problem with datetime variable
|
|
871
|
SQL 2005 Express
|
|
870
|
Searching for a value in a column where you don't know the tablena
|
|
869
|
SQL Job output to file
|