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