View Full Version : 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
  1. IS Null
  2. how to build tables at run time in sql server 2005
  3. iam new to sql
  4. query help sought
  5. What is Data type of ISBN and YEAR ?
  6. where is import and dts on sql server 2005
  7. checkbox
  8. windows form
  9. OpenDataSource fails from worksheet name starts with a number in xls file
  10. calculate score in ms sql
  11. 512 error in delete statement
  12. Bulk Insert - Dynamic Errorfile Filename
  13. Greater than statement for 2 columns
  14. Intimate via email to indentify the DB Suspect
  15. Newbie : Updating a table from a query
  16. Newbie: Find unique records
  17. How to recover a DB From Suspect
  18. SQL Job Failure
  19. newbie question: How to add extra SQL Auth. account?
  20. Importing Text File To Sql 2000
  21. Max Occuring value in a column
  22. what's the best way of importing a query from access to be a view in MSSQL2005?
  23. Changing decimal places in a query
  24. @@identity
  25. equivalent of SET NEWPAGE NONE in SQL server 2005
  26. Commands not available in 2005 Express
  27. Reporting Services Hide Duplicates Problem
  28. system DSN connection
  29. how to Mutiply different data type columns
  30. how to set and reset column identity by a query?
  31. store image in database
  32. Sql Query problem
  33. t-sql query
  34. Stored procedures Again
  35. How do I calculate something using values from two tables?
  36. converting oracle script to SQL server 2005 script
  37. Using findstr on SQL 2005 ERRORLOG file
  38. caching in Reporting Services
  39. Using Formula
  40. Transfering data from SQL Server Standard to SQL Server Express
  41. delete query from two tables
  42. query
  43. Query - select common data from one column and display in severalcolumns
  44. Creating a dynamic SSRS report via URL
  45. Replication in sql SERVER 2005
  46. Passing Multiple values in stored procedure
  47. ado net
  48. Using a "match" table to store multiple columns for parent data
  49. First SQL job
  50. Full Stored Procedures?
  51. Trigger ISSUE
  52. Add 2 hours to a time value!
  53. SQL Qurery help
  54. Running MS Access queries from SQL Agent
  55. Help Please.. Repost..
  56. sQL HELP
  57. Numeric error..
  58. Deleting a maintenance plan
  59. Plz Help
  60. Trigger problem
  61. SS2005 Merge Replication through message queue
  62. Trigger to find specific New Value
  63. Trouble with a count
  64. Difference B/W Triggers and Stored Procedurs?
  65. Group by DatePart
  66. Dynamic Columns in a table
  67. Problem with a lot of inserts in short time - SQL Server 2000
  68. ASP.NET C# web application to connect to SQL SERVER 2000 database
  69. Problem in Database mail
  70. Syntax to access database on another server
  71. Oracle date problem in SQL SERVER REPORTING SERVICES 2005
  72. constraints
  73. Basic MSSQL Query help
  74. Loop
  75. reduce time for search query
  76. An existing connection was forcibly closed
  77. Error on Transaction log backup
  78. SQL Function Help
  79. Insert/Update
  80. Backup Exec and MS SQL Server 2005
  81. problem regarding connection of vb and oracle
  82. how to calculate the date
  83. Track changes made to SQL Server
  84. hi
  85. Spaces after data in field
  86. Access To SQL
  87. Rebuild Index Fails, need insight
  88. Need help with SQL Server Cluster
  89. Retrieving duplicate consecutive records(How to make query for this scenario?)
  90. Dropped tables
  91. Passing a varible as an linked server name in openquery
  92. error in running the join query
  93. Insert Query
  94. Urgent IT related openings with Corporate MNC companies all overIndia
  95. Working With Two Different Stored Procedures from Different Databases in Sql Server
  96. Problem in SQL Server 2005 in Database mail configuration
  97. SQL 2000 Profiler
  98. SQL database hang
  99. Replace one value with another in query result
  100. BCP import then export
  101. Doubt in COUNT(*)
  102. doubt in saving wave file
  103. Query string encryption in T-SQL
  104. system DSN connection
  105. how to check case for username password field in table?
  106. DB size increase from SQL 2000 to 2005
  107. stumped with stored proc and temp tables
  108. Linked Server - Connect to db2 on different server
  109. Get database name in run-time
  110. ROUND function
  111. Need Error_Number list with Error_Messages
  112. SQL question ( retrieving records based on a priority order )
  113. SQL2005 Aggregate Multiple Update optimazation: How-To?
  114. Autogeneration in MSSQL
  115. Use unique key for Sqlserver view for updates
  116. To fetch common values between two rows
  117. Sybase Event query (Multiple Inserts based on Select)
  118. get different result from 1 column in 1 query
  119. Help with SQL Query for Graph
  120. UPDATETEXT question
  121. Accessing values of comma delimited string
  122. Inventory SQL Server machines on your network
  123. xp_xmdshell and BCP select string problem
  124. Need help with delete trigger
  125. How to do the Bulk delete in Sql table?
  126. How to use Arrow keys to scroll the scroll bar
  127. Multiple Queries vs Dataset
  128. SQL Random number
  129. Why Same query results in two different # in SQL Server vs MS Access
  130. Trouble with one to many relationship in single SQL query
  131. Count from detail table
  132. MS SQL Server Multiple Rows into 1 column.. Semicolon Delimited.. Null Value Problem
  133. format date
  134. sql server data transmition
  135. Want to learn SQL in California....any school, literaturerecommendations?
  136. Problem converting access queries to sql
  137. Small SQL Engine
  138. SQL server multi-statement table function w/ openquery
  139. Calculate Client wait time with sql server process time
  140. Check for the Duplicates
  141. Freshers Recruitment & Walk-in For Freshers Feb 23-24
  142. SQL Script to sync. two servers
  143. AutoNumber
  144. Stored Procedure Thread Safe?
  145. Table replication question
  146. Sql Backup
  147. SQL Help with two table
  148. Replication in a single transaction
  149. Slow performance in SQL2005
  150. Need Help On Multiple Max Values
  151. Query Plan Tool on my web site
  152. Multiple Identity Columns
  153. SQL Query with Self Join
  154. Create a dynamically incremented field
  155. Append .bak (Backup) file to Database using Restore command
  156. Output of a query in row intead a column
  157. Timeout when specifying server name
  158. How to seed or increment NEWID() value
  159. Addition of two numbers
  160. Online Query Tool SQL Server 2005
  161. Zerofill
  162. Problem with a select statement
  163. trigger not doing anything
  164. DTS procedure
  165. Linked Server and Oracle10 Performance Issues
  166. Need help with database usage history and backtrack
  167. Log File Recovery.
  168. Compatibity of SQL server 2000 and 2005 database!
  169. Problem With SQL UPDATE
  170. Round Function
  171. Unmatched query multiple criteria
  172. SQL Server Performance Issue
  173. does the table follow normalization
  174. Running SQL scripts programatically
  175. Help Needed For writting a query (SQl Server 2005).
  176. simple connection
  177. Database Search
  178. Like
  179. Querying First Time In And Last Time Out
  180. CharIndex, Left T-SQL question
  181. importing multiple excel files
  182. delete otherwise duplicate records based on differing values in one column
  183. Duplicate records and set field to constant
  184. Multi-Line Coments
  185. Compound aggregate (Max of Count) procedure question
  186. Create user similar to 'sa'
  187. Trigger Question
  188. Subselect top1 - need two columns.
  189. Suggestions Plz
  190. convert oracle trigger to sql server
  191. Combine keyword and search result ?
  192. Patni Computers written test question
  193. SL Sum question
  194. sql and bcp bulk import tab delimited from text file
  195. What is the range for smallint
  196. get the latest changed records
  197. TimeOut expired error when selecting more than 300 rows
  198. Update table using triggers
  199. need of SQL Dumps
  200. Always return something on a ZipCode Search
  201. SQL 2005 OSQL qestion on Microsoft cluster
  202. group by Ntext
  203. Trigger
  204. How to insert Price in SQLServer usimg decimal datatype
  205. Query from two tables that looks for a missing value
  206. SQL Server 2000 Connectivity
  207. Adding conditions in the ON clause of a JOIN
  208. Enum the running SQL instances using DMO
  209. Calculating Age median from list of Dates of Birth
  210. Interactive Sort on Matrix in RS
  211. Update Table A based upon secondary query of Table A & Table B
  212. GetElevation function
  213. How to check setting of CONCAT_NULL_YIELDS_NULL
  214. Comparing results from a column to results from a form?
  215. Why does Error log show database restarting everytime a transactionlog backup runs?
  216. Full Text Search of Microsoft Word Document
  217. FIFO Stock Taking...in Sql 2000
  218. Dbcc Indexdefrag
  219. Urgent walkin interviews from top rated companies
  220. Problems character sets / special characters dot.Net <-> mssql-server
  221. Linking two databases and copying details to third database
  222. Changing the Owner of System tables in sql server 2000
  223. sql command error
  224. SQL Server Connectivity
  225. Subtracting grouped counts
  226. Trrigger problem
  227. server/client connection of sql 2000 in 2 computers
  228. update sql with results subquery
  229. on line discuss
  230. SQL -Need Help
  231. update subsquery with Not = condition
  232. SQL: Write 24 rows undependent of how many sows sql returns.
  233. xquery help needed... can .modify be parameterized?
  234. grab 2 sets of data from single table based on a condition
  235. Syntax help - Subtract two years from current date?
  236. how to write a sql select query script
  237. How to divide a value into Two
  238. Help
  239. SQL server instead of trigger
  240. Advantage of creating Reindex
  241. how to Know dboption
  242. need assistance with database mail, sp_send_dbmail
  243. ODBC connection monitoring
  244. Transfer mysql DB to MS SQL help
  245. Need example query using Timestamp
  246. SQL Data fetching from asp..net
  247. Best practice for comparing 2 tables
  248. Primary Key fails to copy in db Export
  249. sql server to access
  250. Stored Procedure for deleting multiple records from 3 tables
  251. System DB backup Error
  252. Group By with 2 outer joins
  253. Multi-Values??
  254. Aler tables in CASCADE Mode
  255. Filtering, sorting, summing
  256. Staging the Value
  257. What is wrong? Update value from one database to another
  258. SQL Server Reporting Services Configuration Error
  259. how do i create database in sql server
  260. Encrypt and Decrypt a string variable
  261. Why does numeric data type use storage inefficiently?
  262. Inserting Rows from a copy with a Primary Key, and a GUID
  263. Create a new table from csv file using SSIS
  264. Distributed Transactions across Linked Servers
  265. application.startuppath
  266. Trigger on Replicated table from another Database
  267. Execute a UDF
  268. Comparing strings in SP
  269. Help in Table level restore/backup
  270. Use of triggers in Sqlserver
  271. Where deleted DB/Tables stores?
  272. sql server migration issues
  273. Select
  274. MS SQL Server 2000: automatically rows inter changed in database
  275. how do i handle
  276. want to pull data with leading 0
  277. case in joins
  278. Basic MSSQL Query help
  279. Rowlock v. optimistic concurrency
  280. Sql Connectionstring
  281. Cross tab query
  282. Distinct Latest Records
  283. Databindings
  284. Identity on 2 fields
  285. How to display skeleton of table in sql server 2000
  286. Sending mail from DTS
  287. Syntax error in the case statment
  288. VB6/ADO/SQL Server -- Error 3265 : Item not found in this collection ...
  289. Crosstabbing (or rotating) a sql table
  290. stored procedures
  291. SQL Syntax Error
  292. how to hndle month
  293. Query to get total
  294. Get multiple column values as one item?
  295. Having problem with Update from query
  296. Complex MS SQL Query help
  297. Need link between MS Excel and MS SQL Server 2000
  298. How to find out the number of days in a financial year.
  299. Timeout
  300. Loops taking long time to run in SQL 2005 standard edition
  301. Help
  302. trigger:-Subquery returned more than 1 value. This is not permitted when the subquery
  303. Import dbf file into SQL Server - numeric fields shrink by 1 digit
  304. Table Data from Name
  305. Need help writing a stored procedure
  306. Command text was not set for the command object - error from dbms_lob.writeappend
  307. Combine rows in a table that are only different in one column
  308. Connect Access to SQL Server
  309. Query analyzer on desktop
  310. difference between primary&secondary files
  311. question
  312. How to set default value for a datetime column in mssql
  313. Slow Sql Query
  314. sql learning
  315. Migration of MDB forms into ADP and connecting to SQL
  316. autonumber
  317. Legacy DTS job to copy data from SQL005 to mainframe DB2
  318. Data Mashing
  319. Poor Performance with Lazy Spool Operator
  320. Transfer data to web page fields
  321. Sum
  322. Bit Data
  323. win32 or x64
  324. Dlookup issues with Query converted to Passthrough Query
  325. Need help merging 2 tables into 1
  326. Not able to update using LIKE % clause in MSSQL
  327. FreeTDS / SQL Server 2005?
  328. Recovery data from LDF file?
  329. Operators
  330. Calculating the Date Difference dynamically
  331. Inserting image into SQL database
  332. Rollback Of Modification
  333. Database optimizing vs Total Columns in a table
  334. [How to] avoid cross product/Cartesian product to improve performance
  335. Usage of CONVERT function in where clause (in SQLSERVER)
  336. Migrating data between two different servers
  337. Creating Report
  338. Need link between MS Excel and MS SQL Server
  339. sorting with null
  340. automation error, the specified module could not be found
  341. Inserting multiple records into two tables...with a twist
  342. Union Tables without duplicating lines with NULL values
  343. Sum
  344. Need help with reporting service security
  345. One subscriver, multiple phone numbers.
  346. trig errors
  347. MSSQL not showing seconds even after using datetime as the column type
  348. Create Report
  349. update with a one to many
  350. Sql Injection
  351. SQL-Server 2005 suddenly doesn't accept date format YYYYMMDD
  352. Procedure to moniter database
  353. Triggers in SQL 2005
  354. SQL server indexes through access (vba)
  355. Alert doesn't work on SQL 2005
  356. Sort By Name Except Other
  357. REPLICATION
  358. crazy statement :) please help
  359. aggregate rows of one column for each row of another column
  360. Select statement query
  361. delete records from one table that occur in another
  362. how to release a table lock..?
  363. Datatype
  364. connection string
  365. Datagridview Print
  366. Changing a column datatype
  367. multiple numbers in one statement
  368. Deploying CLR trigger to SQL-Server 2005 -- Permissions Required.
  369. help needed with update
  370. Get previous record before given date SQL Query problem
  371. sql query help
  372. helo needed with stored proc...
  373. top4 by bank
  374. SQL in(@parameter)
  375. Changing the datatype of column
  376. how to sort fields in table
  377. Converting rows in column header
  378. Database structure synchronization with LINQ to SQL model
  379. stored procedur
  380. Query Problem
  381. DTS import for VB6
  382. SP Generate Random String - Check if String Already Exists
  383. Process a String from a Table to decimal value
  384. How to use Print() in cursor?
  385. Rmote database inserts blocking local queries.
  386. get non matching rows from table 2
  387. SQL resolution order question
  388. Suddenly, queries against one table "never return"
  389. RecorCount get 0
  390. Tsql
  391. Exporting datas
  392. Problem with putting a database in single user mode
  393. stored procedur
  394. pls help me its urgent.....
  395. Performance issue using conditional WHERE clause
  396. MSSQL: Stored Procedure, using an in-line procedure?
  397. Update and select next value from a list
  398. Database table design for performance
  399. SQL Connection to Web Server
  400. Error in connection...The ConnectionString property has not been initialized
  401. Ordering Months in Calendar Order
  402. Moving data from SQL server to Postgre or Oracle or Cache
  403. aspnet_Roles and aspnet_usersinroles
  404. how to import values from a notepad file to a sql server 2005 table
  405. Sum statement has no records
  406. To filter store procedures that only do select operation in a particular Database
  407. Help with subquery WHERE EXISTS or IN
  408. Correlated Subqueries vs Joins
  409. Getting NULL value when Importing spread sht to sql table
  410. Months Between
  411. Problem migrating DTS to SSIS
  412. Transaction File Backups Not Deleting after specified timeframe
  413. Reports
  414. How to round a float value
  415. connecting MS Sql
  416. Quering data from database for the specific date period,SQL
  417. Unable to attach the database
  418. Help-VB.NET and SQL Server 2005
  419. memory optimization
  420. Database backup
  421. NULL values in a SELECT in another SELECT
  422. Quering data from database for the specific date period,SQL
  423. Sql Server Error
  424. Only Unique Data required of a table. Please help with this Query.
  425. Data Model for Searching large databases
  426. help me join same table
  427. Subquery returned more than 1 value
  428. Tricky insert query
  429. Need help with SQL Statement checking for nulls
  430. SQL error cannot connect
  431. Trouble obtaining database table values...
  432. new to this site.............
  433. Query Question
  434. Getting Unique values with GROUP BY
  435. Enable/Disable Job through another job
  436. Get data from last week of the previous months to the 2nd last week of current month
  437. Isnull
  438. Plssss Help needed in SP
  439. sql server 2005 transaction problem(sql server experts this question for you :))
  440. How to insert image into sql server 2000
  441. Collate
  442. MSSQL server 2000 ObjectType Trace Event Column
  443. SQLServer
  444. Insert columns from selected rows
  445. removing unused objects - SQL Server 2000 or 2005
  446. Timestamp Precision
  447. Bezu:-To calculate two column
  448. Access 2000 and SQL Server 2005
  449. importance of order in the ON statement
  450. Join these 2 views and make one stored procedure
  451. How to identify a user of concurrent users in centralized sql server database
  452. Reveres of TOP function?
  453. Stored Procedure to list out user access
  454. I need to know where mssql server stores its data.
  455. how to split a coloumn into 5 coloumn
  456. Sql Server 2005 Mdf File Blank
  457. permission issue connect sql server table from MS Access
  458. GOOD LINKs for studying advanced sql
  459. TempDB won't shrink
  460. Will Mysql clash with exchange 03
  461. conect MSSQL 2000 to visual studio 2005
  462. Integrity Check help
  463. How to get the username that invokes a SQL Job inside job
  464. INTERSECT in MSSQL 2000 on the same table
  465. Nested Query Help
  466. SQL Split and insert
  467. Design question regarding junction tables
  468. T-SQL Loop on selected query
  469. Variables in SQL-script SQL2005
  470. Pls HELP needed in DTS
  471. Merge two tables in one
  472. Cannot insert duplicate key
  473. SQL 2005 Activex conversion help
  474. difference
  475. Excel and MS SQL Server...Calculations for statistics
  476. Multiple Column Rankings
  477. interview questions
  478. sql mager
  479. SQL Sort Problem
  480. Script to Start Sychronization
  481. Adding 2nd Datafile Server 2000
  482. Listbox
  483. Selecting a filtered group result
  484. Add data for unknown name columns
  485. intersection data in MS SQL 2000 server
  486. Grouping with two Criterion and time point structure
  487. Crosstab Query
  488. Please reply
  489. Need SQL Function Brainwave
  490. data type
  491. functions
  492. duplicate checking
  493. SSIS packages
  494. A dimension playing off another dim
  495. Need Help Importing Data from Excel to My SQL Database
  496. Adding a column in query
  497. Biztalk vs SSIS as an ETL tool
  498. Security Issues when linking two databases
  499. how to generate date backward from end to start
  500. using a variable in the column_alias of a select
  501. import file
  502. Error 823: I/O error (bad page id) Attach recovered database file in the enterprise m
  503. How to connect Access to SQL Server (which engine?)
  504. A philosophical question about inserts
  505. Excluding certain rows from query
  506. correct row ID but not the text
  507. help me -CURSOR backward insert from End Date > to Start Date
  508. Could not find the path specified
  509. SQLServerException: The TDS prelogin response is incomplete.
  510. 16GB Ram 64-bit server, what configuration to use?
  511. T-SQL Sudoku Game
  512. SQL 2005: Transactional Replication > Executing sp on subscribershould execute on publisher
  513. Save a function as a function.
  514. Convert to Datetime
  515. sql server
  516. Select Case Where Like?
  517. Is ADO really dying?
  518. When a report was run
  519. SQL SERVER 2005 SP2 post upgrade issue
  520. SQL Help
  521. Maybe something very easy?
  522. data base in sqlexpress 2005 in .net 2005
  523. reports
  524. Datagridview
  525. Is any compression technology available in Database?
  526. Updating 1 table from another
  527. error when connecting to sql db
  528. Datagridview Issues
  529. Store Image To Mssql Server 2000 Table
  530. Datagridview
  531. Textbox
  532. Queries Log on SQL Server 2000 ???
  533. URL to download
  534. For XML Explicit Syntax to Normalize a table
  535. Output to text-file
  536. Decimal value
  537. Formatting Numeric Value in Computed Column
  538. Insert three columns from one table into one column in another
  539. check the word whether correct or not
  540. How to store a doc file as it is in a field?
  541. How to prevent duplicate successive inserts in a certain timeframe
  542. Running SQL from command line
  543. Import Data error
  544. how to make deployment of our project
  545. Create Delete Trigger on Table1 to Update a filed on Table2
  546. problem in Updating a column
  547. problem in update..
  548. Delete duplicate record
  549. Embedde Sql Server in VB 2005
  550. [Announce] DataDirect XML Converters 3.1 Released - HL7 Support