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