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