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