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