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