Bytes > topic > sql server > answers

Pages : [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

1. The INSERT statement conflicted with the FOREIGN KEY constraint
2. How to convert rows into different columns
3. how i convert dbf file int sql file
4. Can I calculate between different datasets?
5. Query Engine Error after Forced Protocol Encryption on Crystal Report
6. How to query untyped xml data
7. TSQL query
8. role permission of tempdb due to server restart
9. Want to track the user who last modified the procedure
10. How can i convert this query into sql server whereas this is working in MS ACCESS
11. Insert table values from other table
12. sql query
13. Return all items in an order then add the shipping cost to only one item
14. Raise Error problem when connecting to SQL Server through ODBC
15. UPDATE and SELECT Combination
16. openrowset works in sql 2005 but not Works in SQL 2000
17. Use Excel modified date in Stored Procedure
18. Using a pointer to a local varaiable in Dynamic SQL
19. Unable to join 2 tables which are in 2 differenet servers
20. trick for displaying result? SQL Server 2005
21. Open SQL connection using T-SQL
22. I'm trying to run a package in integration services
23. SQL Server, how to the next value of identity(1,1) before insert
24. How to publish Stored Procedures into a database
25. sql query groups and min value
26. How to split long string function in sql server?
27. Easiest way to convert Microsoft Access SQL code to T-SQL code in SQL Server
28. problem in query
29. How to find the System Date Format?
30. How to check if a value (null/non null) exists in database table using stored pro
31. Job disappeared from Enterprise Manager
32. Error : Calling SSIS package from .Net
33. What values can a datetime data type hold other than date and time??
34. RTF file in SQL Server 2005
35. Automated Data Import from Excel
36. I want to query of getting hour from date field
37. Report Maker
38. SQL server
39. fit record in one page in SSRS
40. Sql Compact Installation
41. Sql update command question
42. passing db table values from one sql server instance to another sql server instance
43. Selecting seperate fields from file - each based on different criteria
44. DTS Task not running... wierd...
45. Connectoon timeout
46. Query Data and Column Names
47. Using aggregate fucntion to calculate standard deviation
48. identity column (int) overflow
49. SQL server 2000 - cannot telnet to port 1433
50. Using extended properties on the DB objects. What is it?
51. Problem in creating stored procedure.
52. Using Joins
53. Join or Transpose?
54. How good to use Partition table?
55. Database switching to read_only mode randomly
56. How can I restore a database remotely from a different server?
57. Adding leading zero's (padding out)
58. sqlce in Xenocode
59. Can you make a new table from query results in tsql?
60. design a single normalised table
61. How do I delete duplicates in a row?
62. Choice of a Database System
63. Table with various subfleets
64. Multi-part identifier error
65. Error converting data type varchar to numeric
66. Need a script to backup db on one server and restore that db to another server
67. How to tune this SQL
68. Why does MSSQL server allow the attached code to work
69. Converting String To Decimal
70. removing duplicate records
71. Problem with NULL values
72. Stored procedure problem
73. Australian Postcode with longitude/latitude
74. SSIS import full text from html or combine rows
75. Synchronization
76. Query
77. having trouble with joins
78. how to use replace and substring correctly.
79. Split a string where newline, carriage return
80. Select with conditions
81. replacing the 8th character in a varchar string
82. insert rows dynamically
83. Transferring data
84. Help in Insert into select from SQL
85. How to select top 1 from table1 where table2 contains a list of values to select on
86. Violation of Unique Key contraint during update
87. how to call Function
88. How to convert a char value to date?
89. Get employee with least work
90. Taking Automatic Backup Of sql server database
91. Dynamics column in SSRS 2005
92. Embed a Google Map in SSRS
93. SQL Server Import and Export Wizard steps
94. Substring in SQL server
95. Conditionals in a WHERE clause?
96. Combining Multiple Projects
97. Retrieve date now
98. SQL Server 2008 SP1 not for XP?
99. which sql download from net
100. SQL Server Compact timed out waiting for a lock
101. Quick question
102. SQL query
103. Report Builder 2.0
104. How to use where wiht variable
105. I am new to Sql and looking for some help with this error. Any advice would be apreci
106. Select DISTINCT (This part of the query only)
107. I have deleted the .MDF file accidently. I have never created a backup early on.
108. Multiple results from a Case statement in a Where clause
109. merging rows for the same time stamp
110. Where is error-I need exec in function - result is without error,but not return data
111. Conditional Having Statement
112. ISNULL With date..
113. Can I edit report content in print preview?
114. Condition check for If table exist
115. converting access 2007 update query to sql server 2005 update query
116. Insert and Select statements for same table in begin trans and end trans
117. Extracting documents from SQL database
118. Help converting .xml feed to SQL
119. sql create tables
120. Quick questions About SQL Server 2000
121. Best way to index a mostly static database
122. How Access reads data stored in SQL Server
123. How to run a scheduled AutoExec Macro that requires an ODBC password
124. select addresses with distinct email address
125. Can any of you SQL Guys help us olde Access boys out with this Thread?
126. The LIMITations of ms-sql. Equivalent to MySql's LIMIT
127. How to join update statement with select?
128. How to decide optimum type
129. Count group by query
130. Multiple select
131. Problem with MID() function
132. Working with Multiple CASE WHEN Comments
133. Find empty fields
134. Bulk Load Copy - nvarchar is not recognized
135. Trouble converting Access query to SQL Server
136. Need guidelines - Query Optimization
137. How can I detect changes in a row of some table?
138. two questions: 1) Joins 2) Selects
139. error "Could not open a connection to SQL Server"
140. MSSQL "A network-related or instance-specific error" and IIS application pool
141. Create Function
142. problem with installing mssql - dot net framework
143. Attempting to do an update in SQL Server 2005 with query originally created in Access
144. running web application in MSSQL on server with MySQL; 4CRM SQL & EMS MSSQL Manager L
145. converting queries from access 07 to sql server 05
146. Multi-table JOIN issue
147. How to insert Unicode data into table when pulling data from another table
148. how to divide one column to two columns
149. Create Function
150. using union, temp columns, in a SQL based search string
151. How i know if a report has Data in Reporting Services 2005?
152. Am i able to insert into a table data from a temp table?
153. Can I use LIKE with IN?
154. How to update one sql table from another table
155. Converting Text to Decimal
156. If exists table using dynamic sql
157. Need help urgently, have to compare dates between 2 rows in one table
158. retrieve a last value from sql
159. Use sub reports in the header of a report in SSRS
160. Cannot specify an index or locking hint for a remote data source
161. How do you change the default encoding on SQL server?
162. SQL Query
163. Transpose into fixed column
164. Transpose into fixed column
165. Multiple SQL servers in same query
166. Cannot Reindex.
167. Computed Binary Field
168. Using parametrized "IN"
169. question about cursor
170. Nth location of string
171. Remote server Problem in Sql server 2005
172. Configuring Error Messages in SSRS
173. make one table from merging two
174. Dynamic SQL in an INSTEAD OF trigger causes recursion
175. Dynamic user security in Reporting Services
176. Questions about Foreign Keys
177. substitute for 'PRINT' in server
178. Combining Rows into 1 Column, and joined with another table
179. scope_identity not working
180. Filename Increments
181. The INSERT statement conflicted with the FOREIGN KEY constraint
182. sql AS function not working
183. sql deletion with delimiters
184. sql statement writing
185. How to build a query based on four tables
186. Concatenating Row Values into 1 Record/String
187. Parameter query problem
188. SELECT yesterdays records
189. Issue when reading data from excel sheet
190. Using an alises in the WHERE clause
191. problem with writing arabic into database from out
192. Current day
193. retrieve n number of rows from table
194. insert into - add multiple values in a column
195. How do i phrase this simple query
196. How to handle high-volume inserts?
197. Multiple Functions
198. Complicated Query by date
199. no access to new instance of sql server
200. Importing .txt to SQL 2000
201. calling a pl sql procedure in Reporting Services
202. SQL Query - Eliminating Duplicates
203. Scheduled DTS Problem
204. Distinct Count - SSAS
205. SQL Server 2000 XML Element Order
206. SSAS 2005 help
207. Syntax error converting datetime fom character string
208. Autonumber not updating fast enough
209. Connecting through .adp file (not working on Vista/SQL Server 2008)
210. How to compate two versions of the same database
211. Set based solution instead of Cursor
212. Find Credit Card numbers in text field
213. Question using SP_ADDLINKEDSERVER
214. Query with Counts Help...
215. Select every 79th record
216. Database Locking
217. Return records 5 thru 10
218. remove duplicated fields depending on time
219. Inserting concatenated data with while construct
220. Extract Numeric Data from text field
221. Trying to get a case statement to work correctly
222. Connect to DB2 server from SQL Server 2005
223. Sql insert cursor
224. Display flag if record exists in table
225. Quary Confusion
226. While loop with dynamic sql
227. Linking from Access
228. sql server compact edition 3.5
229. Database normalization question
230. Search a row by Primary Key
231. generate & compare id from table in sql storeprocedure
232. get tables
233. Views in SQL server
234. list of countries and their states
235. How to Create an XML in MS SQL Server 2000
236. Two instances on one machine
237. need your help please
238. SQL Error: Cannot resolve the collation conflict between "SQL_Latin1_General_
239. Using SET statement in stored proc.
240. Calling a UserDefined Function
241. MSSQL Datetime snafu
242. General Network Error- works if exe name is changed
243. Using Single Quotes in a dynamic SQL
244. Best way to send email from SQL
245. simple question about date compare
246. Move MDF From 2005 Back To 2000
247. Trigger Before Insert or Update
248. Problem inserting ' and ; in DB
249. Problem with nestd query
250. Need help with join - it's returning duplicate rows
251. How can we generate a Script with all user permissions of all users in a particular d
252. determining if an SQL database exists, etc.
253. When to use trigger, constraint and when one cant
254. SQL Query
255. Help with Query To combine results from two Columns
256. Problem with query
257. problem in Updating database in windows application
258. SP that updates a table according to optional parameters?
259. problem with joins and aggregate functions
260. Exporting data with Stored Procedures
261. where's the dgDetails class?
262. Stored Procedure Error
263. proper Save location for SQL stored procedures
264. one-to-many relationships
265. Getting a count on one table using data from another table.
266. how to “store” stored procedures
267. Getting the count from two tables as rows not columns.
268. SQL Query becomes too much
269. learning sql server
270. Pivots
271. dataAdapter.Update / SQL PasswordHash NULL problem
272. PasswordHash NULL problem
273. query to store null
274. How do I get PasswordHash value?
275. displaying an auto-incremented identity column
276. GetDate() with time-ignore
277. Multi Table Query With Max Per Grouping
278. datatype smalldatetime now requrement is there to store nil
279. SQL / Access (Average Code)
280. Only One Record
281. why deadlock in this SPROC
282. mapping error
283. SQL Server Users and Roles
284. System DB not able to restore
285. auto-increment identity column
286. How can I make SQLServer known to DB2 control center so that I can Federate?
287. Need help with a query - may be easy for you but not me
288. INSERT IGNORE duplicates
289. Is a solution possible/viable?
290. dataAdapter.Update problem
291. Last Sales Price
292. DataBase Size/space Query
293. sql parmeter problem
294. mssql
295. SQL Server 2005 - Open SQL file with Query Analyzer behavior
296. Loop through all databases
297. Sql server 2005
298. sql network
299. collating records from different SQL Server tables
300. Recursive stored procedure
301. SQL Server connection problem
302. How to uninstall AdventureWorks sample databases?
303. ELSE IF statements
304. ELSE IF statements
305. database security
306. Help me with SQL
307. How to import ".mdb" files into SQL Server 2008?
308. Can SQL Server 2008 access Northwind or Pubs databases?
309. Access add record command button not working with SQL backend
310. Optional Parameter in a SQL Function -- selecting all
311. binary data in char field
312. What will happen in such case to the table
313. Calculating the Weekend Days(Saturaday,Sunday)
314. AdventureWorks mayhem
315. server database
316. SSRS report parameters are not wroking properly
317. PHP SQL Server 2005 suddenly down
318. how to make SQL commands more dynamic?
319. Problem with SQL query newbie
320. Pub sample database
321. Default file group
322. set password
323. Data Manipulation
324. select statement
325. Two or more select statements in a single query
326. I can’t install SQL Server 2008 Express with Advanced Services - Help!
327. SQL Query with some problems
328. createing database problem
329. how to obtain SQL Server FullText Search service?
330. SQL2008.AdventureWorks install problem
331. Any other SQL or MS Access / OleDb databases available?
332. COUNT Duplicates using partial string
333. dataset
334. parent row
335. LIKE Condition while using parameters
336. Creating Custom data sets in reporting services
337. How do I create custom Datasets in SSRS?
338. Normalization
339. How to solve memory leak in SQL 2000
340. Find remaining balance - not a simple SUM()
341. Custom WordBreaker for SQL Server Full-text
342. Curser in SQL(for coonectiong to deifferent servers)
343. Very weird bug with 'like' function
344. Sql query to select Date between the range
345. Recover SQL 2000 database restored over in error without backup
346. Copy table to table, how?
347. Covert Data in .DBF files to MS Sql
348. conversion from varchar
349. No error Description
350. Condition as part of FROM statement???
351. Subtracting sequentially from multiple sources
352. Cursors
353. local html webform page to local sql 2005 database possible?
354. Intelectual property protection
355. Getting unmapped records with mapping table query
356. Subtracting from lowest value
357. pivot
358. Duplicate Entries
359. How toRetrive XMLdata into database Table
360. Fixed Width File Spec for SQL Server
361. per seat , per server , per processor
362. columns operation
363. sql connection
364. saving userlogon time
365. Can somebody please kill my cursor
366. Update rows in
367. How to eliminate selecting repeats in a statement
368. Does SQL Server 2000 support foreign key in partitioning?
369. how to create backup in sql 6.0 using sql command
370. How to handle NULL parameters,EMPTY parameters and ERROR HANDLING in stored procedure
371. creating a table
372. How to migrate mysql stored procedures to sql server manually?
373. Single stored procedure for multiple databases?
374. Registration Form
375. HELP ME Understanding the concept of Foreign
376. Sql server date question {C#}
377. Variable locking up query ??
378. insert new columes
379. Migrating DTS Packages from SQL server 2000 to SQL server 2005
380. problems when trying to use the import wizard on mssql2005
381. Regarding stored procedure help me
382. Look at every *Third Tuesday* of the month on record ...?
383. query that filters out those schoolcode
384. Single table condition in join or where
385. SQL query related to Date.
386. Single Trigger for "SELECT" execution happens irrespective of any table.
387. Data Conversion in ssis
388. using a trigger to get values from one table into another
389. Restore Database error in SqlServer
390. trigger error
391. Constraint on existing table, multiple columns
392. How to recover database from MDF?
393. BULK INSERT row terminator issue
394. Convert mssql to mysql
395. SQL server does not exits....
396. how to put the sql-logfiles online?
397. how to find whether particular value is present in database
398. Need Help - Multiple Column in Group By clause with Data Type Error
399. query to search even when user skips in between text
400. CASE statement in subquery
401. Multiple SUMS SQL Query
402. Select/Insert/Update a column with out a header
403. SQL Stored Procedure Insert List of variables
404. speed uo to read rset from SQL Express
405. executing block of code whenever a condition is satisfied
406. fetch multiple columns value in stored Procedure
407. Concat date and time in stored procedure
408. Output of SP1 stored procedure in #Temp TABLE OF SP2.
409. Export table to CSV
410. database exist or not
411. Help on Error:Only one expression can be specified in the select list when the subque
412. Mutiple Table from Stored procedure
413. How can sole that
414. cross tabulation
415. Issue with query results
416. put rows together and group by another column
417. Protecting .net dll's in Sql Server
418. Split Function in Sql stored procedure
419. Error using built in function SwitchOffset
420. When to recreate index?
421. export my sql server database to msaccess - Validating (Error)
422. BULK INSERT not inserting string with 'D'
423. cross tables
424. Composite Keys & References
425. dates: Comparing just the date parts of datetimes
426. [SQLServer] Violation of UNIQUE KEY constraint
427. SQL setup failed with the error "LoadLibrary failed on sqlsrs.rll"
428. How work with html-table included in ntext-field
429. How to find X consecutive (integer) values in a table column
430. Where do I place a stored procedure?
431. Not getting require result from Store Procedure
432. Return string in query
433. SQL Server Formula
434. Avoide DeadLock Condition
435. Select through multiple iterations
436. Passing Time Value To Stored Proc in through Input Parameters property of Form. ADP
437. Selecting the top 1 record from a related table
438. Error message: Cannot open database requested in login 'teachdb'. Login fails.
439. Validating Multiple Records in Same Table
440. Performance impact using N prefix while inserting the unicode data
441. if else in select Statement
442. Reporting Services Speed Issue
443. recordCount incorrect for Distinct Clause in Quer
444. function help
445. how can i do that
446. How do i insert unicode text into varchar column?
447. How can you find the dependencies of a table accross databases?
448. whats wrong with my insert statement
449. insert html web page/form to sql database
450. How to find consecutive records in database
451. Top 3 Rows by Group
452. what's the wrong with this stored procedure
453. IF THEN statement in WHERE clause???
454. Reading/Updating/Inserting the Unicode data using sql server 2005
455. MSSQL Error stumping me
456. Find in Set for MSSQL?
457. SSRS, textbox multiple formatting
458. Question on a 'Hits' column in User Table
459. SSIS Union all difficulty
460. database backup issue
461. Inserting data to xml column
462. How to get the production downtime I need from "ALARM Database"?
463. Represent Data Table
464. How can I restore only 1 file out of 10 file?\
465. Simple question about configuration
466. Simulate Cursor with recursive join
467. count between duration
468. hardware requirement
469. Round entire column
470. Date max
471. MSSQL Query Extracting Dates in Filename
472. MS SQL 8, track changes?
473. How to "Include" another T-SQL Script
474. Subquery in UPDATE statement
475. Update Triggers to update another table in the DB
476. Compare dates
477. How to copy a table (with the data) from one server to another?
478. Execution
479. Find Day from datetime
480. Storing results in different files.
481. Syntax on View/Cross tab join
482. System.management Not Found
483. Calculate median value?
484. How to implement LIKE Clause in Query?
485. import text file in sql 2005
486. export table defination
487. sequence in MS SQL
488. Subtract values in a field from a number?
489. How to return total number of records form union of two tables
490. find out the error 'missing right parenthesis' in following code
491. Install SQL server 2005
492. Moving Data from right to left SQL
493. Foreign Key Type for "uniqueidentifier"
494. grab data from 1 column into different column
495. Storing a series of numbers of variable length
496. Duplicate records
497. insert/update data in foxpro table field having datatype MEMO using linked server
498. MSG 4145 Error
499. The "alter table" statement conflicted with Foreign key consrtaint
500. setting isolation level read uncommited
501. How to transfer data between Access to SQL 2005
502. Comma
503. SQL Server passing a list of integers to a stored procedure
504. Left join
505. Coke Can Phone
506. Display data from more than 1 table without using join?
507. Need help with intersect and subselect
508. Sql database from local system to Web hosting server
509. MSSQL Query Analyzer
510. Write conflict on SQL 2000 ODBC linked table
511. Connecting SQL Server 2005 to Netezza
512. Setting a variable based on a match - Then inserting into a temp table - SQL 2000
513. XMl Column field
514. returning a single value based on 2 or more records
515. Filtering different conditions in the same field
516. Executing a job using TSQL or Stored procedure on SQL 2005 Express
517. how to convert varchar to int
518. Please help! I'm stuck!
519. Specifying Columns in a Bulk Insert
520. Comparing multiple fields in a table
521. Subquery with count problem
522. Select records using like statement
523. u just click u get some dollars
524. Re: Queries Occasionally Slowing Down
525. SQL server name mismatch
526. stored procedure loop #temp_table
527. How to store a formula in sqlserver ?
528. how can we convert prepare satament of mysql into mssql
529. Date Conversion Problem From varchar to Datetime
530. Get Distinct rows from multiple columns
531. database size vs. its performance
532. SQL2000:Moving whole server(10 Dbs+100 login+100+Jobs) into Brand New Server
533. Re: Clustered Indexes, what actually happens when you rebuild one, does the optimiser love them?
534. SQL Server - Error when using % in subquery
535. Item table Trigger, for sending an email
536. Difference between rows in a table
537. Database backup using Scheduled Tasks
538. Fetching data from two tables
539. Date format
540. Speed Q: Storing Large Graphs in DB - Inserting Several Million Rows - Research Proj.
541. To print only the file name
542. Need help installing MySql server on Suse 11.
543. Is there a way to split the contents of a string?
544. Performance Issues in SQL Server
545. SqlDataReader on Sql 2005
546. Bulk Insert with LINQ to SQL
547. LINQ to SQL with bulk insert
548. SP timing out, can't find the cause
549. select distinct * --- possible??
550. Getting images out of SQL