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