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 there a way to split the contents of a string?
  2. Performance Issues in SQL Server
  3. SqlDataReader on Sql 2005
  4. Bulk Insert with LINQ to SQL
  5. LINQ to SQL with bulk insert
  6. SP timing out, can't find the cause
  7. select distinct * --- possible??
  8. Getting images out of SQL
  9. slow DNS caused extreme SQLS memory pressure+CPU?
  10. searching database
  11. Convert Oracle PLSQL to SQL Server TSQL !
  12. DECIMAL vs INT
  13. Convert Access Dlookup into SQL Server Query
  14. Selecting multiple start and end time out of datetime column
  15. Foreign key constraints
  16. Update statement, which affects only columns, which would get a new value
  17. sql server 2005 express problem wtih {7twud62389sdksdk} the like
  18. SQL Server Queries to DB2 compatible
  19. MSSQL Connection/Authentication Problem?
  20. How to determin if current computer has functioning sql sever(s)installed?
  21. How add rows to table in Microsoft SQL 2008 Server
  22. Removing Non Alpha Characters before saving?
  23. Finding a way to avoid joins/inner selects
  24. How do I detect a local temp table
  25. Tricky date function
  26. Help...
  27. ssis - Where is the sql?
  28. inserting/updating multiple tables through stored procedures
  29. Avoiding deadlocks
  30. Re: Select with many to one relationship
  31. Exporting Result Table directly in .xls (Excel) file
  32. Precision in a REAL data type
  33. new blog
  34. Problem with temporary table
  35. restoring DB of sql server 2000 in sql server 2005
  36. Help Automatically Populating Fields base on PK
  37. Deployment Issues with sql server express 2008 & C#
  38. Re: A dynamic table to be made into excel file
  39. import textfile into 2 tables in SQL server 2000
  40. Seeking Simple Tutorial for Connecting to SQL via C++ (VS2005)
  41. Sql Server 2005 DataBase Mirroring
  42. how to update set some added string
  43. how to..
  44. how to generate the following output in sql ?
  45. How to create a table from a variable name?
  46. Logic problem in for attendance IN/OUT
  47. SQL Sleeping mode . Confused
  48. copy data from one server to another
  49. Whats wrong with my SQL code? HELP Please!!!
  50. Re: CREDIT CARD SERVISES
  51. how to create a DTS package in SQL Server 2000
  52. Table Automatically Populating with Data from another table
  53. Exporting data
  54. MIcrosft Query Wizard: No Params Allowed in Select List
  55. need update statement that does nothing
  56. SQL 2000 to SQL 2005 conversion fails
  57. Return more than one value(store procedure)
  58. IBM X336 server with RAID1 configuration formats all HDDs on newhardware installation
  59. MS SQL in Case Sensitive
  60. Pivot and concatenate
  61. Pls Help In Login And Logout
  62. Finding duplicates rows in a table
  63. A dynamic table to be made into excel file
  64. SQL STATE 22003: Numeric value out of range with TIME data type
  65. odd SqlInfoMessageEventHandler problem (source code provided)
  66. variables in SSIS
  67. sql express 2005 scheduled back up
  68. Login directly into Sql server from C# windows application
  69. Insert and Update Procedures
  70. MSSQL 2005 Connection Problems
  71. Finding Data duplication within two fields
  72. Reguarly back up tables
  73. Convert ntext to nvarchar... or use LEFT AND SUBSTRING in a ntext field
  74. Loop in SQL
  75. Security for server tables on SQL 2000.
  76. test-sanderson@eliteinvestment.net
  77. Aborting a stored procedure?
  78. Copying Parent and Child Records - SQL Server 2005
  79. sql express 2005 silent installation
  80. How to take backup of only the structure of a database in Ms-sql, no need of data.
  81. Checking for mismatch entries in two tables (Urgent Please)
  82. writing permission on SQL server
  83. database connectivity
  84. How to remove the "." present only at the start
  85. Datetime comparison problem
  86. passing a column name to a stored procedure
  87. "Copy and Paste" image into SQL Database.
  88. insert null into datetime field
  89. point-in-time vs. shadow tables for audit history
  90. Linked Servers
  91. Select more than one value for a field in a query
  92. Cast
  93. SQL Data Manipulation
  94. Performance: Conditions in WHERE clause vs. conditions in INNER JOIN?
  95. Displaying time from Datetime datatype
  96. Build a search query based on multiple userinput from textboxes
  97. Hash tables
  98. SQL query question #2
  99. SQL query question #2
  100. Can't get "<>" (not equals) to work in view
  101. default schema resolution for user-defined functions?
  102. how to get the list of tables used in a storedprocedure
  103. delete cascade for 2 tables?
  104. Maximize sql window in SSMS?
  105. How to restore a database through command prompt
  106. SQL query question
  107. AntiVirus recommendation for SQL 2008
  108. Database problem in C#
  109. How can i know number of users who used a object of a database?
  110. How to compare two different columns in two different rows.
  111. Order by date range
  112. Newbie question on a join.
  113. Where clause
  114. SQL Server 2005 Metadata
  115. date time to date only
  116. FTP in SSIS package failed
  117. Remove Seconds from Datetime: How To?
  118. Create User cmd problem
  119. To unicode or not?
  120. How to store big Arrays
  121. Create UDDT - good idea?
  122. Verify backup after the backup is completed
  123. Stored Procedure... pls help
  124. Succinct way to return logical condition as column?
  125. char(5) PK - auto increment
  126. join rows
  127. Get a return value from a StoredProcedure
  128. Add Data to SQL database from a ASP webpage
  129. how to select primary key
  130. DataServices World (November 20): SOA, WOA, cloud computing andfuture of database
  131. REALLY REALLY FUNDAMENTAL QUESTION....Response would be greatly appreciated
  132. Joining Statements in a Query
  133. LIKE usage
  134. Need urgent help - Regarding SSRS and SQL Server 2008
  135. MDF database file openen in SQL server 2005
  136. Self Join Table, MS SQL 2005
  137. failed backup and got error 112
  138. database wide trigger firing with update
  139. can not open user default database , login failed
  140. enum data type
  141. spam
  142. page cannot be displayed on windows server2003
  143. Storing data in File System
  144. How to do UNION of two query results when both results do not have same columns
  145. BCP .fmt for Fixed Length
  146. white space in table and field name
  147. execute formula stored as string
  148. SQL IF...ELSE syntax
  149. Import database from local system to server system
  150. dts /ssis package
  151. Intellisense not working
  152. error in sp code....
  153. bcp command
  154. Selectively Executing Interactive SQL in Management Studio
  155. need help!!
  156. Yellowfin Enhances Business Intelligence Reporting forTelecommunications
  157. Delete duplicates in each column, not duplicate records
  158. Loop to update records in sql server
  159. Parameterize FROM clause in Stored Procedure: How To?
  160. INNER JOIN & IS NOT NULL probs
  161. Does (code) size matter?!?
  162. Help on conditional insert statement using t-sql
  163. complex aggregate function
  164. Concatenate float data type
  165. SQL Server 2005 Pivot Table
  166. Left Join -
  167. osql import inserting carriage returns?
  168. Install sql2005 wrongly in C drive and wanna move to D
  169. Managing data between CRM and Informix
  170. Recursive CTE retain First Child
  171. Referetial Integrity - set default, null
  172. Trans log backup based on size rather than time?
  173. How can I trigger a SQL2005 Stored Procedure from SQL 2000?
  174. number of Connection for Linked Server
  175. Regarding reocvering data through corrupted ldf file
  176. Change SQL Server 2005 Express's default port programatically
  177. Triggers in SQL Server
  178. Matching within a SQL table
  179. Open SQL backup file
  180. SRS Reports
  181. Sql Server Alter statement
  182. SQL 2005 Optimizer not optimizing
  183. How to find out what type of the data procedure in MSSQL 2005returns?
  184. dataGridview
  185. urgent- difference sum within a colomn based on other colomn
  186. sql 2005 express command line instalation
  187. mulitiplication calculating expression
  188. Custom and UserControls
  189. WHERE colum1 = (SELECT with multiple results)
  190. MSSQL hardcoded dataset from select/stored procedure
  191. cmdshell output > 64
  192. Simple SQL Query
  193. spam
  194. sql server cluster node rebuild failure :(
  195. Irregular Results From JOIN
  196. plz help me in sql statement
  197. SQL Server 2000 - OLE DB string connection
  198. Could not find stored procedure 'master.dbo.sp_get_ptaai'
  199. copy table from sql server 2005 one db to another
  200. Convert PostgreSQL DB to MS-SQL
  201. BCP out image files not working
  202. Problem Entering Item Into A Table
  203. Stored procedure Question
  204. INSERT INTO Query
  205. DB fundamental
  206. Datetime in sqlserver 2005
  207. Update or Insert Query Help needed
  208. LIKE 'A%' With Other Parameters
  209. How do I send notifications to an external program?
  210. Find last index of character in string
  211. Deploy Problem with ASP.NET SQL Server connection issues
  212. Copy 2000 database to 2005 - cannot detach/attach
  213. How to compare 2 databases
  214. MSSQL DB Space usage
  215. Trace on sql table
  216. read and set object roles programatically
  217. Find Parent Record Where Child Records Contain Same Value
  218. Error 262 create database
  219. How to control number of users in a database?
  220. Constraint - check integer string
  221. Design Question - Money data-type
  222. displaying record between two dates errors
  223. Multiple datasets Reporting Services problem
  224. Sql query for sorting the output in the descending order
  225. How We create a password protected database in sql
  226. replicating data between master and slaves
  227. Mssql Page Number Query help TOP , NOT IN ??
  228. Problem placing results of generated select statement into dynamic temp table
  229. Multiple Sum and Join
  230. How to find login name and password for sqlserver 2005
  231. Working out a percentage using sql
  232. How do i SUM up values returned by TOP 5 and COUNT statement?
  233. [Newbie Question] SSMS indexes
  234. Strore large texts in mssql and dispaying them in php
  235. How to find the frequent access table's (hit)
  236. SQL query/unique entries only
  237. SQL newbie, need help cleaning up my SQL (works, but ugly)
  238. T-SQL
  239. Foxpro: Connection limit?
  240. Sum up a column and then update a temp table with results
  241. SQL Using a single variable to store multiple results
  242. Stored procedure
  243. SSMS - setting root of Object Explorer
  244. SELECT In order by specific Ids
  245. SQL Server 2008 - What Else Am I Missing?
  246. Help with SQL Server
  247. Accessing the call stack via TSQL
  248. Application Roles and SQL Server 2005 - DDL?
  249. Reg sql query
  250. SQL Server Management Studio question
  251. easily repeatable index corruption in SQL Server 2000 (8.00.2050,post-sp4)
  252. Import/Export Wizard
  253. formatting numbers keeping the lead zero
  254. MSSQL Equivalent to MySQL ENCRYPT/DECRYPT
  255. DB2 linked server from sql server 2005
  256. Unable to attach DB (MSSQL 2005)
  257. Cumulating data
  258. problem with the query
  259. Performance/stability issues
  260. maximum query
  261. SQL 2005 management studio vs SQL 2008 express
  262. set default value
  263. How To Look At Chronological Series To Find the First Values GreaterThan Zero?
  264. Inconsistent results for SELECT SUM(<<real field>>) ...
  265. DateDiff Calculation - odd results
  266. Custom Report
  267. Query For Excel Macro
  268. Querry optimization to have better performance
  269. help me in understanding this update statement
  270. account
  271. path of unsuceesful installation of sql 2000
  272. how can i fix this!
  273. Need help with MIN function
  274. Named Pipes Provider, error 40 - Sql Exception (0x80131904)
  275. Interview type Question
  276. Need help with error on JOIN statement
  277. Database Objects
  278. SQL Express on dual processor server?
  279. A set of tables for each user vs one set of large tables
  280. how to set and get value of Variable in sql server 2005 Integration Tasks
  281. Double Insert Statement Probs
  282. SA Upload SQL Database variable types (image upload and storage)
  283. How do i write Set based queries and avoid a cursor?
  284. SQL LIKE help
  285. Insert a row into a table with 2 foreign keys
  286. Connection issue when trying to connect MS SQL SERVER from Linux
  287. SQL OLE DB Problems
  288. Trigger Problem
  289. Sub Query for fetching records - Urgent Please
  290. Query to display Count as zero if no records exists - Urgent please
  291. cyclic cascade paths
  292. copying from a table to a file
  293. Select query to know the Count of two columns in different tables
  294. SQL Joins or Multiple SELECTS in Procedures
  295. SQL2K +SP3 Replication error
  296. Ssis/ssrs
  297. Services not listed on Configuration Manager screen?
  298. SQLSVR 2005 SP2 / Shrink data file will not work
  299. Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
  300. Not In
  301. Spool to a file from MSSQL
  302. css in rdlc
  303. field length problem of varchar
  304. DTS package and new folder
  305. Global Temp Table (with .NET)
  306. Trigger to Update Fields of Inserted Record
  307. SQL Server 2005 Profiler etc.
  308. Update Query..
  309. Maintenance/Auditing Scripts for SQL Server
  310. Please Assist...SQL Server 2005 New Line in Text
  311. sql server procedure
  312. Get Row(s) in error MSSQL2005
  313. dividing agregate functions in a grouped query
  314. SQL tuneing
  315. Loop on results, call sproc
  316. Formatting phone numbers
  317. SQL Server Agent Alert System - Operators?
  318. Standards for using Stored Procedures as an interface
  319. management tool express 2005
  320. SQL DTS SQL Task for .PGP Encryption
  321. Fire an SQL Server Trigger on a Bulk Upload
  322. SQL Query to display count of two columns from different tables
  323. How do I use bcp to insert into sybase
  324. The inserted and deleted tables are empty ? (trigger operation)
  325. SQL Select Query to fetch Count of two columns from two different tables
  326. Select query for fetching records from two tables
  327. Procedure for deleting records
  328. SQL2000-How to reclaim the Unallocate Space for Database(low hdd space - Urgent!!!)
  329. error while executing stored procedure
  330. Find hidden triggers in database
  331. Raising events from sql server 2005
  332. Programatically add columns to .rdlc
  333. How to convert a Varchar into a Int with sql 2000?
  334. LoadFromSQLServer failed
  335. How to display a date stored in a table with the desired way?
  336. Sql Query
  337. It's Me again!
  338. Call DB2 database from sql stored procedure
  339. data/schema comparison
  340. About where clause
  341. Error in Proc
  342. Inline table function
  343. dividing return set into smaller sets
  344. SQL Server
  345. spam
  346. selecting rows from a table
  347. datatable select
  348. Copying data in SQL Management Studio
  349. update
  350. sequence
  351. how to make server
  352. Table/ ERD design for university students enrollement system HELP HELP HELP
  353. central backup
  354. Count and group of a date column
  355. I need a little cursor help
  356. I need 'order' in a select w/ Union statement
  357. Single server but multiple timezone database..
  358. Select Insert Deadlock
  359. using sp_helpdb and getting error
  360. SQL2000- How to use DateDiff Function together with (If then..else)
  361. FORMSOF Predicate: Need Plural, not Inflectional
  362. UDF using EXISTS help requested
  363. How to isolate a DBTYPE_DBTIMESTAMP to datetime error?
  364. Customizing SQL Server 2005 Enterprise Manager colors depending ondatabase
  365. SQL Query Help - Convert string to byte array or copy string data to another table?
  366. sp_executesql increases number of reads?
  367. How to read the xml and display using xslt from a DB in sql server2005
  368. How to Change Font size
  369. Distributed view joining int and bigint
  370. Hello there
  371. Combine two column with sql statement
  372. What SQL version am i running? Free or not
  373. MSSQL Query
  374. Union query in sql issue
  375. How to Pass Parameters from SQL Server Stored Procedure to Excel
  376. sql query out of range datetime value
  377. selecting a date range using query
  378. jsp to sql
  379. Incorrect syntax near ','
  380. Incorrect syntax near ','
  381. Cannot find data type xml
  382. How to synch renamed NT account with SQL Server 2005
  383. hierarchical results in sql server 2000
  384. Re: Datadevices
  385. Select Max() not working
  386. MS/SQL Developer--DTS--Contract--Detroit Area
  387. SQL Server 2000 Failover Cluster upgrade to SQL Server 2005
  388. ODBC mystery
  389. SPROC help for insert into from related records
  390. Value Truncates When Using Float Datatype
  391. time out expired
  392. SQL Server 2005 copy objects
  393. BULK INSERT Question
  394. Why Restore with Norecovery is incomplete?
  395. SSMS Keyboard shortcut for CTRL+B
  396. Re: Cannot Connect
  397. Sorting
  398. Temporary tables
  399. Passive Laddered Bonds: Table Structure?
  400. Is DTS possible to schedule like a job process?
  401. Ration calculation
  402. Increment an order number which is not pure numbers
  403. Login in SQL*plus
  404. Location Intelligence where to from here?
  405. SQL 2000/2005 Transaction Log Reader Library
  406. error while executing job on Sql Server Enterprise Manager
  407. Sorting four columns using sql query in query analyzer
  408. Modified Proc
  409. SQL 2005 Express Security
  410. logs
  411. How to attach MS SQL 2005 Express database to MSDE (2000)
  412. ONLINE RESOURCE FOR HELP DESK SOFTWARE
  413. export relationships in SQL 2000
  414. TSQL Query
  415. SQL 2005 Management Studio/Express - Any differences
  416. how to display display available or unavailable time slots in SQL Server
  417. Calculated fields...
  418. ODBC DSN connection fails from MS Access 2000 after SQL2005 mirrorfailover
  419. unique values combined with COUNT()
  420. problem in identity
  421. Microsoft's SQL Server and related products.
  422. how to AUTOCOMMIT ON in SQL server 2005
  423. Help on the following SQL server Select query
  424. SQL Server data dictionary
  425. How to use stored procedure parameter in sql-statement?
  426. Indexing Low Cardinality columns in a data warehouse scenario
  427. Change Collation Name in a database (SQL SERVER 2000)
  428. table values function in SSIS
  429. SQL Update Trigger Question
  430. install script
  431. UPDATE query gives Incorrect Syntax error
  432. large data : how do you store multidimensional data ?
  433. DELETE only deleted 10000 records
  434. finding PIVOT table data source
  435. How to use Cast
  436. truncate decimal place
  437. query is slow after inserting lots of records in some tables
  438. Recursive Update Query for SQL server
  439. Tablediff Utility SQL server 2000
  440. generate SQL script from DTS
  441. how to get todays Inserted and updated records in sql server 2005
  442. searching fields and displaying feilds with data
  443. database problem
  444. Tweaking SQL to optimize the query execution plan
  445. Help Needed For writting a query (SQl Server 2005)
  446. MsSQL - Not storing and returning milliseconds
  447. How can I produce multiple output flat files from a single SQL filewith multiple SQL statements?
  448. Best method for storing a time in a MsSQL database?
  449. UPDATE Record's
  450. SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?
  451. Deadlock Issue
  452. Different empty_string/NULL handling under ODBC and OLE DB?
  453. T-SQL: Recursion and circular references
  454. DTS: Copy new + modified records from table1 to table2 from two different servers
  455. MySQL to MSSQL Conversion
  456. Encrypt and decrypt a full database in sql server 2005
  457. SQL Serial Data to Parallel
  458. SQL Installation
  459. get the jobs run in a particular time interval from sysjobhistory
  460. How to create a distinct table combining records with Null values
  461. Project Management Knowledge Base !
  462. Columns
  463. How to store the result set in temp table
  464. sql squeries
  465. Query with different WHERE clauses
  466. sql queries
  467. Is there a limit in retrieving foxpro file using VFPOLEDB ??
  468. Validation Constraint on Data Entry
  469. Creating Reindex
  470. Truncate text in table? (ie 101928494 will become 928494)
  471. query on multiple database
  472. pivot? rows to columns
  473. SQL 2005 Express
  474. Comparing data in two different tables to find missing records
  475. SQL Server 2008 Final release date
  476. scheduled data clearout
  477. relationship
  478. sql queries
  479. not showing proper datetime in tables
  480. IDENT_CURRENT help
  481. sql server queries
  482. get latest date record
  483. MS SQL 2005 Replication, unable to create publication
  484. Calling external apps from SQL Agent
  485. plz suggest me the query
  486. Update date In MS SQL
  487. IT auditing tool SC Magazine Review
  488. Update table name and all objects that reference it
  489. Creative query assistance needed
  490. Convert Access quey to SQL statement
  491. How to validate a column using stored procedure
  492. undeclared variable in stored procedure
  493. mapping path of a file
  494. How to find out difference between two rows....
  495. SQL Server 2005 - Developer Edition Installation Error
  496. Moving SQL server to another
  497. SQL server 2005 enterprise manager
  498. SQL Server Engine Downgrade
  499. SQL Problem
  500. I want to connect DB in SQL with data in Active Directory(Urgent)
  501. Open record sets
  502. MS SQL Problem
  503. Problem With MS SQL
  504. SQL 2000: Transport-level error on SELECT statement
  505. Create Trigger
  506. Complex Query
  507. dropped tables
  508. SQL 2000 server replication and a MSmerge_tombstone problem
  509. Trying to insert a zero, its telling me i cannot insert a null
  510. Significant Figures/Digits.
  511. Database size shows huge
  512. Query for displaying a particular set of data
  513. Update auto increment feild to replace nulls
  514. Calculate Number of working Days in a Given Period
  515. Update/Insert with constraint
  516. SS2000 500xSELECT on one table; how to speed it up??
  517. Generating Script for a DataBase
  518. A Question on query efficiency
  519. How to deploy a database on SQL Server Express 2005
  520. Can Analysis Server and Report Server run on SQL Server 2000 Cluster
  521. Jobs, Interview Questions, Certification, Knowledge
  522. How to do incremental update?
  523. 'FROM reallyReallyLongTableName AS a' syntax?
  524. Re: SQL Server 2008 caching
  525. package configaration SSIS
  526. Determine which fields to select based on date
  527. Use output of Stored Procedure as where condition
  528. Re: SQL Server 2008 caching
  529. Exception handling in stored procedures
  530. select blocking sessions t-sql
  531. Write "Messages" window to a log file?
  532. please solve this problem
  533. Sql Connection
  534. spli two rows
  535. Database login failed
  536. Incrementing Filename when saved
  537. problems with case statement in where clause
  538. Does SQL Server support a row count function?
  539. Deduping
  540. Yellowfin seeks resellers for BI product
  541. Sql Server Install
  542. Store DWG file in SQL server?
  543. load_file and blobs
  544. Using a Trigger to determine when a column was changed
  545. Import table from notepad to SQL server 2005
  546. Insert from SQL2005 to DB2
  547. Data returned by SQL Server ODBC driver is not correct
  548. Cannot Create DSN connect to SQL Database
  549. Update Status column after specific date.
  550. MSSQL bcp command help