TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
SQL Server Programming Archive
‹
Page 35
Archive
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
view full version:
back to formated view
11901:
Re: Calculating Compounded Return
11902:
Re: Calculating Compounded Return
11903:
Re: Calculating Compounded Return
11904:
Re: Calculating Compounded Return
11905:
current week
11906:
Max Memory
11907:
Memory
11908:
array of values in a single row
11909:
supply user
11910:
stored procedure locking
11911:
Alternative to sp_OACreate
11912:
how to simulate an array of values in a text box thru SQL
11913:
xcopy from xp_cmdshell
11914:
store procedure
11915:
Question about execution plan
11916:
SQL Server 2005
11917:
Re: Calculating Compounded Return
11918:
Non Null Value
11919:
Joining two tables with fields that have the same names
11920:
Why are there sooo many double posts happening????
11921:
SUBSTRING in User Defined Function - Invalid column
11922:
Re: Case statement not working in View
11923:
Re: Calculating Compounded Return
11924:
Re: IF-ELSE statement
11925:
Re: IF-ELSE statement
11926:
HOW TO QUERY
11927:
Re: Case statement not working in View
11928:
INSTEAD OF TRIGGER NOT WORKING
11929:
Re: Case statement not working in View
11930:
Re: Case statement not working in View
11931:
Re: IF-ELSE statement
11932:
Re: IF-ELSE statement
11933:
Re: IF-ELSE statement
11934:
Re: IF-ELSE statement
11935:
Re: IF-ELSE statement
11936:
Re: IF-ELSE statement
11937:
IF-ELSE statement
11938:
Case statement not working in View
11939:
Re: Launch BOL with a keyword?
11940:
i got some error in ssis package when i was execute one package
11941:
Re: 2 different update statements, big time difference, why?
11942:
typo in BOL
11943:
Launch BOL with a keyword?
11944:
Re: Edit a SQL Server 2005 XML column in ASP.NET
11945:
Re: Edit a SQL Server 2005 XML column in ASP.NET
11946:
Re: Edit a SQL Server 2005 XML column in ASP.NET
11947:
2 different update statements, big time difference, why?
11948:
Edit a SQL Server 2005 XML column in ASP.NET
11949:
statistics_norecompute in index
11950:
sql server print buffer
11951:
Can you get feedback to VB.NET in long stored procedures?
11952:
Become MCSD Certified
11953:
Re: Group by
11954:
Re: Query optimization
11955:
Re: Performance Issue : recompile
11956:
Re: Performance Issue : recompile
11957:
Re: Performance Issue : recompile
11958:
Re: Performance Issue : recompile
11959:
Calculating Compounded Return
11960:
Performance Issue : recompile
11961:
Query optimization
11962:
Group by
11963:
Transaction logs not getting removed
11964:
Lock all tables in a transaction
11965:
Re: Converting Non-ANSI joins to ANSI joins
11966:
Re: Converting Non-ANSI joins to ANSI joins
11967:
Re: Converting Non-ANSI joins to ANSI joins
11968:
How to "lock" a row of data from being accessed
11969:
Converting Non-ANSI joins to ANSI joins
11970:
Re: Syntax error
11971:
Syntax error
11972:
database diagrams
11973:
taking datafile online - HELP!
11974:
i cant see the thread
11975:
SS2k5: why can't I script mutiple tables from diagrams any more ?
11976:
Collection of All SQL Commands
11977:
Help formatting first name field on report
11978:
Replace with regular expression in sql server 2000.
11979:
Re: text datatype in new SQL Server (test with Temp table)
11980:
Query For Report Help
11981:
error with linked server from sql server 2005 to 2003
11982:
Synchronizing Tables from 2 Servers
11983:
Simple Question About BLOBs
11984:
Deadlocking in Common Scenario?
11985:
Export data from SQL 2005 to Access
11986:
Worng identities being returned: not trigger related
11987:
Worng identities being returned: not trigger related
11988:
Worng identities being returned: not trigger related
11989:
Wrong identities being returned occasionally: not trigger related
11990:
how to display different values in a single row
11991:
Changing passwords
11992:
Error with Protected excel file
11993:
parsing string into sequence of numbers and letters?
11994:
timestamp and getdate()
11995:
Conversion failed when converting the varchar value.. to data type int.
11996:
Replace with regular expression in sql server 2000.
11997:
Help on : Querry between 2 database ??
11998:
Timeout though using NOLOCK
11999:
Migrating to 2K5
12000:
Temp table and OPENROWSET problem
12001:
OPENROWSET
12002:
Checkpoints and locks in SS 2005
12003:
2 simple syntax questions
12004:
Loop through results in SP
12005:
insert
12006:
Date Format
12007:
sp and views Passing Parameters
12008:
Selecting previous weeks data in query
12009:
Integrity constraints check
12010:
String Manupulation with SQL Help Needed!
12011:
says variable is not declared but it is
12012:
Purge Process needed
12013:
One more SQL script help!
12014:
date format in m/d/yyyy
12015:
text datatype in new SQL Server
12016:
SQL Table with Integer Columns - Convert NULL values to 0 (zeroes )
12017:
recursive table function
12018:
Problem with linked server
12019:
RETURN within a transaction
12020:
Calling SP from select
12021:
ISNULL and WHERE
12022:
Free web based bug tracking and timesheet
12023:
Audit Trail - Trigger vs. SP
12024:
moving millions of records from one table to another
12025:
Query Analyzer connect to Postgresql in SQL 2000?
12026:
comparing strings?
12027:
Changing sa Password in 2005
12028:
SS2K5: no longer possible to open a table directly from a diagram?
12029:
While loop VS Cursor
12030:
Log File
12031:
Understanding connections
12032:
Identify Redundant Indexes (Indexes with poor value selectivity)
12033:
Bulk insert, skip rows with duplicate key error?
12034:
How to read/write chunked to varbinary(max) in C#?
12035:
Using EXEC within a SELECT statement
12036:
Total-To-Date Calculated Member?
12037:
error at the time of attaching the DB
12038:
Rebuild Master
12039:
Script Help Required
12040:
smalldatetime
12041:
Management Studio forgets password ("change connection")
12042:
Windows Process Hanging in WinApp
12043:
Query
12044:
Best approach
12045:
Top 5 Grouped
12046:
Moving 200 database from a disk to another
12047:
casting an integer as varchar
12048:
query?
12049:
COUNT
12050:
OPENDATASOURCE does not Support XML in Distributed Queries
12051:
Dynamic Insert Statement error
12052:
problem with built-in string function in SQL Server 2005
12053:
Is there an easy way to use sql server dates with oracle format ?
12054:
Column description
12055:
updating a temp table with a value in an inner join
12056:
Problem with uniqueidentifier!
12057:
Possible Corruption?
12058:
AdoMd.Net 9.0 and AS2000
12059:
Service Broker
12060:
insert skip/default if "Conversion failed when converting the varchar value to data type int." error
12061:
How to create additional SQL script to "add-on" to an existing one
12062:
simple compare
12063:
bulk insert over file share? could not be opened. Operating system error code 5(Access is denied.).
12064:
Cannot design query.
12065:
Dynamic Query Syntax
12066:
SQL2000 Encrypted problem
12067:
SQLDMO Transfer - no data copied
12068:
Problem after detach on one machine and attach on another
12069:
DateDiff() for years
12070:
bulk insert fixed width file ?? The column is too long in the data file for row
12071:
bulk insert skip header and trailer records
12072:
Delete Global Temp variable (##Temp)
12073:
find actual temptable name specific to @@spid?
12074:
Omit 0-values from join
12075:
SQL 2000 FK On Delete Set Null?
12076:
make NULL values = 0
12077:
Microsoft OLEDB Provider for DB2
12078:
Append/Update to table when view created
12079:
Service Account Lockout
12080:
Microsoft SQL Server DBA's required immediately in Toronto
12081:
Tough problem: can this be done using parameterized stored procedures?
12082:
removing duplicate rows - keeping the highest value row
12083:
ALTER TABLE weird behaviour
12084:
String Manipulation in 2005
12085:
bulk insert rowterminator unix files - An unexpected end of file was encountered
12086:
bulkinsert and creating columns on the fly?
12087:
xp_sendmail with non-recognized recipient
12088:
A question related to stored procedure
12089:
New to SQL, where to start?
12090:
Totals
12091:
Would you like to have access video tutorials totally free?
12092:
Checking for an Error
12093:
Question on SQL Server SQL
12094:
SMO: running a stored procedure in C#
12095:
Tricky TSQL question
12096:
SQL Query Help
12097:
Search for text in a database
12098:
index error? selet statement return nothing
12099:
How to select every "n"th row
12100:
Trying to make counts per period
12101:
Zwei Cursurs zeitgleich verwenden
12102:
Check if all row value are in a list
12103:
finding job history
12104:
Trigger execution plan takes up to 10 seconds to compile
12105:
Convert String to rows in sql 2000
12106:
help with db schema design
12107:
Deadlock error in sql server
12108:
Your secret dreams
12109:
Using TransferData
12110:
error on alter login
12111:
^*^*^ Britneys BACK AND TITS!!! GALORE! !^-
12112:
Line Number Item
12113:
Cursor Question
12114:
temp table strategy
12115:
Help importing large csv file into SQL
12116:
simple Query to retrieve data from a linked table
12117:
inlining function call on a exec sproc
12118:
Temp Table
12119:
Import vb.Net xml file to sql server 2000?
12120:
please comfirm I am right/wrong on #TempTable
12121:
Help needed handling single quotes
12122:
Generate insert scripts from existing data
12123:
How Should Records Be Inserted?
12124:
Are cross-collation queries possible
12125:
Indexes (Field1 & Field1 + Field2)
12126:
Metadata for table variable?
12127:
What is wrong with this query?
12128:
SqlDependency OnChange only works for 2 minutes
12129:
Large repeated inserts and datalayers.
12130:
Parse Field into Multiple Records TSQL
12131:
xp_fileexist with wild card does not return true
12132:
Validate if first char in string is numeric
12133:
Speed SQL
12134:
Error 5701 and 5703
12135:
Alternatives to TIMESTAMP.
12136:
Ok to use LEFT OUTER JOIN even when FK will not be null?
12137:
Need help on table structure ???
12138:
SQL server not starting
12139:
Visualize and Navigate DB Schema
12140:
Identical Systems Returning Different Sorted Order
12141:
Query Analyzer Returns Rows in Different Order
12142:
Optimalization
12143:
SSRS 2005 - user rights
12144:
SPSS with SQL Server
12145:
Should I use dynamic SQL to combine 2 procs into 1?
12146:
Interesting problem with order by
12147:
Update set increment value
12148:
sql 2005
12149:
max errors in DTS
12150:
View of table and column names in a DB using 2005
12151:
Select one or all in the same proc?
12152:
Keeping databases in sync...
12153:
Help needed (About SQL Server Topics)
12154:
hi hi hi
12155:
Why do I get different results using these two approaches
12156:
Find First AlphNumeric Char in a Field value
12157:
Changing data type on a column
12158:
WITH [Table] versus temp table
12159:
Return Field Name as data
12160:
select rows from specific groups problem?
12161:
3 views becoming unweildy
12162:
How to select column values with percentage mark %?
12163:
Updating non-ASCII characters with '' in a string
12164:
Best Fit
12165:
Is a Conditional Join Possible?
12166:
Finding a number in a string
12167:
Hi Friends, JOB ID: SB 0501 >>> Urgent req for SQL/.NET
12168:
Complex counting, summing and grouping
12169:
stored procedures scripting
12170:
Delete Remote Files With FTP
12171:
Weekly Totals
12172:
Help with SELECT FROM DAY(CURRENT_TIMESTAMP)
12173:
Problem with JOIN
12174:
datepart question
12175:
Somebody used Keyword OBJECT_ID as a column name...
12176:
Obtaining Stored Proc and Trigger text
12177:
Failed BCP Process in SQL Server 2005
12178:
History for 1 extract table.
12179:
Query Help
12180:
concatenation
12181:
Stored procedure assist
12182:
SQL Query Notifications stopped working
12183:
Calculated Balance Value
12184:
How to select the latest timestamped record?
12185:
rewrite NOT EXISTS to LEFT OUTER JOIN
12186:
Need help setting up Backup Maint Task
12187:
osql and file sizes
12188:
SQL Server Solutions BLOG
12189:
XML Problem
12190:
How to Fix Error 207 in SQL SERVER 2000 with out using Service Pack SP4.
12191:
Stored procedure evaluating a query passed as param
12192:
Index on View with Count
12193:
~!~ Britneys New BOOB job fails Silcone Valley everywhere!!
12194:
How to count number of commas.
12195:
File Access Denied
12196:
^? Britney Gets Boob Job ******
12197:
How do you inner join two tables were one is based on the others top 1 id?
12198:
Create Procedure question
12199:
SQL Server 2k Query How to display seconds in time format
12200:
How to create a job to poll my table
12201:
Handling Errors of SQL Server in C++
12202:
Best Identifier for a LOT of data
12203:
one-many select clause
12204:
2005: "The updated row has cahnged or been deleted since data was last retrieved"
12205:
Update Query
12206:
VSS for SQL2000 / 2005
12207:
Rolllup option on OleDbDataAdapter
12208:
Replace value in a field based on a set criteria?
12209:
Replace value in a field based on a set criteria?
12210:
Big problem with case sensitivity
12211:
Log shipping error
12212:
some questions abount sql server
12213:
xp_sendmail problems
12214:
Query Syntax (SQL2000)
12215:
FTP Connection Manager
12216:
Table valued paging function
12217:
Which Database is sql script run in?
12218:
Select sum
12219:
Add Column - table has 29+million rows...
12220:
Primary Key being incremented by 1
12221:
Tranlog space usage
12222:
select query
12223:
System.Data.SqlClient.SqlException: This statement has attempted to access data whose access is restricted by the assembly.
12224:
using SS2K as a files repository
12225:
Time datatype on SQL2005
12226:
QUERY HELP!
12227:
Column Headings
12228:
Getting results for 2nd row of the group.
12229:
len() returning weird result
12230:
Dynamically changing database context ('USE [@dbnname]') from query analyzer
12231:
Help on trigger
12232:
Mel Gibson Spanking!
12233:
How to delete a block of rows?
12234:
Invalid column name
12235:
Invalid Column Name
12236:
Programmatically find out the INCLUDE columns on an index
12237:
openrowset and opendatasource issue
12238:
How to copy objects with SSIS
12239:
Date Query Problem
12240:
Error: String or binary data would be truncated.
12241:
Urgent! Create Login Windows Authentication
12242:
Problem with comparing casted fields
12243:
Appending values in multiple columns
12244:
Query Guru's Please
12245:
What is wrong with this stored procedure?
12246:
Advanced Query Help
12247:
Execute SQL Statement
12248:
Referencing a table that is not available in a Stored Procedure
12249:
=// Homeland Security on High Alert
12250:
Out of stack space error