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