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