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