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. Backup Files
  2. How to pass user defined variable to Select statement
  3. Can I combine Log Shipping and Clustering?
  4. ISNULL for a date to char conversion
  5. SQL 8.x: Exporting Data into Excel
  6. how to import a data to table from file and export data from table to file
  7. ho to connect sql server2005 with c++
  8. Stored procedures and stored functions
  9. Unable to load search config settings
  10. Error converting data type DBTYPE_DBTIMESTAMP to datetime
  11. Database attach failed
  12. T-SQL : How to find cross-conditional queries?
  13. many to many relationship inserts
  14. bcp to xml
  15. how to copy files using xp_cmdshell
  16. Beginner question, stored procedure
  17. MATCHING colums
  18. Ms SQL Server 2005 HELP
  19. problem on blank space
  20. Can we update View
  21. Easy case statement that I cant do
  22. More than 1 "LEFT OUTER JOIN"
  23. Sql injecting
  24. how to implement product search in DB with millions item within eshop ?
  25. DB Master Key - Sql Server
  26. Security Checking
  27. Run Sql Stored Procedure From Excel
  28. REPLACE Statement
  29. Restore a database to another server
  30. How to open SQL Server Management Console from a workstation?
  31. Division by zero problem
  32. tuning stored procedure, variables and different optimisers
  33. gridview
  34. SQL Query
  35. scheduling from Excel to SQL Server
  36. Auto correcting missing data
  37. incomprshensible code
  38. DTS Local Package - Date Formatting
  39. SQL neewbie - looking for windows front-end app for SQL database backend
  40. get max values
  41. SSIS DB to DB or DB to File
  42. how to get max value of multiple rows ???
  43. Can you help me to avoid this deadlock?
  44. Problem connecting from PHP
  45. query on date field with AM/PM designation
  46. databanks as test-examples
  47. Unicode in SQL Server 2005
  48. IF statement question in stored procedure
  49. Get all active transactions
  50. Unable to connect to Sql server
  51. Finding and Correcting Missing Column data in a single table
  52. Help with a SQL Query
  53. Working with DTS
  54. Any Advice on transact repl error
  55. Setting Defaults in an Insert Into command for SQL
  56. Inserting record into table as the first record
  57. 2760 SQL State 42000 The specified schema name either does not exist or you do not
  58. Deleting foreign key record
  59. Why is SQL Server 2005 Express on my PC and why won't it update?
  60. Call store procedure from function
  61. passing a parameter to TOP when getting random data
  62. ANSI NULL DEFAULT database option
  63. Creating Test Database
  64. Violation of UNIQUE KEY constraint 'IX_User'. Cannot insert duplicate key in object '
  65. Table linking on sql server 2005
  66. MSSQL Slow Queries on One Database only all others fine.
  67. Unable to initialize OraOLEDB from SQL Server 2005 x64 to Oracle
  68. Commit Transaction Even on Trigger Failure
  69. Update a value on current record based on previous record
  70. Problem in some SQL server
  71. VB6 compatibility with SQL Server 2005
  72. Copying data from one table to another in SQL Server
  73. SP performance slow when calling directly on server
  74. SQL Server
  75. how to optimize the store procedure in SQL server
  76. How to obtain previous charge
  77. How to create XXX_UAT a database same as XXX.
  78. Converting a trigger in Oracle to SQLserver
  79. Upsizing from Access to Sql 2005, problems with now() funciton
  80. round a value to the nearest integer
  81. Difference between SET and SELECT
  82. how to get maximum in alphanumeric values
  83. SIMPLE SQL ? Large insert
  84. Deploying SQL Database
  85. Passing variables to MSSQL
  86. snapshots and reverts
  87. Defining Parameters
  88. Users last logon
  89. Index design
  90. Stored Proceedure
  91. Problem with importing a CSV into database
  92. how to pull out a specific category from a database
  93. Best Way to Synch 2 Tables?
  94. MS SQL 2000 formatting numeric value to money
  95. Updating Character String with sql
  96. security checking on input string
  97. 3 tables join
  98. Is it posible in sqlserver 2000
  99. sql server 2005
  100. SQL & .NET (C#, VB.NET, ASP.NET, XML) Latest Interview Questions
  101. Sorting Numeric + Alpha Sorting
  102. BULK INSERT - Inserting txt file with columns in different order than define in table
  103. Stored procedure generator
  104. Producing week ending dates for each week of the year
  105. Surprising - SQL Quey - order by !!
  106. SQL 2005 32bit upgrade to 64bit possible?
  107. Optimized query
  108. Entire Row not Updating
  109. Using variable in Stored procedure - help!
  110. Scripting from two servers - possible?
  111. How to calculate the midpoint
  112. Striping and splitting
  113. Tool for comparing result of 2 stored procs
  114. Tool for comparing result of 2 stored procs
  115. error when running the DTSRUN command
  116. Basic Anatomy of Sql Server
  117. Get only Max of each distinct?
  118. Assertion Problem in SQL server 2005
  119. constructing varchar computed column , using bit fields
  120. How do I pass a parameter to a DTS ?
  121. DTS package to update Database by reading text file
  122. Copy table column names from SSMS Object Browser to use in a query
  123. SQL Enterprise Manager on Windows Vista
  124. sp_create_trace throws Errorcode = 12
  125. how to concatenate in sql server
  126. Updating Primary Key
  127. Unicode characters as separators...
  128. How to add a PK column to a View?
  129. Web Interface Development
  130. Output in a Single Table
  131. max number of instances?
  132. Insert Multiple Rows
  133. Numeric to real type
  134. Server Problem:
  135. Stored Procedure Output, why only 1 row?
  136. Duplication
  137. Running ACT! 2008 Database on two Laptops
  138. Transaction Isolation Level
  139. Transaction Isolation Level
  140. database structure design help pls
  141. Tracking Record Lineage, Family, etc.
  142. Convert HH:MM:SS into seconds
  143. update hierarchy
  144. SQL - how to - I need a query solution, no coding....
  145. Odd issue with LIKE operator and variable
  146. Changing Where Clause Based on Parameter
  147. Left out join
  148. Running SP versus SQL Statements
  149. ORDER BY error, need help!!
  150. Deleting Records From Sql Table
  151. Error 7874 Can't find the object tableName
  152. Executing SQL Package
  153. Does there have any undo or rollback function in SQL server?
  154. SQL query question.
  155. Ms Sql Server
  156. I am trying to install and config MySQL ... if there is a FAQ I will read ...
  157. System Center Data Protection Manager
  158. How to run a query file
  159. Help with SQL query?
  160. Little function question
  161. problem regarding update after in a trigger for automatic update of date
  162. SQL Server 2005 'Insufficient Memory to run the query'
  163. Drop Default Constraints
  164. How to select different databases
  165. CLR Assembly redeploy problem.
  166. Create Index
  167. Large Data Extract - Improvements?
  168. DB Backup - Single User Mode
  169. Uusing MAX() function
  170. get some rows into one column
  171. SqlClient connection to SQL 2005 creates 5000 tcp connections!
  172. Error - subquery returning more than one value
  173. Problem In SQL Server 2005 Replication On Port 2433
  174. store resume to database
  175. Open SQL 2005 database question
  176. problem using stored procedure to insert records into table
  177. CONTAINS and wildcard
  178. Can't figure out Sqlconnection in C#
  179. Error message in DTS
  180. MSSQL to Oracle Migration Performance issues
  181. indexes
  182. Backup time increasing
  183. Two Tables with Left Outer Join & Where Clause
  184. Sql Server-Duplicate records
  185. complex SQL query
  186. How to update A Single Column data from one table into another..
  187. Custom columns names for custom reports?
  188. Sql server-Help me with a query
  189. Shortcut For QA
  190. Sql Command For Dates In Delphi-5 Sql Builder
  191. Get value from query to update another another table
  192. Using RS.EXE to export a report from Command Line (URGENT)
  193. Need to retrieve Top N records AND Bottom N records
  194. using sp_helpdb to get size of DB's. (Or another way???)
  195. SQL Express hiding
  196. Sql 2005 Reporting Services
  197. How Do you Authenticate People in Reporting Services 2005 Over the Web?
  198. SQL remote user bandwith requirements
  199. Linking FrontPage to MS SQL
  200. Dynamic date setting in loops
  201. To know how many clients connected to SQL server
  202. Microsoft SQL Server Certifications
  203. sending html and plain/text email using msdb.dbo.sp_send_dbmail
  204. SQL Server 8.0 column error
  205. SQL Server 2005 SP2 update 2 rollup Performance tank
  206. MS SQL (Grouping then Summing)
  207. Transfer Image data to MS Access
  208. how to exit from a cursor loop on a specified condition
  209. Can some explain this to me?
  210. insert data type smalldatetime
  211. SQL Server Speed Problems
  212. wrong data type?
  213. retrieving a string into mathematical expression
  214. Count Problem Urgent
  215. Weird speed problem
  216. Count Problem Urgent
  217. Regarding DTS Services
  218. SQL Server Express under Visa linking to a pocket pc
  219. error_message()
  220. Access 97/SQL 2000 Problem
  221. Subquery with invalid column name runs
  222. SSIS Packages Not getting executed from Client.
  223. find rows within seconds of top of hour
  224. Sql Rounding Up And Down
  225. unable to open user default database
  226. How to import/export data in SQL Express?
  227. xml data processing in procedure sql server 2005
  228. how to pass the dynamic value in sql server2005
  229. How to simulate Replace() function on datatype TEXT column?
  230. Create new table with fields from 4 other tables
  231. Schema of Stored Procedure/View and UDFs
  232. SQL 6.5 to 2000 conversion
  233. Select first row only
  234. Deleting the primarykey and foreign key columns in a table
  235. Convert Varchar into Int
  236. Adding an existing database to Visual Studio
  237. repeated words retrival
  238. SQL job with winzip hung
  239. Schema in server
  240. how to retrieve values from four tables at a time
  241. Calculation on same table with same column
  242. Selecting Fixed No of rows from table and that rows should be dynamically selected
  243. Cannot update some records on Sql server 2005
  244. Insert data + XML
  245. MS SQL Management Studio Error: An error occurred while executing batch
  246. MSSQL Data View Problem
  247. SQL Where Clause Date Parameter
  248. sql
  249. SQL 2000 Reporting Services - Need To Get Files Out
  250. Bit of help before my head pops.......
  251. Reusing a generated column to avoid over processing
  252. Return result of dynamic query from function
  253. How to copy distinct records from one table to another using SQL 2005
  254. emptying database
  255. view
  256. More than 8000 characters
  257. Print between each gropu of the select clause
  258. pick out characters
  259. Indexes on Large Data Extract
  260. Autogenerating values in a column while entering data.
  261. ms sql server 2000 personal edition
  262. design Index problem
  263. auto increment
  264. Wrong result Set when using NoLock
  265. Error:SQL SERVER DOES NOT EXIT OR ACCESS DENIED CONNECTION OPENED , INVALID CONNECTIO
  266. how to form one column values to two column in sql server 2005
  267. Prblem With Inserting Data With Identity
  268. Update Record With Min Values
  269. Using REPLACE to replace multiple values in query result
  270. filter data - SQL
  271. Update a table using data in another table
  272. fastest way to deduplicate a list
  273. Books in Spanish for Database Design and Normalisation?
  274. SQL Server 200 XML Parsing Cursor Problem
  275. How can i store data ?(encoding and data type)
  276. problem with count query
  277. Getting data out of table
  278. Multiple rows combined into onerow and onecolumn separated by a special character
  279. MS SQL: syntax error in create table sql
  280. Column or Field variable for an Excel query.
  281. configure sql server details
  282. Adjacency model problem
  283. cast to integer?
  284. Picking out a part of a string...
  285. Wrapping T-SQL in Function and it gets very slow.
  286. pass Column Name using Parameter in SQL Statement...
  287. Corba , Msp
  288. if else statement inside a where clause
  289. Help In Scripting A Search Procedure
  290. Dear Experts
  291. Query to produce column names at top of results?
  292. sp_recompile script/stored procedure
  293. Create a table using data dictionary table as input
  294. indexes
  295. Transposing Data of Table as Columns in SQL
  296. stored procedures: illegal characters and sql injection?
  297. Run SQL script on Instance Startup
  298. SQL Case
  299. Student needs help with editions
  300. Concatenating string to subquery result?
  301. Using the wildcard character
  302. Yellowfin Release 3.3
  303. How to return unknown number of items back in onw row
  304. varchar function sql server
  305. Xml Cdata
  306. Xml Cdata
  307. Set a variable to result of executed dynamic query
  308. Automatic database backup
  309. How to find SQL Servers & Databases in Each server using BATCH File?
  310. data types
  311. how to find out a locak level set for a table. Strange problem
  312. Application Server on top of SQL Server
  313. Search related tables
  314. Search related tables
  315. SQL 2000 DTS Error: Invalid Column Length
  316. Solution: Invalid STDGMEDIUM structure error in DTS package
  317. define unique keys
  318. To update in a stored procedure
  319. delete database file on server -> sharing violation
  320. I want to update several tables using one stored procedure How can I my SQL code att.
  321. Need Help Writting A Simple Stored Procedure
  322. What are these queries used for?
  323. Connect MSSQL remotely by Query Analyzer
  324. Getting second or third largest value
  325. Laws against copying the whole database structure and scripts.
  326. Current Date
  327. SQL Server-delete query
  328. transactions
  329. Update 'YEAR' in DateTime datatype Record
  330. a ouple of questions about ms sql server
  331. is there a system table with the rowcount of each table?
  332. If Else + ...
  333. Writing a query with parameters
  334. Sqlserver
  335. RSS to SQL?
  336. SQL 2000 Adding a column identifier
  337. SQL 2000 - stored proc
  338. updating part of the field.
  339. mmsql - transact
  340. large data management
  341. read text file
  342. hiiiii
  343. SQL Log & data file timestamps not changing
  344. sql server doesn't work well with 250ms+ network latency
  345. table columns
  346. .bak file format?
  347. Service stop/start/restart questions 2005 SP2
  348. i need help
  349. Current month?
  350. SQL 2000 - LIKE Statement
  351. Help with column constraints
  352. User Mapping
  353. Conversion of updates in Access to SQL Server
  354. Sql Mail
  355. Create DTS with two databases
  356. retrieve first record of each customer
  357. Sql Server
  358. SQL Server - High CPU Usage
  359. SQL execution slow over the network
  360. string or binary data truncated.
  361. Database Protection and Auditing Tool
  362. A probably over and over again asked question of Syntax - Help please
  363. select query
  364. Sql Server-How to get the sequentiality of rows?
  365. How do I link a database in SQL
  366. Query Variables
  367. Link to good on-line documentation
  368. retrieve Identical records between two sub query
  369. Retrieving the AutoNumber field value of a recent INSERT
  370. How can i protect sqlserver 2000 by password
  371. Creating schemas
  372. Speed Issues After SQL Upgrade
  373. Indexed View Crashes ASP.NET App
  374. variables and temp table data
  375. Using a cursor in a trigger - Is it the best method?
  376. Syntax error in FROM Clause
  377. how to query for a column value that contains dashes
  378. How do I export sql data to an excel spreadsheet?
  379. Select where date question
  380. Would special character cause insertion problem?
  381. How to create a table from existed table.
  382. How to insert a xml file in sql server database using asp.net?
  383. How to display only user tables in sql server 2000
  384. sql server 2005 issues
  385. transfer of data from databases
  386. Order By date and time of insert
  387. Connect to SQL Server from Vista Client Issues
  388. applying defa values for tables from 1 db to another
  389. Cursor required for update?
  390. Using Shared Data Source in Web Form?
  391. MSSQL- Connection pooling - SPID - KILL
  392. Get Column Name
  393. How to get Regional Setting with T-SQL
  394. max() throwing up group by errors, please help :D
  395. MSSQL2000: PIPE Delimited Issue
  396. how to place a varchar type variable in Dynamic Query?
  397. Enterprise Data Architecture
  398. Count function
  399. Pass Parameter to Stored Procedure in Reporting Services
  400. Implications of not using sp_helplogins?
  401. replication in MSSQL2005
  402. Changing datatype from int to decimal
  403. any one help me for the case of "case statement"
  404. quary not giving desired results
  405. A challenge in Operators-Alarm
  406. Sql Server-How to insert values to database?
  407. How to use recursive CTE
  408. customize sql header result
  409. Using sum to multiply one column by the other
  410. Variable as field name in Update
  411. How can I change the column width?
  412. Collation Questions SQL Server 2005 SP2
  413. datatype
  414. Delete all data in the database
  415. How to Execute SQL Scripts using Batch file?
  416. Delimited Fields
  417. Eliminating Duplicate Rows In SQL SERVER 2000
  418. To Generate serial number automatically
  419. SQL Server 2005 database - Problem
  420. Remove Fields From results from Innerjoin In Sql
  421. Linked Server to DB2
  422. MSDB of SQL marked Suspect
  423. Can a View be protected to support "JOINS" only?
  424. bulk inserting uniqueidentifier column
  425. working with Date and Time
  426. Writting to same Database(SQL Server) via Front-end(VB 2005) and Web(ASP)
  427. group by week
  428. Delete Guest Owned Tables
  429. Losing Null records with Left Outer Join (SQL Server 2005)
  430. 01/01/ and whatever year is coming as current year -1
  431. what is use of smo
  432. two lines SQL update statement but got a error
  433. An exception occurred while executing a Transact-SQL statement or batch
  434. How can change retrieved data in storedProcedure
  435. Date Function
  436. How to select a word substring in a coumn header from right to left
  437. implementing checks on table content
  438. how to store and retrieve image files in sql server
  439. Relationship Problem
  440. how to get the date 2years before
  441. Opinions on SQL Server hardware
  442. Sql Server 6.5 Client Tool and ASP.net
  443. MS Sql query
  444. Some body write a query for me.....
  445. Writing Query to change the way that the data is presented
  446. MSSQL with evc++ application
  447. Is this possible in SQL Server 2000 and MySQL?
  448. hi
  449. Linked Server Query Problem
  450. How can I add picture in microsoft sql server express 2005?
  451. Full Text Index
  452. problems with restore (.bak)
  453. What is a 'master table' and how is it created?
  454. retrieve duplicates
  455. Date comparation
  456. How to populate an empty table using INSERT commands
  457. the best way to: SP B exec SP A where A returns value
  458. Problem with object owner not dbo
  459. Dynamic Tables Names and Temporary Tables Options
  460. How to populate the word template data fields using SQL server
  461. Count-problem
  462. How to write A Test Script
  463. how to update DATE column in a table
  464. Linked Server to DB2
  465. Create Batch file to run sql scripts
  466. Unable to Upload files to MSSQL database Using ASP
  467. Finding table size (physical disk space)
  468. SQL Error Causes and what might fix it
  469. Finding table size (physical disk space)
  470. Retrieve next lowest number in mixed set
  471. How To Change Just Year from a column(DueDate)
  472. SQL2005 database backup files
  473. SQL DATE to determine years
  474. UTC to datetime
  475. Question when subtracting two queries
  476. can you please correct this syntax.........
  477. 2005 Trigger Error
  478. How can I put this XML file into SQL Server...
  479. Error when connecting remote SQL SERVER
  480. SSIS and VB
  481. union in trigger
  482. SQL 2005 license downgrade to 2000
  483. Notification Services Updates
  484. negate RESULT SET, all inactive client
  485. SQL Server 2005 Query Error
  486. SQL Timeout Errors - Can Anyone Help?
  487. SQL Server Refuses to Process Inserts
  488. Creating a BCO format file
  489. Query Help: Select Max of Grouped Sum Data
  490. join tables
  491. multiple sql queries in a join?
  492. ms sql 2005 developer edition
  493. JOIN Error...Need a little help
  494. SQL Count
  495. MS SQL script help needed
  496. Please help me out
  497. How to transfered the data?
  498. Force Parallelism
  499. Getting Started with SQL
  500. View contents of LDF file
  501. varbinary vs image
  502. SQL Server 9 - Vista 64 - Error message in Event Viewer - interactive service
  503. replication or mirroring
  504. DSN ODBC pwd not saved when SSIS package imported
  505. Search Criteria
  506. using date
  507. Exporting a MS-SQL database
  508. Copy data in table in different SQL Server
  509. UPDATE - Help!!
  510. Response time for a View.
  511. Query to switch recovery mode
  512. SQL Configuration
  513. The Two Standards of the Sql CTE
  514. Do you know what the Sql CTE really is?
  515. Import/Export Tables - Enable Identity Insert Does Not Work
  516. Order By in a View
  517. Sql Report: Formatting PDF File Problem
  518. Case Statements
  519. Finding common joins
  520. Select distinc records from a table column but display all columns
  521. Need to add a new column to an existing table with 37M rows
  522. Reports of users
  523. Database Security
  524. space allocation
  525. Alternate to cursors
  526. web database question
  527. updating fields from related tables
  528. Problem accessing remote sql server
  529. replication
  530. SQL Sub Queries?
  531. complex tables - want to join to get one row of results from multiple rows
  532. Extract datas
  533. dumb question
  534. Can't get this darn thing to work!
  535. Select all records from one table, and count records in another table
  536. I want to parse @ArrayOfDays into @d1 through @d5
  537. Table design - PK - unique constraint?
  538. Uppercase all rows in SQL
  539. Sql Exception (0X80131904)
  540. How to group by this SQL statement
  541. Users Logged In
  542. Oracle Database Migration to MS-SQL 2005
  543. Database design problem
  544. how to write an if statement in stored procedure
  545. Comparison or LOGIC issue *Newbie
  546. nt authority\system?
  547. Query results from a DTS package in SQL Server 2000
  548. my sql
  549. join two tables
  550. strategies for paging