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