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. import data from .rpt file to SQL Server 2005 UsingSSIS
  2. Number Of Connection In Sql
  3. Backup plan reccomendations for user with ZERO experience.
  4. Executing SQL Stored Procedures in VB
  5. Stored Procedure from Application_start
  6. MS Query - how to filter by date range
  7. Left/Outer Joins
  8. how to merge two rows with only one unique column
  9. Store Procedure - Dynamic Insert
  10. Replication SQL Server 2005 - PostgreSQL
  11. I have a large database that needs editing
  12. Convert Character Type Date to use DateDiff function
  13. SQL Server database crash/hang issues HELP
  14. Using bcp_collen and bcp_moretext
  15. how to store byte array in SQL database
  16. Restore database with no log
  17. query Oracle -> sqlserver
  18. Nested Tables
  19. how to open two cursor
  20. SqlServer2005 installation
  21. SQL 2000 BackUp files not supporting to restoring SQL 2005
  22. Restoring SQL 8 .bak file to SQL 9 won't work
  23. Error in Insert from excel sheet
  24. Restoring from Backup without logs
  25. Temp Table vs. Union: Which Has Better Performance?
  26. Insert/Update SP
  27. Add ruuning count to SQL Query
  28. Daisy Chain data sqls extraction
  29. generating sql server reports
  30. Update trigger doesn't fire when inserting multiple rows
  31. Change Nofitication
  32. Index Performance
  33. Same Procedure for different database
  34. INNER JOIN - INSERT
  35. Linked Server Headache (Access)
  36. Using SUM and GROUP problems
  37. writing an sql query
  38. Trigger modification
  39. Log shipping in sql server 2000
  40. index
  41. Can we use multiple update Stmt in Single Stored Procedure ?
  42. FA - MS SQL Server Certification Trainers
  43. SQL Server 2005 sysadmin, error 15151 problem
  44. Rounding Down in a query
  45. Stored procedure question
  46. how can i know execution stutus of a stored procedure
  47. xp_cmdshell access denied output
  48. Saving data to SQL Data Base
  49. Using a range on Postcode in sql
  50. Excellent oppurnities in 'Bootstrap Technologies"
  51. Excellent oppurnities in 'Bootstrap Technologies"
  52. how to implemented order by in time
  53. Collations?
  54. btrieve to mysql
  55. Index Monitoring
  56. Why does SQL calc float dates different than Excel
  57. Need Help Regarding Sql Server
  58. A puzzle "merging" XML attributes in an XML column with dynamic SQL,XQuery, and XPath
  59. Transaction Query - Not rolling back on step 1
  60. Using sql to execute a batch file
  61. DeadLockError On Indexes
  62. Impoting Multiple Flat Files to Multiple Tables
  63. Stepping through Results
  64. Importing RPT file to SQL Database
  65. Multipling Rows
  66. Newbie trying to write a server side variable
  67. SP to parse string adding synonimes from table
  68. Insert after running Select query in Stored Procedure
  69. sql server -- result wants into txt file or exel file
  70. Retrieving Search Results from an SQL Query according to a certain Logic
  71. Call a Stored Procedure in another server
  72. Bulk Insert Excel into Sql Server
  73. Need help linking userID fields
  74. Number of connection to a database
  75. DTS Issue - please help!
  76. Deadlock Issue when dropping/creating tables
  77. Thesaurus Search - How to update the XML?
  78. Retrieving Last 'N' records from a Table in the Database
  79. Full-text indexing failed after DB move
  80. Needed: SQL DBA/ 12 Months / WA
  81. Shopping Cart and Products relationships
  82. Export the Data from Sql to Excel sheet used DTS
  83. MS-SQL store procedure to standard diagrams
  84. Need Query help
  85. Running Store Procedure as Integration Service
  86. importing database from access to sql2005
  87. required help
  88. SQLException No ResultSet set was produced
  89. SQL Server 2000, Requesting database properties lock up enterprise manager
  90. Multi-column Index vs Single Column Indexes
  91. Error on Returning More than 1 Value
  92. PolyServe DB Utility for SQL Server
  93. Authentication in SQL Server
  94. Export data to CSV or Text file
  95. Overwrite SQL exported Excel sheet with new data
  96. Data tranfer from Excel to SQL enterprise manager
  97. How to search a dates earlier than January 1, 1753
  98. SELECT SCOPE_IDENTITY() problems
  99. Query to return certain result if meet requirement
  100. Insert Excel Work Sheet to Existing SQL Table
  101. query
  102. Join two tables of different database
  103. Inserting New Field to SQLServer Back-end via MS Access Front-end
  104. Remote Exec of DTS MS Access Data Pump Task Returns Dreaded 80004005
  105. search within string
  106. SQL newbie needs help automating query to send via email
  107. SSRS Help
  108. Comparing Two Values in the same Table
  109. Issue selecting two rows from two columns
  110. How to do a like ... or statement
  111. How to write a sqlquery using joins which has 4 tables.
  112. Need to transfer many DBF files, while editing them at the same time
  113. Italic
  114. How Do I Block Port 1434 - Need Simple And Clear Answer
  115. dts/ sql server 7.0
  116. Need help fast
  117. microsoft SQL Server, Error: 500
  118. Need help with Query
  119. Most common connection method to SQL 2005
  120. Sql Server Error 80004005
  121. How can i access a column and put it in select tag of html ?
  122. Help with MS SQL Query
  123. week of the month
  124. What version of SQL Server to buy?
  125. Sql Trigger Problem
  126. New to MS SQL
  127. Trouble with Script - Adding column to current table.
  128. Managing Remote SQL Server from Server Express
  129. Formatting reports in SQL PLUS
  130. Install MS SQL Server on WinXP
  131. Paging in Sqlserver 2000
  132. Sybase info.
  133. SP - Convert CSV to a Link table
  134. Convert month No into its number ..(Ex. 1= Jan,2= Feb...)
  135. Please Help
  136. rowdelimiter not accepted in bulk insert statement , used in an sproc - please help
  137. Problem with SQL on same server as web server
  138. Examination 070-229 Resource
  139. Problem with migrating huge tables from MySQL database.
  140. TIME DIFFERENCE in SQL
  141. query
  142. sp_executesql Error Trapping
  143. DTS Package (Dynamic Properties Task).
  144. DTS Package (Dynamic Properties Task).
  145. DTS Package (Dynamic Properties Task).
  146. Error in SQL SERVER LOG
  147. Use of large field definitions for small values
  148. Numeric value only for a character field
  149. restore the dts
  150. Sql low performance
  151. Subquery returned more than 1 value. This is not permitted when the subquery follows
  152. Help with aggregate functions
  153. help with sql select
  154. restore database
  155. Mssql
  156. SQL statement query help with Date
  157. Join Sql Table and Excel Sheet
  158. Converting multiple values in form of comma separated string
  159. hide/show report in report service sql 2005
  160. how to see the data of variables in SQL Profiler
  161. output parameters from row with max id
  162. table name as parameter
  163. Removing Nulls
  164. Still need more help
  165. BCP help needed
  166. Week Number In Loop
  167. SELECT DISTINCT will always result in a static cursor
  168. Need Advice on Really Big Databases
  169. Problem using aggregation in MS SQL
  170. navision vacancy
  171. SQL Server equavelent Boolean values
  172. sql server basics
  173. use count & group by with union
  174. Parsing Abstract Files.
  175. DTSRun error
  176. how to get last processed date of a stored procedure
  177. Problem with cursor using DISTINC
  178. Why XML Output is Truncated
  179. need help to create a connection with sql server
  180. Copy table to Remote SQL server using DTS
  181. Help on DB Design
  182. Joining two tables to modify a tree structure
  183. SQL Server 2000 while browsing another server in EM databases shows "No Items"
  184. Error in DTS
  185. transactions
  186. calculating total time using datediff()
  187. How to copy data from a table in one database to another database using sqlserver2005
  188. insert data to the database problem
  189. Shrinking my transaction logs
  190. ' marks and sql trouble
  191. Dynamically Modify the Datepart Argument of DATEADD function in T-SQL
  192. Announcing beta_lockinfo
  193. Instead of INSERT trigger!!
  194. SQL Primary Keys and SET
  195. MS SQL IF ELSE condition checking
  196. zero filling
  197. Passing variables to an SSIS package
  198. Manipulating Data
  199. Ntext limitations??
  200. Kerberos setup on windows 64-bit SQL Server 2005
  201. Exporting SQL column to excel
  202. Read Only Files
  203. Infopath loses query fields to SQL Server
  204. Count diferent variables
  205. read from a temporary table
  206. sql server connectivity with turbo c++
  207. Which general SQL NG is more active??
  208. CSV --> SQL and CSV <-- SQL
  209. (SSRS) Generate SQL by automation?
  210. Set variable to value in column
  211. Query for Last Date in a table
  212. Add last two values
  213. Deleting all data
  214. general question
  215. Querying Active Directory from SQL Server 2005
  216. "SQL Server does not exist or access denied" & "Timeout expired"
  217. Loop Statement to compare two tables
  218. Can I manage MSDE with SSMS??
  219. "LIKE %" AND "@PARAM"
  220. MS SQL return Min count homeMDB
  221. Help on trigger - work for update but not inserted
  222. Full Text Search
  223. I need basics of innerjoins
  224. Help with SQL Statement
  225. If exists update, if it doesn't exist create
  226. How to make DLookUP function works..
  227. insert value into 2 columns,1 col. should take data from another table & 2nd random
  228. Divide Between Select Values
  229. Compare timestamps then delete
  230. t-sql cursor with loop problem
  231. Database Design
  232. Pass Table as a parameter to a function
  233. textimage_on error prevents transfer I havIaccess 2003 adp database
  234. cannot access the userinfo table for one on my content databases
  235. Error: The number of failing rows exceeded the maximum specified,Help !
  236. Joining tables with different data types on the common field
  237. MS Access to SQL Server 2005 Conversion
  238. Age calucation
  239. Searching table
  240. reduce the File Size less then Original Size in SQL 2000
  241. Sql
  242. Date Format Conversion
  243. how to retrive excel template stored in a table on SQL 2005 DB
  244. Exception from HRESULT: 0x8007000B
  245. Database 'msdb' cannot be opened due to inaccessible files or insufficient memory or disk space.
  246. SQL SELECT issue
  247. Limiting log growth during DTS Package
  248. Time in status from audit trail
  249. Conditional select in a view
  250. Conditional select in view
  251. how to get column name
  252. SQL Server 2000
  253. Domain policy to disable XP firewall causes SQL client slowdown
  254. Hello everyone, I am new to SQL server
  255. DTC fails to work with SQL Server after changing to cluster
  256. SQL Server 2005 Technical Articles
  257. SQL Server Equivalent of 'APPEND'
  258. Access is denied when executing xp_cmdshell delete
  259. Find Maximum Length of String
  260. MS SQL Server 2005 On Microsoft XP No DataBase Server
  261. A simple query that returns the most current address
  262. print report
  263. Interbase to ms sql
  264. Sub queries MSSql
  265. Getting records and output parameter from ASP
  266. How to Test Database Connectivity From a Workstation?
  267. Getting latest record from trigger
  268. Recruitment programming question?
  269. Scripting schema and data together - SQL Server
  270. Sorting Data in Database
  271. SQL Server Help required
  272. MSDE is slow on Restricted User account
  273. Urgent! Protect MDF and LDF files?
  274. Saving images into database table
  275. rename of logical file name
  276. Delete Records Which had some duplciate columns
  277. ERROR in xp_cmdshell syntax
  278. MS SQL Express Advanced vs MS SQL full version vs MySQL
  279. SQL Server Memory Keeps Growing
  280. SQL syntax for querying AD group membership
  281. Sql Server Management Studio Express
  282. contents of image fields
  283. Substitute Of Last() Of Ms Acces 2000 in Sql Server 2000
  284. Get one row from each group of rows
  285. SQL 2005 Query
  286. Oportunidade Stefanini It Solutions
  287. Oportunidade Stefanini It Solutions
  288. Delete Duplicate Records
  289. Please help me
  290. Calculate Time difference
  291. Updating one table from another
  292. brackets in TSQL script
  293. SQL Server 2005
  294. Problem with nested function call (UDFs)
  295. Dts
  296. Error with Select Statement using the SQLDataAdapter Wizard
  297. DOS Batch File Running osql - opening/closing connections
  298. What is different between SQL Funtion & SQL Stored Procedure?
  299. Using procedure results as table
  300. Data into XML
  301. SQL Server job history
  302. How to secure "Data" folder after installing MSDE
  303. How to assign primary key or forign key to existing tables
  304. i had a problem in inserting data in a table with foriegn key
  305. error 0: cannot load the dll, xpstar.dll
  306. Simplifying Relational Division
  307. sql2005 eval upgrade to retail version fails...
  308. How to Compare result of Query & Stored procedure
  309. substring matching
  310. Howto: Delete every second record if duplicates
  311. Ongoing purging of active records causes deadlocks
  312. hi i'm getting error when i execute the query
  313. Help with combining data from multiple rows into one column in a view
  314. Use decimal or varbinary data type?
  315. Need help retrieving a byte array from SQL 2000 and converting it to a string
  316. Concatenation problem: two integers and a char
  317. Problem in stored procedure in the last line plz help
  318. Default value being a concatenation of other columns
  319. DSN-less connection
  320. Need advise on horizontal table partitioning
  321. MS SQL Server Return 1 if exists?
  322. Import from MSSQL2000 (8) to 7?
  323. how to retun results from Stored Proc
  324. default value being a concatenation of other columns
  325. Fetch rows afftected in a table
  326. how to read the query in store procedure
  327. Convert ACCESS code to SQL Server
  328. Convert ACCESS code to SQL Server
  329. Plot Interval in SQL
  330. multi rows SELECT
  331. Sql Trigger For Timeout
  332. Updating SQL SERVER Database
  333. Updating SQL SERVER Database
  334. Dangers of select * into
  335. Visual Basic 6 to SQL Server 2000
  336. Error while Quering Qracle table from SQL 2000
  337. SQL script to update one field in table via batch file
  338. MSSQL Concate variable
  339. Updating a column one row at a time
  340. db_owners unable to see login list
  341. Date Function
  342. select a field declared as "money" and have the output decimal free
  343. How can I decrypt DTSRUN parameters
  344. How write this sentence with T-SQL
  345. Calculate daily averages based on Working Shifts
  346. sessions being killed by sa updating stats?
  347. c#, Query user's access to a database
  348. Connecting to SQL Server 2000 via VB6 program on Vista
  349. SQL Server on network
  350. Trying to import delimited file
  351. How do I see the result of calling a stored procedure in VB6 ?
  352. How To Implement sql server database on the client's computer?
  353. distinct
  354. Ms-sql
  355. count occurances in sql
  356. username function in sqlserver
  357. Trigger After Delete - I need a Trigger Before Delete
  358. How can i Tables, fields Hidings...
  359. Update a column in a table using the values in another table
  360. instance not initializing
  361. page footer report service
  362. Select record where foreign record does not exist.
  363. Date from datetime
  364. problem with login list
  365. Combining many records into 1
  366. Logical Name
  367. Query Analyzer debugger
  368. Getting last value and increasing it by one
  369. Query every entry not in each hour
  370. dts question, data pump task hangs when i try to edit it!
  371. How to Limit the number of rows returned with MSSQL, like the MySQL Limit clause.
  372. Trigger After Delete - I would need a Trigger Before Delete
  373. database information report
  374. Triggers in SQL 2005
  375. Master Database Restoration
  376. Firehose mode
  377. Please solve this query, and help me. :-)
  378. tempdb Size
  379. HCL hiring IT professionals -- Noida/Gurgaon/ Chennai
  380. Copy Records from two tables to new Table
  381. How to create a Role in Microsoft Analysis Server with AMO objects
  382. Encryption Certificate Expiry Date
  383. invalid column in report service
  384. PIVOT / Cross Tab to Populate DataGridView
  385. Same query - different execution plans??
  386. Search Value In Tables
  387. make the database unavailable while loading it
  388. Return a 0 for a non-join result count?
  389. NorthWind Database Practice Questions
  390. Any approach to write query for finding data inconsistencies from multiple tables
  391. No message print!
  392. DBCC commands
  393. Hai ,plz help me
  394. Calling a Stored Procedure from VB6 and using RDO
  395. Error Reporting service
  396. Informatica download
  397. how to giv login security using sql
  398. Query for making a monthly report
  399. Help with a query: returning rows from a coma delimited list of integers...
  400. Help Required regarding Creation of SQL 2005 Jobs and Exec them by using Non-SysAdmin
  401. Help dividing two values from different tables.
  402. How to conncet two PC's to share SQL server database using VB
  403. Give a hand(return value)
  404. I would like to simplify my query
  405. Inventory update problem
  406. [help] scripted database creation
  407. strange characters in data import
  408. SQl Svr 2000 - DTS - Multilingual Data handling
  409. access commands into Reprorting Services
  410. Data Table Column Order
  411. Backup Structure Only
  412. Regarding to MS SQL Processing speed
  413. SQL Server problems
  414. Effect of "Do not recompute statistics" option
  415. view vs stored procedure [ when and where to use view ]
  416. spliting string values in stored procedure
  417. How to create a series of tables with a variable name?
  418. SP kills a query when put in a parameter... help?
  419. How to select two rows within same column and display result as separate column
  420. VERY Complex stored procedure... I'm lost. Help?
  421. Stored Proc Optimization Help Needed
  422. Does a Full Backup include transaction logs
  423. Connect to sql server 2005 Standard thru internet
  424. Which one is bigger (takes more disk space) - a view (sql query) or a table?
  425. [ms sql] How to add new table to merge replication ?
  426. except command not working
  427. SQL Views - embedded view work-a-rounds
  428. Giving Value for Identity column while inserting
  429. Multiple rows inserations
  430. Report Service calculation
  431. Manager Hierarchy (Recursive)
  432. Can I reference the "active" database's system tables from a utility UDF?
  433. Query for Data redundancy
  434. SQL server sample database required
  435. mssql 2000 update from select
  436. Help with a quiry - update is whiping my existing data when it shouldent?
  437. Best Practice when copy table from srv to srv
  438. log shipping
  439. use file position (restore headeronly)
  440. raj
  441. hey pls answer my query
  442. top X scores for each user
  443. SQL Server
  444. sql server access denied or does not exist problem
  445. SQL Query
  446. SQL Date Between Query
  447. retreive a dropped table
  448. Summary View Using CASE is only returning first row?
  449. I need help in SQL table
  450. Get days
  451. Changes in Table
  452. Finding and Deleting Table
  453. SQL Query
  454. sql query
  455. sql query
  456. Help!!!
  457. Single Max Child Row (Based on a Count) for All Parent Rows
  458. Microsoft Jet Database Engine (dts Error)
  459. Are exclusive advertising deals a fair business practice?
  460. URL Hyperlinking issue
  461. Access to SQL Help
  462. Need help updating SQL server table via C#
  463. Automatically script out a table & indexes - script needed (2005)
  464. Argument list in EXISTS/NOT EXISTS Selects
  465. diffrence between MYSQL , SQLSERVER and SQL7
  466. how much space to allow for log files??
  467. xp_sendmail: failed with mail error 0x80040403
  468. Storing return type from a function
  469. Multiple table value insertion with single Stored procedure
  470. Easier way of building pivot tables in MS SQL Server
  471. Anti-joins
  472. insert query
  473. Database BackUp
  474. Sql Query to retrive Nth record?
  475. Copying table
  476. renaming of subfolders
  477. Begin Tran ...... Commit Tran
  478. Background operations
  479. Enterprise Manager - Permissions Question
  480. Help on Uninstalling SQL 2005
  481. insert into SQL using asp
  482. Database Design Question.?
  483. Define a Key - "select * from "
  484. Query analyser
  485. how to distribute a value base on table
  486. SQL Server 2005 - How do I import data from an Oracle Data Pump file?
  487. SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table
  488. XML versus SQL
  489. Msg 170, Level 15, State 1
  490. Identity Column Values.
  491. Accesss ADP
  492. How to increment a field for a Line Number?
  493. Database creation error
  494. Insert Data from Access into sql serve
  495. Execute Sql Statement Stored in Table Type Variable
  496. getting error "“Invalid object name 'SizeMst'. “ " while exec sp
  497. Problem with locking in Selects
  498. Tables updated even though there is an error 80040e14
  499. Import/Export wizard DateTime problem
  500. Image colum type conversion retuns blank value on second server
  501. Help writing an If else statement
  502. T-SQL Challenging Product
  503. Selected DropDownList value to @ID Help! (C#, SQL)
  504. TOP N in Reporting Services
  505. SQL Server Error
  506. Need to find 'yesterday'
  507. Sql server stopped
  508. Learn Oracle Database Administration in 10 Minutes
  509. Primary Key finding
  510. How to reduce the table
  511. Numeric Format Using Sql Server 2000 Query
  512. Connect using different Windows user name...?!?!
  513. Return the last row only
  514. Backup Database
  515. Cannot connect to SQL instance without port information
  516. Converting continuous replication to hourly?
  517. SSMS - getting timeout terminated even with Execution time-out of 0?
  518. Store Procedure Insert in "X" rows
  519. large inserts
  520. Using Join or Using View
  521. Error converting data type varchar to numeric.
  522. Dynamic value on Tool tip
  523. SET STRING_RTRUNCATION ON in Sybase
  524. Sorted Views in SQL server 2005
  525. AddLink Server feature in SQL SERVER EXPRESS edition
  526. Users with permission to MSSQL 2005 objects
  527. How to store the data in the field is KBS or MBS as length
  528. Cannot connect to database using Enterprise Manager
  529. Transfer DTS Package
  530. Export table row to XML file using a stored procedure
  531. MS SQL getDate() Function remove Time
  532. Find website from email address
  533. Simple SQL help needed…
  534. sql
  535. restoration automation
  536. SQL Query
  537. Reports based on queries
  538. Powerbuilder Connection in MSSQL 2K Desktop Engine
  539. group by in sql report service
  540. How can I combine different rows?
  541. vb.net CSV import into sql express 2005
  542. MSSQL Returning Blank Results
  543. SQL Server BCP and identity rows
  544. SSIS automation
  545. List of users and user rights
  546. Finding Difference In Strings
  547. I Have this Complex Stored Procedural
  548. pwdcompare equivalent in Sql2005
  549. Identify Dulicates/Compare data in table to itself
  550. How to update 2 columns at the same time