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