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