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