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