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