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. data length more than ...
  2. How to convert lower case to uppercase through INSERT query
  3. Problem with connection String for remote mssql Server
  4. performance tuning of stored procedure
  5. Store unicode
  6. Performance : Stored Pocedure taking more parameters
  7. Using SQL Scripts at runtime
  8. Split multirow resultset to single row, multicolumn resultset
  9. to generate all the dates for a given month and year..
  10. connecting to analysis server
  11. Retrieving data from database and displaying it in text box
  12. Help Using DTS to import multiple tables into Access Database
  13. Group By Problem
  14. Referencing a field in another table as part of a formula in a computed column
  15. VarChar being truncated.
  16. SQL division of cumulative totals on one select statement
  17. Want the number that passed the first time.
  18. SUM function adding two fields in one table
  19. Merge data in SQL Server databases
  20. PLS-00201 Error
  21. Excel Query to SQL Server and data type manipulation on SELECT
  22. stuck again, if else after where clause
  23. importing a database into ms sql server
  24. SQL Server Problem
  25. Update Status Field after Expiry Date
  26. Bulk insert error -- "Unknown version of format file"
  27. aggregation or what?
  28. SQL 2005 automatically partitioning?
  29. Full outer join issue
  30. SQLAgent 2005 SP1 failed to run .bat file.
  31. synchronize the database
  32. urgent deadlock problem on Sql Server 2000
  33. Trigger to update a master table
  34. Converting string to unicode string in T-SQL
  35. what are isolation levels in sqlserver
  36. hi
  37. How can I join your Group
  38. store and retrive audio file from/in database
  39. Concurrency Issue
  40. DB Maintenance Plan SQL 2005 on 6300+ Database
  41. Transfer data using SSIS
  42. how to update two table writing only one query?
  43. directly deleting sql view
  44. Crystal Report sub-report expert advice needed.
  45. newb - mutiple-column join
  46. Group SQL Select Statement
  47. Indexes on SQL Server 7.0
  48. Syntax error in the proximity of GO
  49. views not updateable
  50. Service Broker with offline application
  51. error connecting to sql server 2005 from a small c++ program
  52. Online Connection between Access and SQL Server
  53. SQL stored procedure returns duplicates
  54. dbmail failing
  55. bi-directional mirroring
  56. Attaching data at differnet levels in a heirchy
  57. I hate MS Management Studio Tabs, IS IT THAT HARD to fix.
  58. maximum from columns
  59. sql server
  60. Can I Use If Condition In View
  61. xml into mssql 2000
  62. Clarification on Joins
  63. Database table data modifications with PK/FK relationship
  64. help with parameter in WHERE
  65. cascading parameters in sql server 2005 reporting services
  66. Table name starting with prefix tbl
  67. Remove spaces in a column
  68. Senior Database Administrator, Toronto, Canada
  69. install SS 2005 on win2k3 ENT or STD, which is better??
  70. Using count() across multiple tables
  71. delete syntax
  72. Accessing external data from SQL Server
  73. sql server 2000 remotely
  74. Comparing two databases
  75. Converting Rows to Columns
  76. Converting Rows to Columns
  77. Mentored Learning
  78. XML, schema collection and "large value types out of row" problem
  79. shows all the months in the result
  80. Server is not responding.
  81. Sub-Query / Cross Join / or something else?
  82. Complete Newbie Help
  83. Procedure
  84. max no of rows which can be updated in a table which is replicated ?
  85. Multiple db query call from within different context into #temp table
  86. How to debug sql programme
  87. Quick SQL Select Statement ?
  88. Data Feed / Make / Model Catalog
  89. Help needed creating select statement
  90. user defined type as a primary key
  91. which is the role with minimum permissions including a one to execute jobs.
  92. Database error
  93. help to store audio file in database
  94. nulls
  95. Which is fater to search NUMERIC or ALPHABET
  96. SQLServer Login as sa vs dbo
  97. Access 2k adp
  98. Append Query from Access to SQL Server
  99. Date query help
  100. Connecting PHP to MSSQL 2000?
  101. MSSQLSERVER trying to load deleted extended procedure
  102. Help with Select and IN
  103. Inserting foreign keys
  104. C# to SQL Recursive CTE Translation help
  105. I cannot view table content in MS SQL Server Express
  106. Updating 2 tables
  107. Europe syntax for desimal
  108. Updating two different dbs once with same data
  109. Transaction not rolling back
  110. How to create a .BAK file
  111. SQL query in an ASPX "Expressions Web" page to a database (beginner)
  112. Find a newly inserted record from table without using MAX or TOP
  113. Date Format in MS Access using a query
  114. Features in 2005 that work in Compatibility Mode 80
  115. Change connected user to avoid owner prefix in queries
  116. JOIN without excluding non-joined rows?
  117. Auto Numbering Rows
  118. Query for Backup Model
  119. StoredProcedure help
  120. Is it possible to avoid a loop?
  121. selecting max and min year
  122. selecting records based on date
  123. Importing text file fails
  124. Cannot find sql express trigger in object explorer
  125. Importing a notepad txt file into SQL 2000 Server
  126. Set a value for identity key
  127. restaurant database
  128. Sql server 2005 Remoting Configuration
  129. sql server 2005 enterprise - Max CPUs
  130. SQL server and MSDE
  131. user defined type as a primary key
  132. Error while saving Maintainance Plan
  133. Dts Problem!
  134. Exam:070-229-An Excellent Resource
  135. Not able to read data from some columns of an excel sheet while using sql server DTS
  136. Case sensitivity in SQL -- ignore
  137. Query help needed
  138. How to spool output in MS SQL?
  139. SQL Server 2000 Install:
  140. How spool the output on MS SQL?
  141. How to increase the default row size in sql server 2000 only
  142. problem while declaring a a cursor
  143. 'Like' withing CASE statement ???
  144. language problem of ms sql 2005
  145. SQL Query help
  146. Wishful thinking: SourceSafe integration with SQL Server
  147. SQL 2005 Backup Problems
  148. SQL 2005 Backup File
  149. SELECT statement returns duplicate rows when a single row is desired
  150. MS Sql 2005 Master DB sysprocess with ASP
  151. Return error with Automated sp date Variable
  152. A Search for SQLFiles
  153. How to show roles with permissions to objects
  154. Configuring SQL Reporting Services for SSL
  155. Restoring a SQL Server 2005 database in SQL Server 2000
  156. How To write a query to get all Names without starting with an alphabet
  157. download pdf
  158. Sql Server - Jobs
  159. Can i write T-SQL statements to skip other job steps
  160. default filegroup for creating indexes
  161. move indexes via ALTER INDEX
  162. how to select 200 first records from table?
  163. displaying something else in results instead of value in DB
  164. Remotely accessing SQL database
  165. Conerting MS Access query to SQL
  166. Scripted CREATE INDEX
  167. Create indexes - own File Group
  168. Increasing field sizes in Microsoft SQL
  169. Trying to add a NON-DISTINCT field to a DISTINCT record set in a query.
  170. SQL field character limit change
  171. pulling ntext values sql server 2005
  172. Identity reused problem
  173. How to Join
  174. Performance of Partition Merge in 2005
  175. CREATE VIEW - script to automate column names?
  176. Sub query as multiline column
  177. connecting problem in ms-sql
  178. SQL Server and Oracle on the same server?
  179. update a field drom another table
  180. Finding the earliest datetime entry, and then updating the database on these reults
  181. Stored procedure limits??
  182. MSSQL 2005 SP2 install error 2259 - what gives?
  183. Possible to run MSDE (2000) and 2005 Express at the same time
  184. Transaction Logs
  185. What is SQL Server?
  186. Incorrect syntax near the keyword 'WHERE'.
  187. A belated thanks to all who have helped in the past!
  188. index fragmentation LogicalFragmentation -how bad is bad - silly question alter
  189. Merge two tables with conditions
  190. How do i connect and operate with data
  191. SQL 2000 renaming columns in tables
  192. Select question
  193. SQUirrel installation
  194. Europe to Test 1000s Chemicals on Millions of Animals
  195. Time based event
  196. Parse fields
  197. Change Tracking in SQLserver
  198. Removing the duplicate rows from a database
  199. how does SQL 2005 store Non-ASCII values and how it will be displayed in VB 6?
  200. Best approach to sending field names dynamically
  201. SQL to combine columns
  202. Incorrect syntax
  203. need emercency help DoCmd.RunSQL Sql error
  204. Partition Merge Performance - Sql Server 2005
  205. SQL Server 2005 Transactional Replication problem
  206. Sql Help
  207. Creating "Cross Tab tables in SQL?
  208. I am trying to convert a MS Access Query to a SQL query and I need help?
  209. Backup of a MS SQL 2000 DB
  210. Trying to get the right registry key through sql script to change listen port
  211. restore differential backup *
  212. Long query rollback - can I rename the table?
  213. restore differential backups
  214. How to increase the default row size in sql server
  215. Shift or Copy Data from Sqlserver to MS Access using Stored procedure
  216. connection Failure - -3709
  217. how to fetch all databases from server
  218. BETWEEN now() - 6days???? AND now()
  219. 2000 to 2005 query processng difference?
  220. How to delete records from 2 tables
  221. Transaction Register
  222. Retrieving an integer value from a database function via PHP
  223. textcopy.exe failure
  224. get value of last item in column?
  225. Simple SQL Help
  226. problem executing dts package using xp_cmdshell in querry analyzer
  227. MS SQL - Copying data from one table to another in two different databases
  228. Updating one table when Insert in other table
  229. Using raiseerror
  230. Urgent Help needed in Sybase query
  231. Query to find Number of Working days in a month.
  232. Triggers 101 - Invalid Column Name
  233. query
  234. Update query from Select
  235. system tables in MS SQL server 5
  236. Most recent meter reading in a database
  237. Problem with trigger
  238. how to recompile / refresh UDFs ?
  239. CXPACKET and contention within TempDb
  240. Help with SQL Server 2005 Publication
  241. insert into linked server problem
  242. Table copy from 1 db to another
  243. Retrieving Day, month and Year separately from the date
  244. Identity range managed by replication is full and must be updated by a replication agent. Error Message Makes NO SENSE.
  245. dbcc shrinkfile
  246. Problems with transactional Replication in sql 2005
  247. SELECT DISTINCT Problem
  248. Delete and update
  249. Recommended:How to get control of you life and time
  250. Real to datetime - how to...?
  251. Unique constraint in sybase
  252. Collation Conflict
  253. Year of the Pig brings good fortune to Yellowfin Business Intelligence
  254. Year of the Pig brings good fortune to Yellowfin Business Intelligence
  255. Viewing events as they happen?
  256. Difference between the querries.
  257. Merge Replication Error: 'Failure to connect to SQL Server with provided connection
  258. Need Help migrating VBA to TSQL
  259. SQL Server 2005 DTS problem: "Error 21776: General Error"
  260. Replication on W2KP
  261. Debugging a stored procedure
  262. Problem modifying out-of-the-box TFS Report
  263. SQL2000 New Index for replication
  264. SQL7 Add new fields for replication
  265. SSIS 64bit to Oracle 10G
  266. How to normalize these relationships?
  267. Grouping numbers
  268. Year, Month, Count on an Invoices Table
  269. Arrays and lists in SQL 2005
  270. cannot exit from if else block
  271. SQL 2005 Database to take to other pc
  272. Something I'm missing with condition?
  273. MS SQL BACKUP problem
  274. Heap table: why 454 rows of two INT columns use 2 data pages?
  275. Recursive CTE Question
  276. Reporting services - SQL server 2005
  277. SP2 Database Mirroring - "The remote copy of database "ABC" has not been rolled forward..."
  278. Write Data to two databases using SOAP/XML
  279. test
  280. how to change the first record go to last & 2nd record have to come to first??
  281. change rowset position at runtime
  282. How to Print Data directly to Text File using Stored Procedures
  283. CASE statement in Store Procedures
  284. Parallel Operation
  285. can any experts pl help me out in insert query..
  286. If statments in MSSQL
  287. Updating SQL 2000 server using VB6
  288. hi , query for displaying data
  289. bp server and e-mailing server lowest price Waiting for u
  290. Access and SQL Server Speed Comparison
  291. Access and SQL Server Speed Comparison
  292. SQL Query - distinct with 2 values
  293. Transaction Log File Compression
  294. SQL 2000 SP4 and SQL 2005 Express Co-Exist?
  295. Incorrect syntax near the keyword 'FROM'
  296. Excel DSN Query
  297. Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!
  298. How to find last record in sql server 2000?
  299. Transfer logins using Dts package - sql server 2000 standard edition
  300. Row_Number Function
  301. SQL Serwer 2005 + HP LTO Ultrium
  302. SQL Server Upgrade Wizard
  303. Client-Server App vs MS Access Data Project
  304. Script to ammend column data
  305. Joining tables
  306. SQL Help with purging old data
  307. Parameters
  308. Stored procedure to create a new database with tables
  309. Does anyone use SSIS for database schema maintenance?
  310. Need help with CONVERT function
  311. How to view all triggers
  312. Accessing which data caused a trigger to fire
  313. How to restore sql server 7 backup to sql server 2000?
  314. table columns
  315. SQL database name Alias
  316. Query regarding Tiggers.
  317. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn
  318. Reading a directory
  319. Help required!
  320. Last Table Access
  321. Stored procedures
  322. millions records archiving and delete
  323. help with a query
  324. SQL mail work around
  325. Problems with SQLXML bulk load
  326. Convert integer to datetime
  327. return duplicate records
  328. sum from two tables with two columns
  329. MS SQL SERVER via C programming
  330. Advantages and disadvantages
  331. How to get values from 2 tables
  332. export/import
  333. Create Table Script Incorrect syntax near 'Collate'
  334. Hexadecimal format .mdf file
  335. Importing DTS package to SSIS under x64 More options
  336. Visual Basic 6.0 + Crystal Reports XI + SQL Server
  337. newbe question: need a way to read in large query with .net
  338. SQL Server 2005
  339. How .BAK files are restored in SQL Server 2005
  340. which driver to use to make a linked server connection between MSSQL 2005 and Access 2007
  341. nvarchar & varchar
  342. maintaining a database?
  343. Is there an issue running SQL 2000 on a 2003 R2 64 bit operating system?
  344. Scheduling an Import in MS SQL 2005
  345. Which implementation will give faster result (Table design to Joins)
  346. faster count(*) or alternative
  347. Sql Query
  348. file share
  349. how many tables a dataset can store at a time?
  350. faster count(*) or alternative
  351. SQL Challenge - how to return a record set starting at a particular record?
  352. Copying .MDF & .LDF files for new server
  353. New database from backup
  354. INNER JOIN between a CLR-TVF and a table returns no rows
  355. unable to specify UNC path for restore through GUI??
  356. Help, did SP1 install work?? SQL Server 2005
  357. Splitting Date/Time Records
  358. Complicated count w/ subquery
  359. constraints across normalized tables
  360. SQL Help
  361. Non integer counting
  362. CASE in a Select Problem
  363. connect to ms sql from C# code
  364. CREATE TABLE and CONSTRAINTS
  365. Remove a character from a string
  366. Hi
  367. calling a php webservice in mssql server
  368. SQL 2005 compatability mode
  369. Current Database Context?
  370. ASP cannot run stored proc until the web user has run the proc in Query Analyzer
  371. SQL error
  372. Query for the first and latest wish
  373. How to run replace on all columns
  374. Methodology
  375. test
  376. test
  377. Return Columns along with MAX Value
  378. Format money value as padded string
  379. SQL statement - INSERT INTO and SELECT
  380. error for sending(saving) data to database
  381. error for sending(saving) data to database
  382. Insert Date as Formatted String
  383. SSIS declare output
  384. Getting an Error while attaching the database using System Architect Enterprise manag
  385. Struggling with date in query
  386. Move clustered indexes to new filegroup
  387. problem with date range
  388. parameterized view in SQL SERVER 2000
  389. How to Union dynamic tables
  390. T-SQL for the following?
  391. Somewhat complex report
  392. Output results to text with formatting
  393. timeout or re-trys.
  394. Replication and Reports
  395. Invalid column name using BCP
  396. Just a quickie..
  397. Restoring the .bak in MSSQL
  398. Iif MDX Strings
  399. Use RTRIM function on TEXTBLOB (text) field
  400. Error for saving data
  401. storage format of image in SQL server
  402. Microsoft Releases SQL Server 2005 Service Pack 2 (PR Newswire via Yahoo! Finance)
  403. Unicode characters (Japanese)
  404. How to run profiler from cmd
  405. What is the best availability and backup solution?
  406. Storing variable values whilst using cursors
  407. Subquery and display help
  408. Is there a Query Analyzer
  409. Help w/ installing SW on SQL server (2005).
  410. Partition Scheme using a function
  411. Stored Procedure, error when executing (
  412. Restore SQL DB with correct logical file names
  413. resetting Identity Seed on change of primary key
  414. Select Statement Issue - Date Formating/Selecting
  415. SQL Deployment tool
  416. Ho Do I Implement Ms Access Dsum() Function Within Ms Sql
  417. My Sql
  418. creating a database link between DB2 and SQL server
  419. Function to return "remaining" of field after it finds a character in the field.
  420. Simple function for returning a character based on search criteria..
  421. SHAPED SQL: Need help!
  422. Int / Int does not give decimal value
  423. Import Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Table
  424. how to take backup through network in MS SQL 2000
  425. Support for Spanish and English language
  426. Stored procedure
  427. SELECT *
  428. SQL 2005 AND SQLXMLBulkLoad
  429. a substitute for UNION?
  430. Returning an existing column OR the scope_identity
  431. SP2 for SQL Server 2005 is out
  432. How can we insert data through triggers
  433. adding the vc express bundled sql server to odbc
  434. Installing Ms-SQL 2000 with Win XP Pro on Stand alone computer
  435. Performance of SPROC changed by dbo. prefix
  436. Best method for inventory insertion
  437. Improving performance
  438. Fresh SQL Server 2005 giving problem in accessing access 97 file through Jet Ole DB Provider
  439. sql server 2000 robo copy
  440. Inner Join on Partitioned View
  441. how to parse a string in mssql
  442. MSSQL and Unicode data
  443. SQL how to view the list of tables in DB, the columns in the table, stored procedure
  444. Ms Sql Server Giving Timeout Expired
  445. SQL Server Runtime?
  446. SQL Server Link Server
  447. query
  448. Question About a Check Constraint
  449. Violation of primay key
  450. Writing SQL Help
  451. sum a table within a table
  452. How to Access MS Access File in Stored Procedure ?
  453. count records in several months
  454. Question on deploying .SQL files
  455. A trick query.
  456. SQL 2005 AND SQLXMLBulkLoad
  457. ms sql server
  458. Connecting Sql Server 2005 on Windows 2003 using ASP local
  459. Full bakup of Data
  460. Change Object Ownership
  461. A list of autoexec stored procedures
  462. T-SQL Gathering fields from a table
  463. T-SQL in Mngmt Studio Express Doesnt affect change- obvious omission?
  464. Possibilities to restore an old database
  465. Sqlserver
  466. Sql Local Server
  467. SqlServer
  468. tempdb is full error in sqlserver2000
  469. Package 'Microsoft SQL Management Studio Package' failed to load
  470. trying to group by two diff criteria
  471. Invalid object name '#temp'
  472. Auto gen record id as alphanumeric values
  473. Encrypting mdf files
  474. Restoring from transaction logs to running database
  475. Where the database is in SQL Server 2005 ????????
  476. Syntax, please :-((((((((((((((
  477. show number of values as % of total records..?
  478. Blobs in SQL Server
  479. Kill connection
  480. Updating Multiple Records Based On Records Returned By A Select Statement
  481. Performance
  482. Whats wrong here?
  483. Sql server process memory question
  484. Put 3 tables with same fields into one
  485. ORA-04091: table is mutating, trigger/function may not see it
  486. cursor in Stored Procedures
  487. Merging contents of one db to another huge db.
  488. Imprting to a parent and child tables from two csv files using dts package
  489. Backup and restore database hourly: how to implement it?
  490. Replace Multiple Spaces with One Space?
  491. export database structure
  492. restoring to a point in time
  493. MS-SQL question about GROUP BY
  494. Delta compression of query results
  495. .BAK extension file ??
  496. SQL Server losing sql code in stored procs...HELP!
  497. need help and advise with database
  498. delete records from one table that occur in another
  499. Urgent Help
  500. cannot write logfile Error 1059 : Circular service dependency
  501. in query, how can I compare string?
  502. Trying To Change Identity On Field W/Data In SQL Manager
  503. string matching in T-sql
  504. Basic Questions
  505. Project Planning
  506. Can't Connect to SQL db
  507. Can't Connect to SQL db
  508. Running access 2000 ap on sql 2005 express edition
  509. How do I use a variable to modify this sproc?
  510. Counting Orders for the Day
  511. specific records returned from 3 views using sql
  512. Getting a best selling brands list
  513. PIVOT query - access to mssql - help wanted!
  514. Order by - testing on true/false
  515. Memory Config (2005 Standard + x64 Win2k3 Enterprise)
  516. scripting data
  517. updating a stored procedure
  518. Link Tables
  519. Java DatabaseMetaData and MS SQL 2005
  520. returning one single record rather than multiples
  521. Callable statements, SQLServer and JRun
  522. Callable statements, SQLServer and JRun
  523. Trigger does not affect the code written in the loop... pls help its urgent
  524. SQL Format Function "0000"
  525. Urgent: MS-BI (SQL Server 2005-AS/RS/IS)-CMM 5-Hyderabad (with possible onsite)
  526. SQL Scripts
  527. Migrating to 2005, need advice
  528. Problem with SQL server 2000
  529. SQL Data concatenation
  530. which one is faster...
  531. Replication to a Custom OLE DB Provider
  532. Problems loading SQL server 2000
  533. vb with sql server
  534. databases
  535. Text Functions in SQL ...
  536. SSIS Import
  537. sql 2005 upgrade problems
  538. Log File is Full error: How to prevent this happening?
  539. Can't connect to SQL Server(SQL Express) in VS 2005
  540. Large number of INSERT statements - not all are executed
  541. Hanging Query
  542. Learning SQL Server with Win XP Home
  543. get record with earliest datetime value
  544. DTS Package Execution (From Job)
  545. Where is my dts?
  546. How to move table data in one server to another server
  547. Convert Access to SQL Server
  548. Inserting wav data
  549. Creating maintenance plan wizard problem
  550. Importing DbaseIII data to sql 2005 using asp Coding