View Full Version : 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 35 36 37

  1. bcp right truncation: how to ignore
  2. 2000 vs 2005 -- AnsiNullsStatus
  3. Sql Server Performance
  4. Full text index on a view
  5. Performance
  6. query...
  7. query...
  8. change of value at the time of insertion
  9. Querying a column with brackets in its name
  10. Compare given period in current year / previous year
  11. Data Warehouse Nulls
  12. Selecting records by date - need a little help
  13. Getting previous values of a field
  14. Not grasping outer joins for ms-sqlserver :: 3 tables to join
  15. Finding the natural key
  16. Browser Time Out: when executing a DTS package
  17. Error in Query
  18. Communication betwee two tables
  19. DB_E_ERRORSINCOMMAND ( HRESULT = -2147217900 )
  20. Communication betwee two tables
  21. connection ms sql server client to winserver2003 with limited id
  22. One of two subscribers not in sync - Replication
  23. Trouble connecting to remote db using the .NET data provider for Sql Server
  24. views dependent on other views
  25. Cascade update
  26. Plz Help!!
  27. Greatest value
  28. SQL Server 2005 vs Ascential
  29. General Question about doing calculations in SQL
  30. Identifying "filler"
  31. Timeout expired
  32. 2005 Database Mirroring & Witness
  33. convert a datatype
  34. Error (8626) while inserting record into table with text field and which is the base for indexed view
  35. Integrated Services
  36. Values of two columns in two different tables--presentation using select
  37. Problems with SQL 2000 and 2005 on same machine - Can't connect on 2000
  38. Naming syntax in 2005
  39. looking to collect distinct date part out of datetime field
  40. Identifying Duplicates in a table
  41. Pipe delimiter problem
  42. Syntax of updating table variables?
  43. User-defined function and temporary tables
  44. Linked Server via ODBC and stored procedure
  45. SQL Server Scanning Tables
  46. Too Many SET Options
  47. freeTDS ODBC
  48. Transactional Replication with Immediate updation DBNETLIB problem.
  49. dbcc shrinkfile - SQL Server 2000 - invalidate log?
  50. powerfull Oracle specifications PC
  51. Oracle Application and laptops
  52. can i increment the column (c1+2) ---by creating the trigger
  53. Different query plans for view and view definition statement
  54. how to install 64-bit version?
  55. Help optmizing a stored proc
  56. Memory limitations, 2005 Standard
  57. SQLInjection with OpenXML
  58. Problem connecting AS400/DB2 with SSIS
  59. sql query in vb
  60. Execution Plan Hinting
  61. Getting list of recently added IDENTITY items
  62. Possibly simple query but I'm not good enough to fathom it!
  63. Query assistance
  64. Speed up Bulk Update
  65. bcp with format file
  66. need help to take the variables associated with the 1st occurrence of a date variable
  67. Query Brain Teaser - Revenue Projections
  68. Can't fit results of tsql query in excel
  69. Cursor????
  70. Divide by Zero
  71. PK
  72. Unable to access perfmon counters remotely
  73. Sybase tool to manage database
  74. how to write one stored procedure for a (same column )present in 20 tables
  75. MSDE 2000 changing disablenetworkprotocols after installation
  76. Appending tables
  77. Convert VARCHAR into Money Value
  78. Changing Machine Names MSDE
  79. sum with increment
  80. Can a stored procedure parameter be optional
  81. Changing subnets help?
  82. beginner: "Login failed for user 'sa'."
  83. How can I do amalgamate 3 select queries and then get unique entries from the result
  84. Stored Procedure
  85. inserted the image in a column----how can i view the image
  86. Special characters in MSSQL.
  87. How does databse driver manager know the application is "Unicode aware" ?
  88. slecting multiple distinct columns..
  89. itzik ben-gan
  90. troubleshooting data updates
  91. Does anyone know what the "Option value changed" error message is?
  92. Fast look up of long (n)varchar
  93. Out of range datetime value error when inserting using select...union
  94. How to check if DB Constraints are enabled in a database?
  95. Problem with database filegroup restructuring in SQL Server?
  96. Help with Query
  97. SQL Server: beginner: "Login failed for user 'sa'."
  98. Space Available Within A Filegroup
  99. Statistics IO logical reads sometimes 15 million and other times down to 90 thousand?
  100. Query Memory?
  101. Referential Integrity - linking multiple tables to transaction table
  102. How can I remove duplicate entries in a sql query?
  103. Preventing SQL Injection attacks
  104. MSSQL Query Memory when using long fields
  105. Problem with variable of type money?
  106. Replicate between to MSSQL 2000 Servers
  107. Logshipping Corruption Problem
  108. how to import image jpeg file to table in oracle
  109. Select row with only ONE occurence
  110. Convert Sting to Date
  111. comma deliminited coloumn
  112. Can I do this in SQL Analyzer or with a dts package?
  113. How does one set read-uncommitted on the entire DB?
  114. Use MS SQL Server 2005 Developer version to open MDF file?
  115. more date problems...
  116. http://sqlserver.startpagina.nl/
  117. Executing a Views from a Trigger
  118. Cannot connect to a new installed SQL Server 2000
  119. SQL cache so GREEDY?
  120. Insert first n columns from select
  121. getting the matching columns from two tables
  122. Stored procedure returns no value
  123. Difference Between NULL and Blank in SQL
  124. Checking for existing column
  125. Optimizing a JOIN
  126. How to have strings automatically truncated?
  127. Reasonable to assemble FullName W/ A UDF
  128. restore sql 7db to sql2000
  129. Group By Query Help
  130. Converting Traceid issue
  131. How to avoid cursors
  132. Create New Table advice
  133. page life expectancy=0
  134. Urgent opening for dwh informatica
  135. sql server efficient
  136. LDAP interface to SQL Server 2000
  137. Installer differences - SQL2K under W2K versys W2K3
  138. Error using UPDATE statement
  139. sqlservr.exe memory usage
  140. Script SQL 2005 database to individual files?
  141. Send 2 SQL statements using Integrated services
  142. Automating record selection parameters
  143. Query Analyzer and Profiler won't start from EM Tools menu
  144. Simple SQL Distinct...!?
  145. Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over Dialup Connection.
  146. workgroup information file does not exist
  147. workgroup information file does not exist
  148. tools for analysis relations
  149. Announcing Yellowfin BI reporting Version 2.4 release now available.
  150. International Settings for SQL 2000
  151. advice
  152. MS SQL export / import data
  153. DELETE FROM - Somethings not right
  154. unknown column 'state' in field list
  155. Detroit SQL Server User Group.
  156. Question about Joining 2 tables??
  157. Fields in my tables are disappearing!
  158. Subquery -> slowness
  159. <ANNOUNCE>Building XML Workflow Applications
  160. log/log10 functions truncate my resultset
  161. median query without using function
  162. scheduled dts suspends...
  163. Webserver request invalid query
  164. Linked Server SQL to SQL
  165. linked data bases
  166. long SQL lines for osql
  167. copy a table
  168. How to create SELECT?
  169. Script needed to edit open objects in Sybase
  170. SQL command needed to edit table data
  171. Joing Multiple Columns
  172. Virtual Servers cannot connect to host PC Database
  173. Tricky SQL question
  174. Setting a value for a boolean
  175. export SQLServer2000 DB to Access
  176. UPDATE Statement Involving Tables in Different Databases
  177. select statement returns null in stored proc
  178. Backup users
  179. how to call a stored procedure in an insert command
  180. Merge Replication
  181. How to Determine the unique IDs of duplicated records
  182. Order By
  183. normalization
  184. Lock database to update
  185. DTS Rounding problem
  186. ms sql server
  187. Script to reverse engineering schema
  188. [SQL2000] permissions to use view based on tables from many databases
  189. How to tell how many times an SQL executed in v7 or v2000?
  190. How to tell how many times an SQL executed in v7 or v2000?
  191. Synchronize data between 2 instances of SQL Server Express?
  192. Table spool/Lazy spool question
  193. Query analyzer error message - Cannot generate SSPI context
  194. full text search on doc files
  195. Trigger problem no rowlevel support, please help!
  196. Connecting to SQL server
  197. DB shrinks without request
  198. Loop / Cursor help
  199. Getting closest matching values
  200. Returning Values from a Dynamic SQL
  201. truncating
  202. sql server and membership provider
  203. Embedded Queries?
  204. Store Procedure Query
  205. Tough Sql Query
  206. Can SQL Server work with a Paradox table?
  207. Formula problem
  208. Stored procedures, linked servers, and cursors
  209. Business-to-Business Data Integration in a SOA World
  210. sql query help join
  211. with nolock problem
  212. what are cursors in sql???
  213. SQL query help
  214. SQL Server 2000 conferences
  215. How to correctly update a table which values can be either inserted/updated/deleted on update?
  216. IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
  217. Splitting directory and file name
  218. Torn page problem
  219. Recovery model problem; db properities
  220. torn page detection and auto shrink: performance?
  221. Relational Database
  222. Last Year Month to Date Function
  223. Transaction isolation levels
  224. SQL Server float data type
  225. Query Help with Update statement, thanks!
  226. Record Counter
  227. limit resources per user
  228. very slow query (select count(*) from table)
  229. More efficient than LEFT JOIN
  230. Client Web Browser & Remote SQL Script Error?
  231. installing apache, php5 and mysql 4
  232. About Join OR Where
  233. Query Help!
  234. concatenate two fields in a view?
  235. Importing Access database into Sql Server Express
  236. Capturing Mysterious Truncation/deletion of a table
  237. Need Senior SQL DBA
  238. Administration tool web for SQLserver database
  239. IsNull and aggregate functions
  240. Slightly off-topic topic
  241. Select command with multiple tables
  242. select another column where max
  243. fetching unique pins...
  244. Indexing issue, inconsistent performance
  245. sp_executesql question
  246. Java method invocation support
  247. Job Executes Only First Step
  248. Dynamic query help SQL 2005
  249. Design Tool
  250. Errors on DBCC SHRINKFILE(2)
  251. Resolving duplicates entries in table among 10 databases
  252. Why the log file is growing too much upon running nested stored procedures (MS SQL 2K)
  253. Non-English Characters
  254. SQL Server 2005 - Save tran save point name case sensitive?
  255. SQL Sever 2005 - Full Text FormsOf Inflectional
  256. BACKUP LOG cannot be performed because there is no current database backup
  257. Can't reference a Group Field in Footer SUM expression!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  258. How to configure a JBOD disk array (PowerVault) for Performance
  259. Transaction reading from Linked Server without DTC? (Isolation Level?)
  260. Show Server Trace Missing in SQL Management Studio?
  261. SQL Server 2K Linked Access 97 Server not working
  262. Tuning sql in SQL Sever 2005 using the dta utility
  263. 100% CPU Usage (Part 2)
  264. Removing Duplicates rows from Inner Join
  265. Removing Duplicates rows from Inner Join
  266. Testing UDFs with TSQLUnit
  267. How do I NTH Select in SQL????
  268. Interview Questions Feb 09, 2006
  269. Design idea Help for Database
  270. Rollback transaction after connection lost
  271. Performance Problem
  272. Deadlock within select?
  273. interdatabase trigger possible??
  274. Ms Sql Blob ??
  275. SQL question
  276. Help with tricky T-SQL
  277. Class does not support aggregation
  278. REPLACE function doesn't work with null-bytes
  279. Why does SQL2005 automatically insert TOP 100 PERCENT in views?
  280. one for the SQL experts - dare I say TRICKY SQL!
  281. Great Job Board
  282. Full Recovery Model - log doesn't grow?
  283. Best Job Search Site...
  284. Searching/Estracting numerical data
  285. Any T-SQL advice?
  286. how do i replace a substring in sqlserver ?
  287. how do we tune a large sql query
  288. (Hopefully) Easy SQL 6.5 Question - Getting Table Structure
  289. How to go around the SQL Server 2005 User Instance problem when using Remote Desktop
  290. SQL Server DB installation
  291. ms sql equivalent of this oracle
  292. I can't find sql server on my computer
  293. can you tell me why this causes a deadlock?
  294. Developers needed for Healthcare software
  295. MS SQL 2000 SP Query Plan
  296. MS SQL 2000 SP Query Plan
  297. sql server and access
  298. Interview Questions Feb 03 2006
  299. Trigger not firing on update
  300. Read, modify table (locking) question
  301. Database views hierarchy
  302. Performance and data structure question
  303. perf
  304. Deleteing large bulks of data
  305. Int to char conversion
  306. T-sql
  307. Table variables
  308. Interview Questions Feb 01 2006
  309. Monthly date range substitution
  310. Getting the database name in Server-Side trace event
  311. SQL Server 2005: setup problem
  312. Replace chars in any field of a table
  313. Session
  314. do I need a DBA for SQL Server?
  315. Invalid Data for 'Numeric' when EXEC returns empty row
  316. update statement not to fire trigger
  317. help
  318. Set SP parameter
  319. how to restrict data insertion upto 50 MB in a table
  320. URGENT : Help -1
  321. Get Data From CSV to MS SQL DB
  322. Msg 107, Level 16, State 2, Line 1
  323. front end options for entering data into an oracle database
  324. Cant seem to find IUSR_MachineName in users using SQLEXPRESS 2005
  325. Workstation date
  326. timezones in select statement
  327. Connection to sql server 2000
  328. Interview Questions Feb 01 2006
  329. getting rid of trailing zeroes from a decimal output
  330. Database normalization
  331. moving tables
  332. date + 1 ???
  333. UPDATE on a column with a set default
  334. T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
  335. Rqst for Inventory Database Best Practices
  336. SQL Server Interview Questions Jan 30 2006
  337. IT tests. SQL, C, C++, XML, HTML, .NET...
  338. Example of binary data type in SQL Server
  339. SQL Server client tools
  340. How to find first not null value in column
  341. What is the right datatype to store Hours up to the minute precision?
  342. Data Connections for SQL Server Express in Visual Studio Express
  343. MS Access Frontend for remote sql server
  344. SQL Server 2000 Audit for login
  345. Database instance
  346. Views vs Stored Procedures, whats the difference?
  347. New bie
  348. New bie
  349. Formula Parsing
  350. Query out an xml element from a field containing xml data
  351. Problem Building Script with Int
  352. select cast help needed
  353. Truncate table if exists
  354. Scalability questions for extended stored procedure
  355. Insert/Update with dynamic database name
  356. ASC Result Set with Nulls at the bottom
  357. Can i debug/watch on the trigger's INSERTED and DELETED records/values?
  358. Conditional execution of DTS package task
  359. Help creating a SELECT statement for "today"
  360. SQL Server does not exist or access denied
  361. SQL Server does not exist or access denied
  362. Difficult SQL Statment
  363. Question on SQL Server 2000 - 2005
  364. export sqlserver database to ms-access by sql script
  365. configuration/load balancing
  366. Importing from Oracle 10g
  367. Ignore Some Errors
  368. Trigger?
  369. Outer Join problem
  370. ORDER BY in VIEW not working
  371. Commit Transaction Gets Deleted - Unable to save SP
  372. Joining tables in different databases
  373. SQL Server could not configure 'Server\Instance' as a Distributor.
  374. Web based sql server connection
  375. 6.5 to 2000 upgrade problems
  376. Default value: ISNULL()
  377. SQL2K5 Database Engine Tuning Advisor
  378. Linked Server to SQL-Server Question
  379. Connections to SQL server are slow on one machine
  380. ODBC Connection to a linked database
  381. Urgent rek
  382. Want to be able to create or view database diagrams
  383. Conditional Column Name On Insert
  384. Linked Server setup - SQL 2005 RTM
  385. Reporting Services
  386. Question about converting bigint field to int field
  387. Link to DB2
  388. remote permissions
  389. Need Junior SQL Server DBA in McLean, VA ASAP
  390. Odd connection problem (proxy + internal)
  391. How can I update several (not all) fields in table A from table B for replication?
  392. Server Feedback
  393. need help
  394. Failed KB909544 installation
  395. This query must be easy but need help
  396. Advanced Data Shaping - Multiple Relate clause
  397. Querying joined tables with 0 results
  398. Help wanted msaccess PIVOT-query --> MS-SQL view/sp
  399. Can I use stored procedures with PHP via ODBC bridge?
  400. Problem ith DTS and delimited file with empty last column
  401. how to get tables involved in constraint
  402. splitting a comma seperated column into multiple rows
  403. DTS Failed To Run
  404. Audit Logon / Audit Logoff problem with SQL 2K
  405. To Create Unique table names and access them in code...
  406. ODBC in Stored Procedure
  407. Variabe Error
  408. system information about indexes
  409. Facing Problem
  410. database migration
  411. osql batch processing without -i
  412. Truncated Decimals
  413. Unable to Update Table Even After Dropping Constraint
  414. question on inserting a record on sql server with identity column as key
  415. Does SQL Server save any metadata in registry or home folder?
  416. Is it a complex sql query?
  417. problem with filtering data
  418. isql / osql / Windows XP / disable "Automatic ANSI to OEM conversion"
  419. Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL
  420. Deadlocks, why?
  421. Baffled! Can't figure out how to do this query. Is it even possible?
  422. Full-text search across multiple tables
  423. SQL QUERY HELP
  424. Why would adding dbo. cause my function to run forever?
  425. SQL Query
  426. Advanced Sql-Shape Query - Help
  427. NEW @ DTS
  428. Searching a datetime field by time
  429. Searching for a partial match in a varchar field
  430. mesage in Sql Server 2000 log
  431. selecting only numeric data from a string
  432. Convert Text to Int
  433. Store procedures
  434. Record count in all tables
  435. show stored procedure
  436. show stored procedure
  437. Simple SQL query question
  438. SqlCE Synchronization Issue: Native Error 29006, The process could not deliver the snapshot to the Subscriber
  439. change home and data directories
  440. Can LOG PI or Log Explorer recover deleted records BEFORE
  441. Requirement for peoplesoft CRM at SFO,CA
  442. bcp into view with derived column
  443. View Permision sql 2000
  444. Preventing the message 'Duplicate key was ignored'
  445. standard sql: update multiple rows.
  446. Adding column via sp_repladdcolumn...
  447. Unicode Conversion
  448. Testing (Please Ignore this message)
  449. vs MySQL
  450. Browser as Front-End
  451. Experts Profiels
  452. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
  453. How to omit Schema name when referrring to Tables?
  454. How to mit the Schema name when referrring to Tables?
  455. nested joins - joining one table to another multiple times
  456. Combining 3 SQL statements
  457. Combining 3 SQL statements
  458. Cursor loop is broken
  459. Cursor loop is broken
  460. Cursor loop is broken
  461. Environment and Application Domain between ASP.NET & SQL Server
  462. Help
  463. Default Template for User Defined Function
  464. Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
  465. QUESTION: Exporting data into SQL statements
  466. Problems upgrading to 2005 Trial from 2000 Standard Edition
  467. SQL Server 2000 License Query
  468. *Very Urgent Rek - SQL Server DBA from Direct Client: Full time* @ New Jersey
  469. How to get code of stored procedures ?
  470. "owner name" cannot be omitted in sql 2005 querries?
  471. SQL Distinct Value and Order by some Field......
  472. Configuration file
  473. SQL Server and Workgroup networks, how?
  474. managing users
  475. Connection to Oracle sometimes hangs
  476. Stuck - Cant figure out a Query for this situation
  477. SQL Query question
  478. SQL Query Question - JOIN or not to JOIN
  479. Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
  480. Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
  481. No ending Rebuild master
  482. XML Data Processing
  483. Simple SQl question
  484. How to know the User who disabled a Job??
  485. XML data feed
  486. Deadlock on Update using temp table
  487. Ms Sql Query
  488. (Can't get) Media for SQL Server 2005
  489. Index for username/password
  490. Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch??
  491. dateformat is ignored
  492. Backup failed: Operating system error 112(error not found).
  493. Moving SQL Server to a new drive
  494. Need help with a join
  495. Is "name" a keyword?
  496. Oracle/MS SQL Interface
  497. Best way to interface with Oracle
  498. How many CALs for a web page?
  499. view with auto_increment field
  500. Visual Query Builder with unions and sub-queries
  501. Createa table like a existing table?
  502. SQL Server 2000 Installation error
  503. Synchronising/replicating access with sql server
  504. Synchronising with remote server
  505. C++ and SQL Server programming
  506. Temp Table Faster?
  507. SQL Server Std vs Small Business Server 2003
  508. Stored Procedure only works in when app uses trusted security
  509. How to execute a "batch file" using SQL Server 2005?
  510. Stuck with sorting columns
  511. Export SPs?
  512. Export SPs?
  513. Referential Integrity
  514. Business Analyst with i2
  515. intead of update/insert trigger on view question
  516. MS OLE DB for ODBC with Oracle ODBC source headaches
  517. Index on two columns doesn't allow NULL in both - HELP!
  518. How to schedule a stored procedure
  519. Breaking apart Column into rows
  520. Making a view that shows the results of several different queries.
  521. Where the !@?!@ is my Stored Procedure?
  522. Calculating 'time difference' between two records....
  523. LDIFDE csv import to SQL - looking for Ideas
  524. OLE DB Provider for ODBC and Oracle
  525. How to Restore an Archived Filegroup on Another Server
  526. operand type clash
  527. How do I use SELECT on a column with datatype TEXT?
  528. one transaction log per filegroup?
  529. TransferText dropping fractions
  530. SQL/ASP - Timout Problem w/ Particular Statement
  531. Update Web Form
  532. time format error
  533. arbitrarily delete transaction log
  534. Size of data-set passed back by a select
  535. Store Multi-Select values in an image data type?
  536. Lost Data
  537. Periodic run of stored procedure
  538. changing collations
  539. SQL 2005 Management Studio: Line Numbers in Query Window.
  540. Can't edit Linked Server General Properties after saving
  541. NetSearch the Business Intelligence Search Engine
  542. RESTORE an Old Filegroup into an UpTodate Database
  543. sqlagent.out
  544. Connection pooling
  545. trigger help
  546. database maintenace Plan location
  547. Maximum UNION statements in a query
  548. How to pass table names to a Stored procedure
  549. Concurrent users
  550. Reacting to DB events