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