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