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