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