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. UPDATE query gives Incorrect Syntax error
  2. large data : how do you store multidimensional data ?
  3. DELETE only deleted 10000 records
  4. finding PIVOT table data source
  5. How to use Cast
  6. truncate decimal place
  7. query is slow after inserting lots of records in some tables
  8. Recursive Update Query for SQL server
  9. Tablediff Utility SQL server 2000
  10. generate SQL script from DTS
  11. how to get todays Inserted and updated records in sql server 2005
  12. searching fields and displaying feilds with data
  13. database problem
  14. Tweaking SQL to optimize the query execution plan
  15. Help Needed For writting a query (SQl Server 2005)
  16. MsSQL - Not storing and returning milliseconds
  17. How can I produce multiple output flat files from a single SQL filewith multiple SQL statements?
  18. Best method for storing a time in a MsSQL database?
  19. UPDATE Record's
  20. SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
  21. Deadlock Issue
  22. Different empty_string/NULL handling under ODBC and OLE DB?
  23. T-SQL: Recursion and circular references
  24. DTS: Copy new + modified records from table1 to table2 from two different servers
  25. MySQL to MSSQL Conversion
  26. Encrypt and decrypt a full database in sql server 2005
  27. SQL Serial Data to Parallel
  28. SQL Installation
  29. get the jobs run in a particular time interval from sysjobhistory
  30. How to create a distinct table combining records with Null values
  31. Project Management Knowledge Base !
  32. Columns
  33. How to store the result set in temp table
  34. sql squeries
  35. Query with different WHERE clauses
  36. sql queries
  37. Is there a limit in retrieving foxpro file using VFPOLEDB ??
  38. Validation Constraint on Data Entry
  39. Creating Reindex
  40. Truncate text in table? (ie 101928494 will become 928494)
  41. query on multiple database
  42. pivot? rows to columns
  43. SQL 2005 Express
  44. Comparing data in two different tables to find missing records
  45. SQL Server 2008 Final release date
  46. scheduled data clearout
  47. relationship
  48. sql queries
  49. not showing proper datetime in tables
  50. IDENT_CURRENT help
  51. sql server queries
  52. get latest date record
  53. MS SQL 2005 Replication, unable to create publication
  54. Calling external apps from SQL Agent
  55. plz suggest me the query
  56. Update date In MS SQL
  57. IT auditing tool SC Magazine Review
  58. Update table name and all objects that reference it
  59. Creative query assistance needed
  60. Convert Access quey to SQL statement
  61. How to validate a column using stored procedure
  62. undeclared variable in stored procedure
  63. mapping path of a file
  64. How to find out difference between two rows....
  65. SQL Server 2005 - Developer Edition Installation Error
  66. Moving SQL server to another
  67. SQL server 2005 enterprise manager
  68. SQL Server Engine Downgrade
  69. SQL Problem
  70. I want to connect DB in SQL with data in Active Directory(Urgent)
  71. Open record sets
  72. MS SQL Problem
  73. Problem With MS SQL
  74. SQL 2000: Transport-level error on SELECT statement
  75. Create Trigger
  76. Complex Query
  77. dropped tables
  78. SQL 2000 server replication and a MSmerge_tombstone problem
  79. Trying to insert a zero, its telling me i cannot insert a null
  80. Significant Figures/Digits.
  81. Database size shows huge
  82. Query for displaying a particular set of data
  83. Update auto increment feild to replace nulls
  84. Calculate Number of working Days in a Given Period
  85. Update/Insert with constraint
  86. SS2000 500xSELECT on one table; how to speed it up??
  87. Generating Script for a DataBase
  88. A Question on query efficiency
  89. How to deploy a database on SQL Server Express 2005
  90. Can Analysis Server and Report Server run on SQL Server 2000 Cluster
  91. Jobs, Interview Questions, Certification, Knowledge
  92. How to do incremental update?
  93. 'FROM reallyReallyLongTableName AS a' syntax?
  94. Re: SQL Server 2008 caching
  95. package configaration SSIS
  96. Determine which fields to select based on date
  97. Use output of Stored Procedure as where condition
  98. Re: SQL Server 2008 caching
  99. Exception handling in stored procedures
  100. select blocking sessions t-sql
  101. Write "Messages" window to a log file?
  102. please solve this problem
  103. Sql Connection
  104. spli two rows
  105. Database login failed
  106. Incrementing Filename when saved
  107. problems with case statement in where clause
  108. Does SQL Server support a row count function?
  109. Deduping
  110. Yellowfin seeks resellers for BI product
  111. Sql Server Install
  112. Store DWG file in SQL server?
  113. load_file and blobs
  114. Using a Trigger to determine when a column was changed
  115. Import table from notepad to SQL server 2005
  116. Insert from SQL2005 to DB2
  117. Data returned by SQL Server ODBC driver is not correct
  118. Cannot Create DSN connect to SQL Database
  119. Update Status column after specific date.
  120. MSSQL bcp command help
  121. Certification in Mind???
  122. Only 90MB for SQL Server 2005 on a Windows 2003 64bit 12GB System
  123. Using charindex AND substr to pull out data
  124. restore .dat
  125. Finding duplicate records
  126. Looping through recordset creating calculated Rank Column
  127. compare lock setting in sql srv 2000 and 2005
  128. Automation error
  129. SQL 2000 DTS tool - 256 char limit?
  130. Create Index on View
  131. Uncommon records from two table
  132. Linking Windows SQL Login to user database
  133. Determine the byte size of a particular row?
  134. Calling Commonly Used SQL (reusable code)
  135. BCP with special chars
  136. joining multiple tables based on 1 criteria
  137. Export to Excel, exclude header
  138. Stored procedure incorrect?
  139. Can a dropped table be recovered?
  140. How to show field that not being group
  141. need a query (columns to rows and rows to columns)
  142. Softclarity Builder
  143. Round to 2 decimal
  144. Creating Database
  145. Replication of MSSQl database from one server to another
  146. compare ntext to datetime
  147. Computerised Date
  148. How do i use LIKE for a search query?
  149. automatic id generation
  150. Distinct Row based on description count
  151. Accepting wildcards like % in input parameters of stored procedures
  152. Slow Query causing application problems
  153. Re: problem with column alias
  154. Query problem
  155. create database
  156. Trigger and procedure
  157. query
  158. Insert in two tables
  159. Please can someone help
  160. Re: problem with column alias
  161. just u click make a money online
  162. How to insert dates using datetime functions.
  163. Having problems using BCP for CSV output
  164. import data from excel into sql server 2000 by C# in .net
  165. Re: ALTER proc vs IF EXISTS DROP/CREATE
  166. count the rows
  167. ALTER proc vs IF EXISTS DROP/CREATE
  168. Cursor does duplicate records
  169. ODBC--call failed.
  170. BCP error on a database with name in two words
  171. Query Across Multiple Tables
  172. Delete Trigger
  173. Intrusion Detection Strategies
  174. Delete a BackupDevice in Code
  175. SQL Server Scripting Question
  176. Date conversion problem
  177. SQL DB Backup
  178. Select Query with = not returning any rows
  179. Stored Procedure to reliably update two tables.
  180. Dynamic field names
  181. SQLServer2005 procedures
  182. sql update trigger that updates table 2 when table 1 is changed
  183. Restoring a SQL Server 2005 database without the log - revisited
  184. SQL Server Agent confuse?
  185. Capturing the date and time based on clients timezone in SQL Server 2005
  186. Import data from comma delimited text file into an SQL Server table
  187. Help to query a date range
  188. Why is SQL Server procedure not executing properly?
  189. Handling multiple database with stored procedure
  190. Connection is busy with results to another hstmt
  191. sql server query problem
  192. DB BAckup
  193. Distributed query [drawn out problem]?
  194. Insert Into Select trouble
  195. Login failed user error in running web application
  196. SNL Sql
  197. Error updating the employee details!", help
  198. ms sql 2000 - create update script
  199. Problem in using LINQ to SQL
  200. any sql code to search database tables ?
  201. Getting check constraint error from sproc?
  202. Recursive Stored Procedure
  203. how to write trigger in sql server 2005
  204. how to sum some field in a row
  205. Strange issue in execution of sql
  206. how to Backup only selected tables
  207. How 2 store values through Stored Procedure from ARRAYLISTwhich is from Database only
  208. SQL Query for Dummies
  209. CONVERT() problem
  210. UPS WorldShip SQL
  211. problem with MS sql server 2000 database table
  212. various errors connecting - possible permissions problem
  213. Group By and Having are driving me crazy!
  214. Problem with REPLACE with binary strings
  215. how to decrease the size of database
  216. Recursive update query
  217. Difference between check constraint and dafault constraint
  218. Latest updates in database management and SQL server tools andtechniques
  219. Da MySQL a SQL express
  220. T-Sql & Active Directory Roles, Identification of original login ofimpersonated ID's and Suspended processing
  221. unable to install SQL Server 2005
  222. merge data from two sets into one
  223. select @@identity
  224. no text in object
  225. SQL Server / Access commands/recordsets
  226. How to create a new database with an unknown name?
  227. Re: Best practice on nullability and default value
  228. Passing querystring to a website through sql report
  229. How to Lock and Release Table?
  230. Formatting datetime when including in a PRINT command etc...
  231. Pb to open an attached mdf file
  232. RESTORE DATABASE is terminating abnormally
  233. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  234. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  235. Orders Database Storing Orders
  236. Patch for KB948110 causing random "Could not find database table ID"errors
  237. Update record of two table
  238. Unable to view SQL7.0 Table Records through visual basic
  239. Right Justified with leading zeroes
  240. getting error in query..
  241. Database Compare,Data Compare tool,sort sync scipts with databasedependencies.
  242. Update Record in two Table using trigger
  243. How to compile TPC-H ver2.7 on Windows XP?
  244. complicated query (where statement inside select statement, don'tknow how to explain it)
  245. Building a datacube with Excel 2007 and SQL Server 2000
  246. Insurance data models...any tips on good starting point?
  247. DB Backup
  248. Are Deadlocks inevitable ?
  249. Help With Full Text Search. Performing AND across columns
  250. rupdating duplicate entries with random numbers
  251. Changing the name in the ServerName column
  252. Execute store procedure
  253. How To Save File to varbinary(max) in SQL 2005
  254. Schedule a Query
  255. SQL Query Analyzer
  256. trigger - Incorrect syntax near 'INSTEAD' error
  257. Multiple attribute design that need to be searchable
  258. Multiple attribute design that need to be searchable
  259. Strange join in query
  260. Displaying records in new line
  261. Sql Server 2005 Replication
  262. does this backup sequence commit all data to the database
  263. Sql Inner Join/Union
  264. SQL problem - a variation on outer join
  265. if condition in stored procedure
  266. BACKUP LOG questions
  267. Common data
  268. Could not execute a package by a scheduled job
  269. dbcc shrinkdatabase
  270. Testing
  271. DB Structure Advice - lots of measurements in DB or file refs?
  272. programmatically stopping and starting transactional replication
  273. login failed
  274. Data loss importing from Excel
  275. Index on field length
  276. transaction log
  277. How do I number an output field consecutively?
  278. Selecting criteria from SQL DB
  279. How to convert a number to Hour:Minutes?
  280. Database management and latest updates on SQL server
  281. Downloading database from server on client machine
  282. Re: [ANNOUNCE] Release 1.3 of Mogwai ERDesignerNG available
  283. Escape [] characters in an sql query
  284. Edit/Rename attributes with many tables from excel file source
  285. SubQuery Question
  286. Match two tables.
  287. Cursor among several databases
  288. Alter Or Create Procedure?
  289. design issues with large amounts of data
  290. SELECTing from a DML statement
  291. Mulpliplcation of all values in a column plus converting negative values
  292. Reporting Services close download interface without exporting
  293. Stored Procedure
  294. Using UPDATE to sequentially abbreviate address information
  295. Faster way to check if a record needs updating
  296. SQL caclcualted field
  297. Odd character appended to data
  298. Datetime import/export issue
  299. Dynamic ORDER BY
  300. Yellowfin Business Intelligence Release 4.0 Announced to Industry
  301. SQL Permissions
  302. Sql query date problem
  303. mSQL + Perl = Phantom rows
  304. SQL Query Assistance
  305. slow queries for a particular database
  306. sql agent JOB to Backup Database and Maintain Backup Files
  307. Need a script to recreate scheduled jobs
  308. Help needed for Data formatting.
  309. How can I do that using a trigger
  310. Foreign key
  311. OLEDB configuration when deploying multiple SSIS packages
  312. Variable database name in stored procedures
  313. Crystal reports
  314. Decimal point and comma
  315. Re: Stop hotlinking to a specific file & keeping a counter
  316. Please Help - Can't check for duplicates
  317. Deploying an app with SQL Server (installation on client machine)
  318. How to secure a database ...?
  319. GROUP BY a computed column
  320. Can I search for a string in a set of stored procedures?
  321. Creating a database from set of TSQLl files
  322. Storing BLOBs outside database
  323. Concatenate in MSSQL
  324. Re: Grouping by Day for a Date Range
  325. table naming convention about this case..
  326. Re: Duplicate Tests - Help Please
  327. Question about recompiling a dll
  328. Latest updates on SQL server 2008 tools and techniques
  329. Computing a column that is a percentage of the sum of another column
  330. Database security (non-existent?)
  331. Tool to chase down the consequences of adding field to DB tables?
  332. Applying tranaction log to old data file
  333. Re: Database naming conventions?
  334. Latin1_General_BIN comparing two char strings
  335. alter table query not working after working at least once. MS SQL2000
  336. Re: Database naming conventions?
  337. Re: Database naming conventions?
  338. Transact-SQL for Restore Filelistonly using a variable
  339. Differences between relational DB and warehouse ?
  340. Kuljetusalan ongelmista
  341. bcp out in UTF-8 format
  342. Toad for MSSQL problem: closing script file doesn't "release" thefile?
  343. Basic SQL Statement Question
  344. tbl_A CROSS JOIN top 1000 rows of tbl_B?
  345. bcp out empty string into csv files
  346. C++ API for SQL Server?
  347. stored proc with datetime
  348. Performing multiple bulkcopies for different tabels
  349. SqlBulkCopy.WriteToServer() blowing up on tables with Identitycolumns
  350. SQL 2008 EULA and pricing
  351. Forget about Referential checks??
  352. Re: Not finding GUID value after migration sql 2005 to 2000
  353. database design
  354. Re: Not finding GUID value after migration sql 2005 to 2000
  355. DB migration
  356. bulk insert in clustered index table
  357. Re: Vaalirahoitus (oli: Re: Irlanti pelastaa Suomen)
  358. Newbie basic questions
  359. Anyway to declare and use variables in a View
  360. HCL, Aricent, Infosys and many more companies hiring fresh &experienced engineers ,
  361. Migration of an Access Database. How is the best way?
  362. Select from a access table
  363. MSDE upgraded to SP4 but showing SP2
  364. Problem connecting to SQL Server from Access Database
  365. simple SQL engine
  366. Fuzzy logic for duplicate identification?
  367. Convert Int to Date
  368. database owner?
  369. Full text search in albanian
  370. IF within SELECT
  371. live online training
  372. stored procs
  373. Re: "Maksanhierontalaite" ; )
  374. Problem With View and Changing Field Length
  375. Snap-in failed to initalize.
  376. Compound vs Simple Indexes
  377. Looping Through the Records returned from a DTS Lookup
  378. Not an ad hoc query?
  379. Re: Ruuska
  380. Stored Procedures and Commiting Data
  381. Re: search pyrkii nettiin
  382. Dell c610
  383. Connect problem
  384. Using Case within Select
  385. SQL Server 2008 - Filestream
  386. SQL 2005 report deploy issue
  387. Is this a correct table structure for my database?
  388. How to find if instance is cluster or non-cluster
  389. Error running DTS script in VB
  390. SQL->RDF? Best question about semantics technology wins admission to LinkedData Planet
  391. Need SQL Server Dasbase Admin
  392. How do do a query against hardcoded row values
  393. simple ALTER Table query question...SQL 2000.
  394. Disabling Triggers
  395. Update Query Runs Forever
  396. Installing sql server 2000 on windows server 2008
  397. Re: Outer joins in MS SQL 2005: why is it this way? better yet, any resources on these nuances?
  398. How to sell sql skills? (Need your knowledge and thoughts)
  399. Problem with joins in SQL.
  400. (Newbie) Join problem.
  401. Re: Connection pooling issue with pass through queries
  402. where do I download sql odbc drivers from?
  403. Re: Connection pooling issue with pass through queries
  404. Join zero padded char to varchar
  405. Re: Strange select
  406. Re: Strange select
  407. Re: Need Help With an Update Script
  408. strange Problem
  409. SQL Server 2000 UDF Intermittent Slow Execution
  410. your thoughts on this please
  411. Sysmergesubscriptions question
  412. examples with SS2008 -xEvents?
  413. Need Help With an Update Script
  414. select from two tables
  415. SQL Server Browser service?
  416. Help with an Update Statment
  417. delete a named instance - how?
  418. Strange connection problem
  419. Where's my instance???
  420. Install new instance...
  421. Simple Query Question
  422. DBMS advantage and disadvantage
  423. Rename Default Instance Name SQL Server 2005
  424. Cannot Read Varchar(max)
  425. relocating Outlook Business Contact manager
  426. confusion over indexs via primary key and clustered index
  427. SQL Excel - freeware add-in for excel
  428. Link to external file
  429. Modeling/Constraint question
  430. Email Generation from within SQL/Server 2005
  431. Re: SELECT Optimalization
  432. Best pratices to manage the "same logical" database on multipledatabase engine types (postgreSQL, SLQServer, etc..)
  433. Help with SQL Backup Problem
  434. syscharsets unicode
  435. I want to update the column in a table based on the updation of theother column in the same table
  436. DTS Transfer Data Task - output to text file with field names infirst line
  437. Checking for duplicates in a database table
  438. nested stored procedures and returning lots of rows
  439. firewall rules for SQL Server
  440. Modifying registry information to change type of login logging
  441. Suggested DB Reverse Engineering tool...
  442. Cursor and Procedure
  443. select from row1 to row n
  444. Local Security Policy - Restricting Access
  445. Reattaching database - identity_insert set to off
  446. Most Helpful Professional Award
  447. Cross Database Select
  448. Merge process could not update the list of subscriptions
  449. a and (b or c) better than (a and b) or (a and c) ?
  450. caching table Problem
  451. How to return a Pk value from one stored procedure to another storedprocedure
  452. create dynamic variable in procedure
  453. Advanced SQL Cubing
  454. Re: Display duplicate rows
  455. SQL 2005 on Windows Server 2008 - Slow Connection Time
  456. Re: comp.databases.ms-sqlserver
  457. Help!
  458. Urgent: Deciphering binary code executed against the database
  459. copying row from same table and adding value from form.request
  460. Altova v2008r2
  461. Doing a SELECT INTO using a Stored Proc as the data source
  462. SQL Statement Problem : Separate long varchar into word seqments 35chars long
  463. Setting SQL Server Agent Account without being part of a domain
  464. Limiting table access using stored procedure.
  465. optimal selection of all records for a certain month (illegal datesOK?)
  466. SQL Select All Items where one meets the criteria
  467. updating multiple columns with subselect
  468. Selecting several types
  469. Prevent Excel and Access access to SQL 2000
  470. Disable and Rebuild or Drop and recreate Index
  471. Read HTML File though Network for Email.
  472. How to implement Audit/Alert for Row level access?
  473. Force protocol encryption on hosted database
  474. Orphaned tupels, should I clean or is it ok to leave?
  475. ASP.NET 2.0 not connecting to SQL Server (not web.config)
  476. Full text indexing scheduler SQL Options
  477. SQL and Database Design newsgroup
  478. Client applications
  479. Help with bbrowser cell focus ?
  480. Re: SELECT * vs SELECT col1, col2
  481. COLUMNS_UPDATED() with triggers
  482. Conditional data copy SQL Server to Oracle
  483. Can you tell who last edited a SProc, and when?
  484. Re: How to show Median in a GROUP BY clause? (AVE works, Mediandoesn'
  485. beginners question...
  486. Select date in british format
  487. Why freetext query become very slow all of a sudden
  488. Select CASE returning NULL value
  489. back up jobs, re-index question
  490. MSSQL - MySQL
  491. capture and save running sql query to database table (for logging)
  492. How to recover deleted records?
  493. file crawler
  494. Performance question concerning varchar(max)
  495. Use of having with additional select
  496. design question - type heirarchy with supertype queries
  497. using LEN to find a first word greater than 17
  498. exporting a table with long field names to Access
  499. Job ends successfully even when it's not true
  500. Yet another basic SQL question
  501. FAQ & Solution: How to generate a number automatically for thePrimary Key when inserting a record?
  502. copying data from one server to another
  503. Basic SQL Question
  504. Another new DBMS
  505. CHECKSUM to determine record changes
  506. How to find records with length greater than 17
  507. first minimum date in the column for each distinct column a value
  508. Re: Get rows whose sum matches a value
  509. The Sql ranking OVERture
  510. sp_prepexec syscomments?
  511. select parent records that do not have a particular child
  512. how to create my own primary key which auto-increment
  513. Re: Get rows whose sum matches a value
  514. Re: tempdb size question
  515. Re: HELP WITH SELECT STATEMENT PLEASE
  516. SQL Server 2005: functions become slow after a while
  517. How to get the sql statement of a view? (by running a query or from ado.net)
  518. Granting permissions for a user from another database
  519. table trigger just hangs
  520. Login Seems OK but doesn't behave correctly
  521. Dump table as INSERTs
  522. SQL Server Management Studio
  523. SQL 2005 XML Searching
  524. Query Japanese Text in an NVarChar?
  525. Performing Bulk Load of XML Data
  526. import ADO DLL
  527. case-when error
  528. Secure Auditor, 30 security tools at the price of one.
  529. Secure Auditor, 30 security tools at the price of one.
  530. Finding "missing" rows
  531. Login failed for user 'sa'. Reason: Server is in single user mode.
  532. Connection String on shared server- Almost there but need a littlehelp
  533. Please recommend SQL book with excercises
  534. Re: T-SQL Duplicate Record Help
  535. Re: default value wich is not in DDL.
  536. Handle Triggers in MS Access 2003 with SQL Server as Back-End
  537. Calculating Opentime between several records.Using SQL Server 2000.
  538. Calculating Opentime between several records
  539. How to compare date,month,year
  540. Counting days in date fields
  541. SQL Query Email
  542. How to get Last Thursday Date
  543. Xml Bulk Load in SQL 2000 relationship error
  544. Suffix in dates
  545. Order of Triggers in SQL Server
  546. How to list all servers of MS SQL server?
  547. How are parameters passed in Triggers?
  548. Number of Queries in Stored procedures...in SQL Server
  549. SQL Query to select top 10 records except for the top 10 records
  550. Getting specific dates in SQL