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. if-then in select stmnt
  2. collation SQL_EBCDIC037_CP1_CS_AS
  3. Importing data into MS SQL 2000 from XML file
  4. New trigger stops scope_identity / @@identity from working
  5. SQL2005 Rebuild Index Not Working
  6. i want ot convert xml data format into the general data format
  7. Backup log - will it truncate?
  8. peraphs thi spost go here...
  9. Times in SQL Server
  10. composite index and column order
  11. Help with 2 datetime fields-1 stores date, the other time
  12. exporting data into tables from excel file
  13. SQLXML
  14. Store program EXE in table?
  15. Disabling the AUTOCOMMIT option in MSSQLServer
  16. Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue
  17. noob sql learn! web interface and sql express!
  18. Dump of databasse
  19. Scripting Databases
  20. need information for "Before Select" Trigger
  21. Cannot Alter Table being Published for Replication
  22. SQL Server + Oracle Data linked in one query
  23. Format a datetime columns output?
  24. update
  25. Help with large text fields please
  26. Get results from VB SQLCRL Stored Procedure
  27. SQL Server 2005 stored procedures decryptor
  28. Create project/stored procedure for SQLCRL
  29. Calling Stored Procedure from an ActiveX task
  30. Challenge: Can you optimize this?
  31. Transactional Replication - Adding New Articles
  32. Record size more than 8060B
  33. SQLServer 2000 SP4 Enterprise Manager crashes immediately...
  34. SQL Union Problems When Trying to Retrieve Random Records
  35. McAfee Recruits Database Engineers
  36. Line 1: Incorrect syntax near
  37. How to Insert date in sql server database
  38. Parameterized SP in WHERE Clause of Another SP
  39. Question about returning a smalldatetime from a Function
  40. Dummy Question
  41. SERVER BUSY
  42. Automated email
  43. My article on Dynamic Search Conditions
  44. deadlock problem
  45. Reporting Services Report Viewer versus Report Server Problem
  46. Referential Integrity problem
  47. Trigger to populate table or database
  48. SQL_Latin1_General_CP1_CS_AS
  49. register hasn't been updated
  50. Finding prepared statement sql
  51. HAVING prob !
  52. Interface for SQL Server database
  53. this sql command make me sick
  54. Question about using AND in WHERE...
  55. money data type
  56. listing all SQL SErver and fill a sheet
  57. default value on quantity and price field
  58. XML issue.
  59. Complex Query
  60. Linked Server Time Difference
  61. Backing up Logins and Permissions for SQL Servers
  62. Very chalanging question - Explanation
  63. View SQL transaction log details
  64. batch file to send email
  65. Insert from parameters and select statement
  66. VERY chalanging question
  67. sql client in sql server 2005
  68. 2005: SIMPLE QUESTION: error log
  69. need help in SSIS ETL development
  70. Help Needed
  71. Storing SQL Server Agent logs in a relational store
  72. SQL syntax question
  73. port specification
  74. port specification
  75. DBA Interview Questions
  76. Can't view Locks / Process ID
  77. sp_helprotect COLUMN has NULL value
  78. T-SQL CLOSE Connection to DB
  79. How can I conserve the initial zero when convert numeric to string using STR()
  80. sufficient user permissions for install error
  81. Moving Log Shipping Monitor
  82. Oracle Server Quick Reference Guide
  83. Insert a record in a particular place
  84. Trying To find a Match in computed columns
  85. error: Cursor not returned from query
  86. SQL Server 2005: CLR functions vs SQL functions
  87. AS 2005 Cube/Perspective/Measure Group AutoDoc...
  88. script
  89. Limiting Rows in a Report
  90. Output stored procedure
  91. SQL Server 2005 blindingly fast
  92. Interested in SQL server 2000?
  93. Log shipping failover
  94. using lookup and display only field as control field
  95. field is part of an index
  96. How to import Dbase file
  97. Hanging during READ_COMMITTED_SNAPSHOT ON
  98. Substring and Charindex Script Not Working
  99. How to make a correct select
  100. Duplicating a Database using RMAN
  101. IIS issue
  102. Concatenation getting truncated
  103. What's wrong in this query ?
  104. Web Application Testing
  105. Creating dates from table columns
  106. Book contrasting Oracle and MS SQLServer?
  107. Question on Transaction Log Backups
  108. converting integer zipcodes to a 5 character char
  109. What permissions do I need to manage users?
  110. Need Tech Review of MSSQL Backup Chapter for O'Reilly Book
  111. My boss beats me
  112. Returning multiple rows from a stored procedure
  113. MySQL -> ms-sqlserver
  114. Probem in executing a long Dynamic MDX from SQL server
  115. eternal lock?
  116. Effects of a Database restoration.
  117. how to insert data into to image datatype
  118. Problem While Connecting a folder containing sql files in Execute SQL Task in Execute Sql statements in loop example
  119. SQL 2000 -> SQL 2005 conversion sql authentication problem
  120. sys.tables starting with #
  121. to read backup file
  122. rowcount help
  123. Use ANSI Join or Old Style Join?
  124. HW Requirement for SQL Server 2005
  125. SQL Query Help
  126. Upgrading HA Applications with Replication
  127. Numbering in SQL
  128. comparision of sql server & mysql
  129. SQL IN Query
  130. Insert into a table recursively
  131. SQL Script Debugging - Just being curious
  132. Conditions on latest record
  133. Help to optimize query
  134. Parsing a varchar(79) column
  135. ADO.NET Timeout Exception - I have tried everything
  136. Copy a table from one DB to antoher in SQL Server 2005
  137. Copy a table from one DB to antoher in SQL Server 2005
  138. Customize Prompt Message for Stored Procedure from Access Form
  139. sp_fkeys stored procedue is very slow
  140. New server setup and RAID recommendation
  141. SQL Server 2000 running out of space.
  142. Copying files between servers
  143. how to improve performance of 'LEFT JOIN'
  144. JDBC connectivity with SQL Server
  145. Your Professional Advice Please - Design
  146. How do I start sql listener on a port?
  147. deadlocks
  148. loading sql files from a master file Oracle equivalent
  149. Retrieve good records from a bad record table
  150. Convert Access Query to SQL Server View
  151. SQL server thrashing?
  152. FILEGROUP BACKUP/RESTORE
  153. Using BLOB
  154. alter table nocheck constraint still some dependencies
  155. Compare databases between 2 SQL servers
  156. MS SQL Script Optimisation
  157. the datatype
  158. purpose of OUTPUT keyword in sql server
  159. Problem with Delete On Linked Server
  160. db upgrade code
  161. Putting attribute on root node using FOR XML PATH
  162. How to debug in SQL Server 2005
  163. detect connectable db servers
  164. Create Status Table
  165. Indexing strategies
  166. create table with recursive relationship
  167. Formatting database content
  168. Problems with remote conexion
  169. high cpu, low speed
  170. udf
  171. deploy Report
  172. View from a merge of two tables
  173. Adding new lines into results in the
  174. Truncate Table On Linked Server?
  175. Logging Into Linked Server
  176. Transferring Data Between Servers
  177. MORE THAN A THOUSAND POSITIONS NATIONWIDE
  178. NovelSpace Media, LLC announces the launch of their new online bookstore and web portal devoted to developers and programmers.
  179. Qouted String
  180. CAL Licensing and user limitations?
  181. Import spreadsheet using TransferSpreadsheet
  182. LogReader Agent Lacks Required Privilege
  183. update SQL field with stripped data from other field
  184. Create view from cursor
  185. MS SQL: how to fill down values from row above when column meets specific criterea
  186. 64 bit SQL 2005 Memory
  187. DBTool (another database toolbox for MATLAB ) new release 2.4
  188. Tool/Best Practices for installing BI Project
  189. SPs from SQL 2000 to SQL 2005
  190. Create Peer-to-Peer Topology Error Message
  191. 'MSDAORA' was unable to begin a distributed transaction - why?! (SQL <-> Oracle)
  192. SQL2005 collation vs Oracle
  193. Need OLAP Dev in Colorado
  194. Exotic SQL Question
  195. Clustered Index considerations
  196. Transactional Replication and Failover Cluster
  197. Access 2000 project
  198. bug: data file autogrowth set to 12800%
  199. how to create a real (not virtual) table from view1 & view2 ni sql server?
  200. Select several values into a single variable
  201. Monitoring Production Instances.
  202. How to import several excel files using one dts package
  203. Copy 60GB table?
  204. Can't start the SQLAGENT
  205. Looping through several Excel data sources in SSIS
  206. Tempdb grows rapidly and fills up disk space
  207. T-SQL Debugger Doesn't Allow Stepping Through Stored Procedures no other procedure with the same name
  208. Setting up a Settings Table
  209. SQL Server 2000 and 2005 co-existence problems
  210. JDBC - varchar or nvarchar fields?
  211. Running SQL and Oracle on the same server
  212. Multicolumn correlated subquery?
  213. Need Emergency Advice
  214. Urgently Required a System Support Engineer
  215. Merge replication issue - one column not replicating
  216. Update statement performance problem
  217. C# / Sql Server question
  218. TRANSACTIONS in a WHILE LOOP. Flow Question
  219. Using ADO AddNew and my simple trigger won't execute
  220. WinXP, SQL Server 2000, Queries
  221. locating set of points close to one another (within a threshold)
  222. Backup SQL Files
  223. Problem moving msdb
  224. Help with update trigger
  225. Wild cards in query designer
  226. Updating recordsets in MS SQL 2005 not working
  227. return into one string
  228. Using trigger to export xml file
  229. DTSRUN privileges?
  230. Table Joins on more than one field
  231. how to find conditions across rows (attendance)
  232. help for query
  233. All Interview Questions And Answers
  234. Gather Format and Store - Right or Wrong
  235. Attach a read-only restored database
  236. Join multiple records into one field
  237. Partition function - Unknow range column
  238. Problems with view
  239. Use variable for datasource in Opendatasource
  240. Date creation in SQL
  241. Tuning on Oracle 10g and SQL Server 2005
  242. How to do an equivelent First() operation
  243. Selecting MAX (Date) - Performance Question
  244. SQL Counting number of non-distinct rows?
  245. Problem with using BETWEEN for date range...
  246. Updating SQL Server Table Using Excel
  247. how to store XML Document in MS SQL using JAVA
  248. Transactional Replication over the Internet
  249. An odd quandry.
  250. Raising errors in a catch block in SQL2005
  251. How do I use pass data to/from stored procedure
  252. How do I use pass data to/from stored procedure
  253. Load XML souce file to a SP parameter
  254. select statement and Distinct and or Group By
  255. String matching precedence
  256. How can I insert # in a character field
  257. ANSI Nulls
  258. HELP is needed for MsSQL
  259. Stuck execution plan?
  260. return values from DTS wizard
  261. Script to find last time Cubes get processed
  262. Transactional Replication - Modifying Target Tables
  263. Remote connections error SQL Server 2005
  264. Converting Int value to datetime
  265. Syntax Help!
  266. Database name not found in the Edit job step in SQL Server Enterprise Manager
  267. Getting a unique ID in SQL Server - other than a GUID
  268. RAID 5 beats RAID 10
  269. sql server - "use database" not found
  270. DTC
  271. Sql 7
  272. Trigger to encrypt field before write
  273. Problem deleting publication
  274. Update Statement
  275. Update statement
  276. SQL Function
  277. Conditional Query
  278. VB (5or6) does something wierd with image data while saving to sql2000
  279. the Best way to build a 5 million entry database?
  280. MySQL Cluster
  281. Declare dynamic Cursor from String
  282. Limits on rows in a table
  283. sql query help
  284. SQL 2005 Encryption questions
  285. Please help quick statement check
  286. Compound Primary Key - order not as expected
  287. Log Shipping to two Databases on One Secondary Server
  288. SQL in Access Report
  289. Simple JOIN, INTERSECT query
  290. How to performance case-insensitive search on XML data type in SQLServer 2005?
  291. Correlated Query Summing Question.
  292. How to page SQL query result returned from FOR XML statement?
  293. query hheeelp
  294. Cannot insert explicit value for identity...
  295. Removing embedded SQL from database application
  296. No distinct in a select into stement ?
  297. SELECT and regular expression
  298. Sorting the result
  299. Access PErmissions issue
  300. Articles on Dynamic SQL and certificates/impersonation
  301. SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_v alue" ?
  302. backup failure
  303. SQL Server 2005 Import/Export not copying stored procedures
  304. instance of sql server
  305. Search Between Times
  306. Exporting sql data to specific cells
  307. Performance Question: Cursor-based vs Set-based
  308. Strange issue with SQL Table read only in Access
  309. Trigger Question
  310. security for row level but not based on Database user's login
  311. Any functions to replace NZ in SQL Server?
  312. SQL and Terminal on 2 different PC's
  313. Undo last statement
  314. SQL and Terminal server on 2 different PC's
  315. Selecting rows from one table that are not in the other
  316. Date (not datetime) datatype in 2005?
  317. Basic, perhaps silly SQLServer 2005 question
  318. Restoring Master on another machine...
  319. Efficient SQL Backup?
  320. Using IF inside SELECT ?
  321. Get all records from Last Two Days?
  322. SQL Server Backup File Format
  323. Timeout errors
  324. How to Get the 2nd the 2nd Record AND DISPLAY IN SINGLE ROW ?
  325. How to check werther sqlexpress is present on system while installation
  326. Time Over 24 Hours
  327. delete sql syntax for linked notes table
  328. wrong result set
  329. select * in views
  330. SQL 2005 Express vs SQL 2000
  331. MS-SQL Standard Memory Cap
  332. SQL 7.0 Stored Procedure Execute Privileges Only?
  333. Sum Accumulating Data
  334. Advice on middleware products for TRUE Scaling out of SQL Server
  335. selecting a set for min value
  336. How Do I Restore A Warm Backup If My Primary Server Fails?
  337. fmtonly problem (bug ??)
  338. Different query plans
  339. Left Joins and record insert problems
  340. SQL Server 2000 and 2005
  341. Count all records in all tables
  342. Linked Server To Lotus Notes
  343. SQL Query Question
  344. failover cluster using 64 bit windows 2k3 on single HBAs and DS400 with dual controller
  345. insert into temp table based on if condition
  346. Smalldatetime comparisons with non-clustered index
  347. Are sub-subqueries possible?
  348. Literal value with "IN" clause
  349. "group by" by excluding prefix
  350. Killing the process automatically
  351. find matching sets of rows
  352. SQL user and group audit report
  353. Time to shrink a database
  354. Inconsistent SQL results
  355. Looking for MSSQL table structure
  356. HELP with MS-SQL
  357. Some basic questions
  358. ## How to acquire the SQL Server 2000 Performance data? ##
  359. HELP with sql query
  360. Retrieving autonum / IDENTIFIER value from SQL table using DAO.
  361. UMS Scheduler Hang
  362. Remove Duplicate Rows
  363. Configuring Peer-to_Peer Merge Replication
  364. Need some practice
  365. What is a full-text index?
  366. Changing Domain for SQL Server
  367. Saving .mdf database
  368. Difference between multiple primary and secondary files..
  369. Re-display result set without re-running query in Query Analyzer?
  370. Disk or network error
  371. SQL-DMO and C#: retrieve the list of User-Defined Functions
  372. SQL Svr 2005 Express Does NOT Support DTS
  373. creation of table that type of format........
  374. Trigger Question
  375. Full-text Search applied on a View
  376. scripting objects in sql server 2005
  377. The database name component of the object qualifier must be the name of the current database
  378. Maximum number of records per second that can be inserted into SQLServer 2000.
  379. Help: 900 byte limit on stored procedure parameter?
  380. problem with count, group by and ntext
  381. check diskspace UNC via T-SQL
  382. Exporting From SQL SERVER
  383. SQL Server needs help from MS Access (or something)
  384. Auto Number
  385. MS buys Proclarity
  386. temp db
  387. SQL: how to display top 5 then sum the rest
  388. Incorrect Syntax using IF statement
  389. Getting all nodes and node details from xml using xquery
  390. SQL server express 2005 local accounts problem. please help!
  391. SQL 2005 Management Studio Bugs
  392. SQL Server 2005 vs Oracle
  393. datetime diff query syntax
  394. Calculate time lapse
  395. New to MS-SQL
  396. Installing database while setup
  397. Problem concatenating column values into string...
  398. XQuery vs OpenRowset
  399. programmatically restore a database
  400. Reversing string concatenation
  401. Transport Level Error has occured
  402. Scheduling DTS Package using a stored procedure problem
  403. rights issues with linked server
  404. How to make correct join
  405. Download image datatype to Jpegs or GIF's
  406. String Comparison using "Score Method"
  407. Dose MS sell SQlSerever with student rate?
  408. Row sequence number
  409. Row sequence number
  410. Testing Query Performance - clear out cache
  411. float numbers
  412. Passing a file path to a SP
  413. IF funcionality in SQL server views
  414. Are embedded views (Views within views...) evil and if so why?
  415. Complex query
  416. alter table column, which is part of foreign key
  417. Math functions
  418. JDBC Driver NOT throwing Exception
  419. error when trying to do datamining
  420. The transaction has exceeded the allotted time
  421. Illegal Immigration, the Non-Issue of the Week??????????????
  422. ERROR_STATE() Always = 0?
  423. Need a So-Called SSN Encryption
  424. Update SQL 2000 Query (converting an Old Access 2k query to SQL)
  425. SQL Server 2005 Client Tools
  426. Timeout Expired
  427. Bind Variable in CURSOR
  428. Timeout fixed by recompile
  429. Automatic statistics update
  430. Full text indexing with Japanese characters problem
  431. I'm sure this is an easy one...Error trap to skip over a "bad" object.
  432. Sqlserver Login and user
  433. Transpose Rows to Columns ?
  434. Hiding NULL
  435. Optimizing SQL - Union
  436. speeding up inserts
  437. Down and dirty database infrastructure
  438. 2005:how to find installed assemblies
  439. database design for fast client updates
  440. Stored procedure with unknown numer of paramters, how?
  441. Problem with a join due to multiple Nulls
  442. how to setup the permission of share fold in log shipping ?
  443. Stripping input mask from phone numbers
  444. SQL Consultant Required
  445. Cursor looping versus set-based queries
  446. Odd query plan for view
  447. Updating Linked Records Across DB's
  448. Select first n rows of table
  449. Sql server report
  450. Update Table
  451. Database poster
  452. Management Studio Express
  453. SQL Server 2005: Migrate DTS to Where?
  454. column name change
  455. How to fire a trigger without changing table data
  456. Row Numbers for a View
  457. ranged datetime predicates & cardinality estimates
  458. Order by in a INSERT INTO..SELECT
  459. Assigning group numbers for millions of data
  460. Where to write XQuery statements?
  461. I need help, please
  462. SQL Server 2005: Collation Conflict Error when selecting Database Properties
  463. LDAP authentication for Yellowfin on SQLserver
  464. Multiple Foreign Keys on Same Table
  465. Multiple Foreign Keys on Same Table
  466. Multiple Foreign Keys on Same Table
  467. Query/View: The 2 newest periods for each indicator
  468. Copying encrypted stored procedures.
  469. French characters are not imported properly with bcp
  470. Accessing Oracle Tables From Within SQL Server 2000
  471. Licensing Question
  472. SQL Server 2005 install - no Management Server
  473. generation of sql for an alter column etc
  474. Grant Win Acct Permission
  475. Help selecting an alias
  476. help with group by statement
  477. bug - insert miliseconds
  478. Website navigation hierarchy with SQL Server 2005
  479. connecting in a script to another db
  480. Optimising queries
  481. Help selecting the proper child record
  482. slow insert, logical fragmentation
  483. Performance Enhancements with Service Pack 4?
  484. Select 'Current LSN' and 'Transaction ID' from ::fn_dblog
  485. Connecting to another SQL Server
  486. Join returns more than one row, Post code regular expressions
  487. Update the salary of each manager to be double the average salary of the employees he/she manages
  488. SQL Server 2005: TRIGGER AFTER INSERT
  489. Maximum number of databases used for each query in 2005?
  490. Update n rows
  491. Monitoring SQL Server transactions
  492. Transactional replication without synchronizing snapshot initially.
  493. open MDF file without MSDE
  494. How do I change the default collation string of an installation
  495. SQL Server License Control and Management
  496. trigger to parse a string from insert statement
  497. Many to one Select
  498. Unwanted Sort
  499. Using OSQL and DTSRUN
  500. can you launch a crystal report from a sql trigger
  501. IDENT_CURRENT problem
  502. sql commands dont work in mssql????
  503. charindex question
  504. Joing tables using more than one field
  505. SQL script for changing all identical columns
  506. Resource for developing your own accounting software using MS technologies
  507. Job succeeds manually but fails if scheduled
  508. SQL--- GROUP BY Clause
  509. T-SQL Problem
  510. MS SQL server 7.0 restore/create
  511. Reporting a table with two columns from another table
  512. Help with a substring query
  513. Check constraint does not work (compare with null)
  514. Ink
  515. Possible to disable welll-formedness checking when inserting XML data.
  516. Row to Column
  517. add a column specified location in Table..
  518. Ink
  519. Design problem
  520. Query Problem
  521. bigpubs2000
  522. mysterious corruption of stored procedures
  523. SQL Server Maintenance Routines/Procedures
  524. Dell Raid 0+1
  525. Stored Procedure Help
  526. outer join column
  527. waittype=WRITELOG
  528. Delete Many Rows
  529. Help with INSERT TRIGGER - fails with error.
  530. Deploy .MDF to a web host
  531. To retrive a table from one database to and another database(same table)
  532. Alternative to OpenXML
  533. Memory allocation in MS-SQL 2000 instances
  534. SQL query - duplicate records - different dates - how to get only latest information?
  535. bcp right truncation: how to ignore
  536. 2000 vs 2005 -- AnsiNullsStatus
  537. Sql Server Performance
  538. Full text index on a view
  539. Performance
  540. query...
  541. query...
  542. change of value at the time of insertion
  543. Querying a column with brackets in its name
  544. Compare given period in current year / previous year
  545. Data Warehouse Nulls
  546. Selecting records by date - need a little help
  547. Getting previous values of a field
  548. Not grasping outer joins for ms-sqlserver :: 3 tables to join
  549. Finding the natural key
  550. Browser Time Out: when executing a DTS package