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. PLS.... Help!!!
  2. calculation of subqueries HELP
  3. memory 64bit windows , 32 bit Sql
  4. Joining two tables keeping columns independently distinct
  5. set default precision on decimal type?
  6. Searching for SQL Servers in AD
  7. PRINT debug messages and CURSOR in stored procedure confuses DTS; "Invalid Pointer"
  8. PRINT debug messages and CURSOR in stored procedure confuses DTS; "Invalid Pointer"
  9. MSDE, SQL Server Replication & Local Admin Rights
  10. convert scientific notation to to decimal
  11. to store pictures
  12. Searching for Last DateTime
  13. How to copy database to another SQL server
  14. Snap-in failed to initialize
  15. union with Rank create duplicated records
  16. Asymmetric communication from ms-sql-m protocol from an SQL Cluster
  17. Problem with a stored procedure
  18. Server Properties
  19. Problem opening Access forms and macros from database residing on a Windows 2000 web server using IIS
  20. help me in retrieving the value
  21. Track the changes to normalised tables and update the denormalised tables depending on the changes to normalised tables
  22. 'Select top 10 * ...' returns data but 'Select * ..' does not
  23. Marketplace: Yellowfin reporting 3.1 with BIRT Integration
  24. Converting Columns into Rows without affecting the data in the table
  25. Column Alias Issue
  26. Authentication Issue with IIS
  27. SQL 2000 Bulk Insert attempt on FTP in progress
  28. Adding text to a column!
  29. sql 2005
  30. SQL 2000 Full Text Catalog problem.
  31. Median?
  32. Exec stored proc from select in another stored proc
  33. select count(table) problem
  34. Error handlig in Query Analyzer
  35. FOR XML PATH + file structure
  36. Any Inbuilt function like Oracle's ROWNUM to retrive the order of records
  37. CASE in WHERE clause?
  38. Views / Performance - 2 Rows to 2 Columns
  39. Import multiple .DBF files w/SSIS - OLE DB
  40. Identifying foreign characters in rows of data
  41. Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
  42. Improving the Performance (Millions of Records!)
  43. CASE in FK
  44. connection of sql server via vba
  45. Error :ITransaction::Commit or ITransaction::Abort was called, and object is in a zom
  46. Working with Ints and Nulls
  47. Simple question about stored procedure
  48. Grouping into a Concatenated String
  49. I got "System.__ComObject", Where is my SQL record value?
  50. Dts and Dates
  51. Append to a field in a database
  52. How To use OLE Control like MS Access on SQL Server
  53. Date formats
  54. Table field merge
  55. How to purge errorlog?
  56. SQL server 2000 and PHP
  57. How i can see how many user using database?
  58. DTS Package issue
  59. Batch Jobs ..
  60. query sql server using xml dynamically
  61. MS SQL 2000 installation corrupt
  62. Connectivity Issues in SQL Server 2005
  63. MSSQL and UTF8
  64. Setting foreign key on insert
  65. LIMIT problems
  66. Need Help Getting the day shift after midnight
  67. SqlServer2005: Transfer Sql Server Objects
  68. To Retrieve date stored in type INT
  69. sql data recovery?
  70. Table Partitioning on a RAID 5 Server
  71. Sql 2000
  72. Update - can I do better statement?
  73. connectivity between sql and vb
  74. 10 Random records, 1 from each category
  75. Enterprise Manager reporting wrong server version
  76. Select Distinct Error ??
  77. Windows authentication
  78. PLEASE PLEASE HELP - How can I get a return value from a SQL Stored Proc is ASP.NET?
  79. Help on UPDATE with EXIST
  80. Create SQL database with C#
  81. Stored Procedure looks at sysobjects and process info in each table
  82. Oracle Sequence/Link 2 MS SQL SERVER 2005
  83. Find 2nd Working Day
  84. to get the structure of the table
  85. Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
  86. SELECT UNTIL ?
  87. Update Deadlocks on Primary Key index
  88. Need Emergency Help with SQL Query (difficulty: moderate)
  89. How to import from external SQL database to local SQL database
  90. "cannot find the path specified" when setting up replication
  91. Aggregate functions and locking
  92. using variable as WHERE clause
  93. Syntax for reading in a txt file
  94. Replication - Multiple Distributors, one Subscriber
  95. Insert a field from a table to another.
  96. Find records that comply with either or criteria
  97. wild characters in stored procedures with parameters?
  98. Design Solution Required
  99. Dts . .
  100. Please I need help with table partitioning in SQL 2005
  101. adding up column values (asp & access 2000)
  102. How do I recover data from SQL Server's log files?
  103. To access real time data from remote server to local DB
  104. Inserting Multiple Rows into one table (with calculated fields)
  105. Fiscal year search
  106. SQL 2000 Replication via Internet
  107. SQL Server 2005 objects question
  108. (Announce) Jonathan Robie Will Present at 2006 XML Conference
  109. Problems with Adding text
  110. Collation setup for SQLServer2000 Standard Edition
  111. UPDATE JOIN TOP 1
  112. Conditional Constraints on table columns
  113. SSL encryption for remote SQL server
  114. import and export data
  115. Continuously querying a datastream using SQL Server 2005
  116. How do I create an Insert trigger to copy a table
  117. left outer join ( =*)
  118. How to Save MS Word/Excel Files in Database?
  119. Truncating or shrinking a 65GB Log File with available 2.8GB harddisk space
  120. are wombats good?
  121. where are wombats?
  122. using vbs
  123. Equivalent to SQL Anywhere GET_IDENTITY?
  124. richie robles
  125. Update Query using XQuery
  126. Some XQuery/SQL Server 2005 help please
  127. Default "Auto Close" to no for entire server?
  128. Select statement
  129. How to export SQL Database properties
  130. Performing mathematical operations on Table columns
  131. DTS Data Driven Query vs. Query Analyzer
  132. Error With EXEC sp_attach_db
  133. Need Help to form the MDX-Statement
  134. Transposing repetitive serial fields into Table structure
  135. Replication
  136. How to get the total time of the records in a table
  137. mssql_connect problems
  138. Cross Tab query in SqlServer
  139. Maximum number of Tables - is 4^15 big a number?
  140. Triigers FOR in Merge-Replication
  141. Linked server and text file...
  142. New to SQl Server
  143. NEW to SQL
  144. DTS - Need to Set Destination Filename dynamically
  145. got an error
  146. help needed to fix an error
  147. Waarde uit tabel incompleet
  148. SQL Server 2005 Database mail Command not supported (502) SMTP error
  149. Which Replication Method To Use
  150. HDD still full after shrinking transaction log
  151. How to build a procedure that returns different numbers of columns as a result based on a parameter
  152. Error 0x80040E31
  153. MS SQL server and (missing) ANSI DATE-datatype
  154. help
  155. CONVERSION FROM CHAR(4) TO DATETIME
  156. Exclusive connection MSSQL2000
  157. Pls Help With JOIN query...
  158. sql question
  159. One Record from many tables
  160. XML Data type storage
  161. restore sql 2000 bak to 2005
  162. Variable in while loop not getting incremented
  163. Permission to create views
  164. Xquery Help SqlServer2005
  165. ODBC database slows down over time
  166. Update Trigger
  167. Insert Data into a table
  168. SQL Active Directory Query
  169. Updating 20 some servers
  170. record locking in MS SQL
  171. User unable to update database
  172. Shrinking database log used for mirroring
  173. Severe performance hit with NCHAR queries
  174. Sql Server Distict
  175. float vs decimal
  176. float vs decimal
  177. Link two tables using union
  178. how to find the unique key and foreign key reference given the table name in MS SQL
  179. Have two identical SQL Servers
  180. Any suggestions??
  181. Database updates (using SqlDataAdapter) during runtime but Database Table Does Not Update
  182. Database Updates During Runtime But New Data Does Not Appear in Data Tables
  183. Manual back of database error
  184. Conflict With Network Communications
  185. Sum hours from the date on this row thruout the rest of the database.
  186. SQL select question
  187. Database Cloning
  188. case insensitive
  189. UNIONs and Running Totals
  190. Export SQL05 data to Access
  191. Create Database using C#
  192. A new approach to storing ordered hierarchical data in RDBs.
  193. How to deploye SQL 2005 Express with my application
  194. login and privileges effect on optimizer's choice of plan
  195. How to Add New Line Character in Database in Ms - Sql
  196. dynamic query
  197. math error
  198. Extending or Linking to ASPNET.MDF?
  199. How is better to get SUM OF COUNTs
  200. SQL Server Installation Error
  201. Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
  202. appending two datetimes which were converted from strings
  203. Clearing up cache selectively
  204. Maximum Date in a group of records
  205. How to Identify an Array
  206. PRINT 1/(1+26)=0?
  207. Microsoft Open Licence Program - What is it?
  208. Getting Data from SS via HTTP
  209. Count Query Question
  210. Help with FOR XML - How do I return the results like this?
  211. SQL Server Upgrade
  212. Insertion Time problem with SQLAIW32.DLL and SQLAKW32.DLL
  213. noise words in my full-text search condition?
  214. Connecting to more Database
  215. HELP... ihow to mport .txt files into sql 2005!!
  216. SQL Server 2000 + 2005 working on same windows 2003 server as seperate instances
  217. how to swap the value of two colum in the same table
  218. SQL express-solving 4GB size limit by multiple database files?
  219. How To Retrive Data If There Are Large No. Of Datas In Table(by Minimum Time Conusum
  220. Configuring SQL
  221. Configuring SQL
  222. Converting database to MS-SQLServer from PostGRESQL
  223. primary key
  224. different database
  225. top 5 rows without top keyword
  226. strings with sql
  227. In
  228. What am I doing wrong here?
  229. SINGLE SQL TRIGGER for INSERT, UPDATE & DELETE
  230. how to script binary data
  231. Yellowfin leads the new players in taking business intelligence mainstream.
  232. Querying 5 tables: SQL using MS query
  233. Best practice for database migration
  234. Help with a complex UPDATE query
  235. Backup Strategy for MSSQL
  236. Optimize query
  237. Databases
  238. How To Retrive Data If There Are Large No. Of Datas In Table(by Minimum Time Conusum]
  239. How to configure a PULL SUBSCRIPTION?
  240. Plz Help me out in this query
  241. import/export utility
  242. SQL Server 2000 Replication problem
  243. Very new to SQL
  244. OLE DB provider "MSDAORA" for linked server "infonet"
  245. How to pass parameters from Visual Basic to SQL Local Package
  246. connection strings problem solution
  247. round to nearest WHOLE number
  248. DTSRUN.exe install
  249. strange results when calling a sql stored proc from within an Access2000 project
  250. Sending a string from a mssql to another server, using the port number and the ip-adr
  251. How to join a table of a local database with a table of Remote database.
  252. Problema Server.-
  253. Problem with WHERE IN
  254. how to use cairage return chr(13)
  255. How to search % in a query
  256. 2005: SSPI library problem
  257. Problem Accepting Null values
  258. database connection with oledb provider for sql server
  259. foreign key to multiple primary keys
  260. SQL tables and relationships
  261. Simple Script to create DB, specify file location and set owner.
  262. Delineating Factors for Code Placement
  263. Grid vs Text output
  264. Select Query - can I use a Pivot table?
  265. Nested Inner Joins
  266. splitting SQL 2000 db into multiple file groups - how?
  267. snapshot agent failure on unknown table
  268. I want to revert back to original state of database before i performed restore database
  269. Reclaim Reseved Space(MSQL) to OS
  270. how to find unknown table name from databas
  271. Converting a file into multiple tables
  272. problem with trusted connection (asp.net)
  273. combine 2 database into one
  274. SQL to calculate surrounding suburbs
  275. Modifying sp_password
  276. Replication merge instance is not find in Performance Viewer
  277. ODBC Excel - SQL 2000 has but not 2005?
  278. Help needded in Sql2000-Triggers
  279. How do UPDATE
  280. Using temporary tables within the stored procedure
  281. Using a temporary tables within the stored procedure
  282. Conversion Of Sql Statement To Db2
  283. COUNT FUNCTION ON MULTIPLE COLUMNS
  284. General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
  285. SLOW performance on table with image fields (SQL 2000)
  286. Automatic Fields
  287. Len Trim
  288. default is NULL
  289. case sensitivity
  290. 200611 to string 'Nov 2006'
  291. T-SQL Question
  292. primary key
  293. UPDATE & INSERT speed improvement question
  294. MS SQL/ADP loses records
  295. Trigger on an Access database?
  296. Multiple col ina single col
  297. Help for Sql Query
  298. How do i find indexes of the columns in SQL server 2000???
  299. Rolling up spans without breaks between them
  300. Some Data from SS2000 to Oracle : Options ?
  301. xp_smtp_sendmail error disconnecting from mail server
  302. Subquery problem
  303. Non-patched version of MSDE
  304. Nested Tables
  305. How To Connect SQLServer Via a Remote Access Service (Dial Up)
  306. SQL Server: How to shirnk the Bakup file
  307. Instance Licencing
  308. FOR XML not working in a subquery
  309. Need help in retrieving distinct from duplicate column from related column list
  310. Using COUNT FUN and CAST
  311. Tuning Stored Procedures, sub-tree cost, cpu time, and reads
  312. SQL database Diagrams
  313. WHERE columnName = 'this' AND anotherColumnName IS NOT NULL
  314. How to loop through this sql table and display in ms access listbox
  315. First Posting
  316. select records between dates - query works in VS 2005 but it doesn't in asp 3
  317. Schema changes to SQL Server
  318. Transfer data from an excel sheet to table in sql data base
  319. Retrieve data using multiple select
  320. How to execute a DTS Via a stored procedure
  321. mysqladmin: connect to server at 'localhost' failed - MySQL
  322. Query Data using multiple select statement
  323. single quote
  324. Among Numeric and Float
  325. Adding a new Column after a particular column
  326. Survey...Please help and respond!!
  327. Actuarial sql statement Need Help.
  328. hii
  329. Please Help With Complex Update Statement Logic
  330. parameters
  331. sql server
  332. ISQL: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ' '
  333. how to store photos in sql server and...
  334. Trim function
  335. how to remove leading tab from string
  336. prevent one single row from being updated
  337. regular expression issue
  338. Help with joining/selecting values to show
  339. Select Unique Distinct records for Column
  340. Select Unique Distinct records for Column
  341. Error on updating/adding record
  342. SELECT Problem
  343. SQL with greatest date
  344. help me in sql server codes
  345. Use of Model database
  346. Changing column values on table insert trigger
  347. Stored procedure issue!
  348. t-sql turn off a cpu
  349. Getting Error code from SqlServer to FrontEnd Application
  350. DTS Package Import
  351. MsAccess/ADP - record source doesn't exist
  352. Return dataset in one column
  353. data recovery, after overwritten many times mistakenly
  354. Please any one try to solve this. its Interesting.
  355. Basic Replication trouble.
  356. decimal problem... help please
  357. Get Data From an open Excel Sheet
  358. Remote SQL Server Backups over Internet
  359. How can i solve this problem?
  360. SQL 2005 & MSDE 2000
  361. Copy databases from SQL 2005 server to SQL Express
  362. help needed
  363. BETWEEN returns invalid data
  364. SQL Query Analyzer
  365. Getting back set order from the IN param
  366. Hot to inser row in a table
  367. sql server 2000 cluster issue.
  368. Connecting to an SQL Server using a workgroup
  369. Databases in SQL Server
  370. what does this (+) do?
  371. MSSQL Replace() for first occurance?
  372. creating a database in SQL 2005 - using windows 2003
  373. Problem with IN statement in Stored Procedure
  374. HELP - need a function like MID in access
  375. Embedding sp in to one transaction
  376. using trusted connection from unix
  377. LEFT and string function
  378. SQL query filtering date field by today's date?
  379. get 5 latest invoices (based on InvoiceDate) for each customer.
  380. Lock Problem and application is slowed down
  381. Datetime output diffrent in C# and MSSQL
  382. Connecting to 'localhost' Problems?
  383. importing blobs and other monstrosities from oracle 10g to sql server 2000
  384. looking for beta testers: new SQL comparison tool
  385. Publisher is empty under Replication Monitor - Publisher.! But replication is still running fine..
  386. MAX(DATE) - help
  387. convert / group by date
  388. SQL 2005 -- export table to a "fixed width" flat file -- Posting again
  389. where DTS in SQL 2005; Oracle to SQL2k5??
  390. Sql 2000 Replication
  391. Percentage returning 0 values
  392. Low process speed Large scale storage question...
  393. Tricky group by date problem
  394. query to find a sum of char values present in different rows
  395. Can't connect to SQL Server from Novell workstation
  396. Point in Time Restore
  397. Execute Extended Stored Procedure in user defined function
  398. .
  399. Stored Procedures and Functions
  400. Problem with executing DTS package !
  401. Runnable master awaiting command
  402. Create and then USE a dynamically-named database?
  403. FoxPro vs. SQL
  404. Trouble with Informix datatypes
  405. SQL 2005 & Login Triggers?
  406. Too Many Columns Found in current row
  407. How do i update I record in a table via a Trigger?
  408. Merge 2 queries
  409. SQL views
  410. Direct Client - Long term project for C#,SQLServer, ADO.NET in NY/NJ/PA, US
  411. CASE Help
  412. Database Migration
  413. Comparing Database Data
  414. setting up witness on SQL SERVER Express
  415. SQL 2005 - Export table to a fixed width file.
  416. Encryption keys for Reports Server
  417. Linked Server
  418. Importing text files - DTS help needed
  419. Query related to SQL ERROR
  420. URGENT Connection Ctring help!
  421. Need to declare multiple values
  422. Weird errors when trying to insert with IDENTITY_INSERT on!
  423. Precision Problem
  424. CASE: cannot test for empty string
  425. How to convert binary data to string?
  426. 3 / 2=1? Strange result in expression...HELP!
  427. ACCESS ADP TransferSpreadsheet
  428. Running a DTS with parameters
  429. Selecting TOP X child records for a parent record
  430. Help: Stored Procedure performance issue.
  431. How to Update 1 field with the value out of another row
  432. Indexing on UniqueIdentifier type column
  433. Urgent, Time out Expired/ need something to do from SP itself...
  434. index tunning
  435. SQL Server Client
  436. SQL Scrip help
  437. SQL Web Service Stored Procedure
  438. SQL 2005 CLR run out of memory.
  439. Filters on the data
  440. Filters on the data
  441. Trigger issue on Mass Insert/Update
  442. Import Specs
  443. SQL2005 - don't see my database when I use VPN-connection
  444. Sequential Number in an Update
  445. 2005 connecting 2000 ?
  446. view works, but the sql from the view does not
  447. use variables in WHERE doesn't work?
  448. remote desktop and db performance
  449. SQL 2005 express and linked tables
  450. How to load jpeg file in SqL2000 and how to retrieve from SQL2000.
  451. DBCC Memory Status and Query Plan
  452. move/upgrade MSDE to SQL 2000
  453. MIGRATING
  454. database analysis
  455. Duplicate rows in the Dataset!
  456. How Can I Ignore Accsents and diacritical marks in WHERE statement
  457. how to get the time a table was analyzed in sap db ?
  458. Copy Database Wizard across domains?
  459. SQL 2005: Unable to edit linked table records
  460. use IF in WHERE clause?
  461. TOP N Value per category
  462. Encryption of SQL Express database with password
  463. Error after upgrading from MSDE to SQL 2005
  464. Help with a query
  465. How to find query plan for a stored procedure using temporary tables
  466. Return subquery rows as one delimited column
  467. Migrating from JET to SQL Express database - Using Deltek and MSAccess softwares
  468. How to exit from script when find one DB does not exist?
  469. Question on scripting
  470. Data Execution Prevention (DEP) - SQL Server 2000/2005
  471. simple way to convert '1900-01-01 17:12:00.000' to 5:12pm?
  472. Scrambling sensitive data
  473. reference an outer column from a sub query
  474. DBF file export issues onWindows 2000 SQL server w/ DTS/ SQL 2005 with DTS
  475. using PK as Field Name?
  476. .NET 2.0 and .NET 1.1 co-existence?
  477. What am I doing wrong here?
  478. The best methodology to test load script
  479. this is very urgent,please help me
  480. Passing a parameter to views
  481. ExecuteScalar returns null
  482. Posting Guidelines
  483. two versions of sql on one server?
  484. Query autocomplete in SQL Server Management studio?
  485. Help with an update query
  486. Grouped rows inserted into columns
  487. Defining Database with Local Variable
  488. use INSERT INTO with a VALUE which a variable
  489. Duplicate Column
  490. how to load old datafile
  491. SQL Server Sizing - Hardware requirements for SQL Server 2005
  492. ComboBox items from a column in a database table!
  493. Installing SQL server 2000 on windows 2003
  494. Generate SQL Script
  495. Enterprise Manager takes 10+ min to open
  496. Restoring multiple transaction logs
  497. Order of GROUP BY - does it matter?
  498. If Staement
  499. Use array in SQL 2005?
  500. I have a basic question about SQL server
  501. Simple beginners question about stored procedures
  502. Testing load scripts
  503. Monitoring Inserted data and comparing against selected data
  504. Import Excel file into SQL Server
  505. Group By Query Casues TimeOut Error
  506. Query with Group By Causes TimeOut Error
  507. Group By Query causes TimeOut Error
  508. Possible Bug in SQL2005 query?
  509. triggers to transfer to other db
  510. Need your help to remove spaces in the column entries using SQL
  511. ASP SQL installation error problem
  512. Variable in a string problem
  513. Simple update query is making me lose my mind...
  514. SQL Script to find User Names in User Databases
  515. How to run a SQL script from within a VC# code?
  516. making JOINS
  517. Accessing specific records
  518. reindex
  519. SQL Reporting Services
  520. need help on store and compare time?
  521. Store procedure doesn't work for web application.
  522. How do you conditionally fire a trigger (mimic replication)
  523. No Local instance with SQLServer2005 Dev. Ed.
  524. communicating msde with sql ce for pocket pc
  525. Progress DB to MS SQL Server 2000 Sync (Copy) Delay Problem
  526. Need help in writing a VB Script in DTS to establish relation with WMI resources
  527. unable to run mysql server 5 on windows
  528. Making Connection to SQL
  529. Query Problem in Access
  530. retrieve data from 4 tables
  531. MSSQL insert into data conversion problem
  532. Coalesce / Comma Delimitted List
  533. How to combine 3 SQL statements into 1?
  534. SQL 2000 Text Field Problem
  535. JOIN / subselect problem
  536. Sql server Enterprise manager
  537. deleting a backup device
  538. Modeling
  539. Ansi Padding
  540. Ansi Padding
  541. Running a SQL server 2005 job remotely thru an AS400 program
  542. Migration from SQL 2000 to 2005
  543. SQL Server 2005 - SELECT query
  544. Learning about Indexes the Hard Way
  545. SQL statement to compare and return one aggregated value
  546. sql statement to select customers contributing top 60% of sales
  547. What is the best way to store a shopping list or order?
  548. SQL Query return unused values
  549. Moving from SQL 2000 to 2005
  550. Delete Column