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. isqlw won't start
  2. Timeout expired while retrieving data from table
  3. Stored Procedure retrieve Parameter values from variable
  4. Analyst seeks help with one table query
  5. Change Administrator
  6. how to create mail merge with word 2003 and sql server 2000 as database
  7. Join query not displaying all records in one column
  8. Sql Server Query - won't display zero returns
  9. a small SQL Puzzle
  10. SQL Insert
  11. Comparing like column strings in two tables
  12. Comparing more than one column & update
  13. Join select statements
  14. Advantages of storing datas in hexadecimal or octal formate
  15. resultset in a single row
  16. what is the use of nvl clause in sql server
  17. "Violation of PRIMARY KEY constraint" when no duplicate exists?
  18. multiple queries and single query
  19. SQl Insert multiple requests into one column
  20. Users limited access by IP
  21. autoincrement question sql 2005 server
  22. BIRT + Yellowfin + ANN mashup make Advanced Business Intelligence
  23. SQL Query from Access to SQL Server
  24. ALTER columns to remove the IDENTITY property
  25. query to display name and average salary who are having age>50
  26. Alter column datatype and default value in a table
  27. XML data in SQL Server
  28. outer joins in MSSQL
  29. Survey results combined
  30. Exporting MSSQL database
  31. Syntax for Writing Stored Procedure with Parameters
  32. ODBC-- call failed.
  33. how do I inner join two table to a dataset
  34. subtraction of different precision values
  35. Computed Column with bit data type
  36. Case Statement Problem
  37. Find Best Match
  38. query to copy the records from existing table to new table
  39. Converting Rrom Access Syntax To Sql Syntax
  40. No field delimiters using bcp command
  41. Removing duplicate records and to store in new table with single query
  42. Incorrect syntax near the keyword 'AS'.
  43. NAS for Clustered SQL Server
  44. script for comparing tables
  45. How to merge multi rows to single row?
  46. comparing dates in two tables
  47. Generate Scripts
  48. Sql server 6.5 Restore
  49. Attendance information retreival
  50. Merge Replication nested view replication problem
  51. SQL Mail setup
  52. T-SQL update dynamic tabels
  53. Read information from excel file into ms sql table ?
  54. select statement help
  55. cant connect to my databse in lan
  56. Dynamic column names
  57. INSERT statement problem
  58. Conn. Prob. contd: 'logon restricted' [Mngm. Studio]
  59. Stored procedure required
  60. PHP code to Stored Procedure
  61. Minus query
  62. Strange Connect Problem
  63. Trouble creating triggers in SQL Server 2005
  64. connect string problem
  65. Do foreign keys generate implicit indexes?
  66. SQL Statement Help Please
  67. Trouble with Query using MAX
  68. Sql query datediff syntax error
  69. Audit table, finding first change for each item
  70. query by time
  71. DateDiff Function
  72. Altova Software v2008 (with MS SQL Server support) is now available
  73. ODBC problem
  74. Nested IF Statements
  75. Importing database
  76. xsd schema into SQL Server Enterprise Manager 8
  77. SQL Server 2000 Remote Access
  78. Microsoft Dynamics GP
  79. Sql server 6.5 device files
  80. Arithmetic overflow error converting expression to data type int.
  81. string functions in sql server 2000
  82. How to export whole database schema to another database but not include the data?
  83. Deleting duplicate data after comparing it with other table.
  84. Create Function permission...
  85. Data import question - SQL
  86. how to debug stored procedures using SQL 2000
  87. SQL Case Statement Problem
  88. number of databases in sql server 2005
  89. SQL Server 2000 to DB2 DTS Package - Permission Denied Error
  90. Delete or detach a Suspect database
  91. CREATE Table permission
  92. Select statement help
  93. line 1: incorrect syntax near '='
  94. How can I delete a row from a table having primary key relation.
  95. CASE Statement - I'm in a bit of a quandry
  96. How Do I give EXECUTE Permissions on Stored Procedures?
  97. how do you use XML to store your data and then call it to update database in SQL
  98. hoe do you use XML to store your data and the call it to update database in SQL
  99. error in stored procedure
  100. Error 40 : Unable to open connection and Security Issue
  101. What should we do in the case SQL was installed without the proper case order?
  102. Pagination in SQL Server
  103. SQL 2005 linked server problem
  104. SQL overlapping date
  105. How to check for the value before you select it
  106. How to select count records that "contain" data?
  107. Summarizing multiple items at once
  108. INSERT works in SQL server 2003 but NOT in SQL server 2000
  109. Changing user schema
  110. Creating a View from a Stored procedure
  111. Nightly Refresh
  112. Market News. QSC partners with Yellowfin Business Intelligence
  113. SQL single file database
  114. gul sql number format
  115. single-user mode in SQL 6.5
  116. ms access table call from sql server2000
  117. ms access to sqlserver data transfer
  118. i want to test database trigers
  119. select query problem
  120. How do I view table information such as constraints?
  121. Problems with URL's
  122. Retreiving Database Structure in VB
  123. Backup and zip the Transaction log file
  124. Using Scalar functions in views
  125. How to work with time in format 'hhh:mm:ss' (more than 24 hours)
  126. win2k3 sp2 and sql server 2k
  127. Comparing databases
  128. How To Create a PDF from a stored procedure
  129. SQL Server 2005 - Merge Replication
  130. Need Help BAD... SQL table drop problem
  131. Design Table; Columns/Description get with SP???
  132. Design Table; Columns/Description get with SP???
  133. SQL Pass Through to monitor backup and restore
  134. Truncating duplicate entries in a table
  135. Truncating duplicate entries in a table
  136. a webpage that directly inputs data to a specific table in an sql database ?
  137. Date Operation
  138. SQL 2005 Backup Jobs
  139. How to extract data from one database to another
  140. what is the difference between sqlserver and oracle,sqlserver 2000 and sql server 200
  141. charindex with error handling?
  142. Backup and zip the Transaction log file
  143. DUMP transaction LOG
  144. Reading from SQL Server
  145. Sql Server Double Messages
  146. Change from Full Recovery to Simple Recovery Mode?
  147. trying to update a table with web developer studio 2005
  148. ODBC & Remote SQL Server
  149. time conversion hiccup
  150. Dynamic Where Clauses
  151. How to match Partial Values
  152. SQL Server 5 basic question
  153. creating tbl permissions
  154. BCP derived fields
  155. SQL Query to sum accross the row
  156. Basic Question on Joins
  157. how to call database stored in a file to update the other database on SQL Server
  158. MS Sql replication - Primary keys problem
  159. MS SQL compare columns to generate display name
  160. validation of only dd in DD/MM/YYYY date format
  161. SQL 6.5 server connection problem
  162. BCP Problem
  163. Create procedure to insert records for a project
  164. Any alternative for stored procedures in MySQL 4.0 ?
  165. Retrieving the rows...
  166. SQL to Text file
  167. Get unlimited visitors to your website
  168. Error while using DTS package
  169. Monitoring MSSQL server 2005 from Linux
  170. Require Solution for this SQL problem
  171. Require Solution for this SQL problem
  172. making datareport in SQL Server Provider
  173. Select Records and Insert into Text File?
  174. Unable to get Query Results to display in a single row
  175. sql 2000 personel addition
  176. Reducing many-to-many to one-to-one
  177. Search for specific length string in column
  178. SQL Enterprise not updating table
  179. To get all of the columns except for certain ones
  180. Alter Table
  181. HTTP POST in SQL Server 2005
  182. Open Forum 4 ALL
  183. Opzn Forum 4 ALL
  184. Call a Stored Procedure within an SQL statement
  185. Alternative for stored procedure in MySQL
  186. Trigger & XP_Cmdshell
  187. Having trouble with GROUP BY ...
  188. Stored Procedure Vs UDF
  189. How to ensure the right number of records gets updated
  190. indexes
  191. mssql8 AND mssql 2005
  192. HELP ME! Error occurred during creation or modify of a DTS Package
  193. SQL Procedures
  194. Replication issues after a Database Restore - Unable to drop or create Transactional Replication
  195. Violation of PRIMARY KEY constraint 'PK_Insured_Person'. Cannot insert duplicate key
  196. Storing pictures in database
  197. Merge two records
  198. SQL 7 & Server 2003
  199. index tunning
  200. selecting top 10 entries from multiple groups
  201. Getting the last inserted row by smalldatetime
  202. Do you understand this Error msg (ERROR Msg 512, Level 16, State 1, Line 33)
  203. Deleting multiple records from a datagrid using cursors
  204. output data of the table
  205. selecting value from a drop-down menu
  206. T-SQL to find commas in database
  207. RE: CASE Statement, works but.....
  208. How to insert another WHERE
  209. Select a field twice with different (special) conditions
  210. CASE Statement
  211. Online SQL Files?
  212. Database Diagrams export
  213. import database to another server - howto
  214. Help with UPDATE trigger
  215. How to delete 1 record from defferent tables?
  216. sql-How to convert a table data into XML
  217. store result of query into a variable
  218. Flat file to DB using DTS
  219. Joins for more than two tables
  220. Set password as 'password'
  221. Trying to create a linked server from an SQL Server to another SQL Server on another machine.
  222. Syntax Error on a DTS Package script
  223. Deleting Records From A Table
  224. How would you... (binary info in a table)
  225. integratedSecurity login from Linux -> SQL Server 2005?
  226. Query Help using SQL Server
  227. One to Many with a "Not In" component
  228. Drop and recreate constraints
  229. simple OUTER JOIN (I thought)
  230. sending a mail alert to job seekers
  231. Database Restore Checklist and sql2005 running on virtual machines
  232. Can't log in as sa
  233. Locks the tables while running Report..VeryUrgent
  234. Database Backup using Query analyzer
  235. about restore
  236. updating tables in two servers
  237. Kill user connection from database
  238. views from different database
  239. Avoid Inserting Duplicate Entries
  240. SSIS package configuration
  241. SSIS Extract fails without much error.
  242. one column text with multiple records to multiple data coulumns
  243. Kick off Stored Procedure to run Nightly?
  244. AnsiNulls property broken
  245. Error 26 message
  246. CREATE TABLE syntax error...
  247. Phone number conversion to XXXXXXXXX
  248. Deny user roles from a Stored Procedure.
  249. SQL query
  250. Please Help!!! Sql 2005 How Can I Convert Columns Into Rows
  251. expire a user account/login in sql server2000
  252. sql mail
  253. Understanding tables as variables
  254. Retrieving the contents of Cell based on values
  255. Compare based on table values.
  256. If you really want lauf, cklick down on the link:
  257. Multiple records in one row
  258. password storage
  259. Live updates?
  260. Streaming database updates?
  261. Add records in a table
  262. Updating a row in a recordset
  263. JOINING 3 Tables Using LEFT OUTER JOIN
  264. Help with the IN() function
  265. How to get the position of a character in a column/String
  266. Opening existing project
  267. merge two database with all objects
  268. Mapping tables
  269. unable to load dynamic library....
  270. char vs varchar and indexes
  271. How to Delete a Chile Records from a Parent table ?
  272. How to write a query that selects all except...
  273. Adv. SQL Query Help
  274. Crystal Reports Date/Time Issue
  275. SSIS - how to fail the package when the for each loop container finds no files
  276. Complicated query
  277. Complicated query
  278. Get Sql Date Format
  279. CASE and DATE statement - Need Help :)
  280. SQL WHERE EXISTS vs. SELECT *
  281. JDBC connections w/ AD login?
  282. Log File (LDF) ???? (HELP)
  283. Rename a MS-Access table using SQL Query
  284. sql instalation
  285. sql rules and udt
  286. Is possible to create dynamic reports based on cubes?
  287. use fetch to retrieve and then update or insert into another DB table
  288. cursor and fetch statement
  289. how to use multiple delimiters for the same flat file
  290. creating a back up [create and insert statement] for a table in mssql server 2005
  291. update or insert data from one table to another
  292. Sending Mail
  293. Ms Sql
  294. Help needed: Granting Create table permisions on specific Schema Options
  295. Download
  296. sql server does not exist or access denied
  297. Broken Lift Chart and Empty Classification Matrix in Data Mining
  298. Importing images to SQL Server 2005 Express Edition database
  299. Data fetch from database
  300. Need Help to do a GROUP SUM
  301. Need 2 reduce Physical Log Size on Disk
  302. Export data from DTS
  303. Return comma seperated value
  304. SQLServerAgent
  305. Database replication
  306. ms sql server
  307. Changing data-types
  308. How to count the number of records in one table and update the count to another table
  309. String/Date Concatenation causes conversion error - streamline fix suggestions
  310. Wrtting to the text field
  311. Getting a Stored Procedure to wait 20 seconds
  312. views and stored procedures
  313. Format for six character date
  314. Beginning question about coping/moving a sql database
  315. SQL 2005 - linked server between 2 databases on one server
  316. Advanta releases ATLAS BI using Yellowfin Business Intelligence
  317. Getting the Auto Generated Column values after Insertion
  318. Difference between SQL Queries
  319. what's the syntax in getting the Age with birthdate given
  320. Field Generating
  321. Snapshot query
  322. Help with Like Query
  323. regarding data types
  324. setting a null value to zero in a stored procedure
  325. SQL Logshipping 2005 - Load Delay Period Problem
  326. How to slipt the values in SQL server
  327. SQL query
  328. I need help creating an SQL Script for MS SQL 2000 Server
  329. SQL help urgent
  330. How can you assign system objects to a variable?#$@!
  331. Ms Sql 2000 Stored Procedure Help
  332. Use Bulk Insert Statement with JOIN !!
  333. fetch url from database
  334. group by
  335. How to View Results from a Stored Procedure in a Listbox
  336. Apparent DB engine bug in SQL Server 2005
  337. MS SQL Server 2000 -
  338. Round number off and change to currency
  339. Trigger
  340. problem with subselect
  341. Change "Group By" data in one column into multiple columns based on Group
  342. Joins
  343. Query across two tables
  344. Migrating Database changes to Production
  345. Comparing columns in SQL server 2005
  346. Organizing MSSQL database???
  347. SSL SECURITY ERROR : CONNECTIONOPEN 9SECDoCLIENTHANDSHAKE
  348. SQL 2000 Trigger Question
  349. forming a string with dateparts
  350. SQL Server 2000 Date Format
  351. TDS and character encoding
  352. Help Needed For Date field (Age) Calculation In SQl query
  353. Sql Files
  354. Collation Question
  355. Counting how many RI levels deep for a table
  356. Converting GetDate() to current date with a specific time
  357. Locking
  358. Incorrect Counting Total -SSAS
  359. passing parameters using select * Like
  360. SET NO_BROWSETABLE ON ?
  361. retrievng text or ntext data from column whose data type is ntext/text
  362. Backup on Network
  363. Schema Change of the table which is under replication
  364. No Notifications appears when converting text column to varchar column
  365. Getting error while inserting the rows using linkedserver
  366. T-SQL or stored procedure to find employees with salary in top 5%
  367. SQL Error Logs - changes to DB states and detachements
  368. Reporting Service: Drillthrough parameters didn't appear in the report.
  369. fatal error
  370. SQL Turbo (Quest Software)
  371. Using variables for the parameters in DATEADD
  372. Who's online?
  373. update date in one tabe with year from table1 and md table 2
  374. Using MS SQL 2000 .bak file with SQL2005
  375. To display Selected data from One web user Interface page to next on Button Click
  376. How to convert data into xml
  377. sql server 2008
  378. DTS copying incorrect objects
  379. Sql Error When Trying To Install Sage Act
  380. CPU Time usage shown in EM-CurrentActivity/Process Info
  381. Using SELECT INTO within a Scalar Function
  382. Joins or Temporary tables
  383. Connect by in SQL Server
  384. Finding out triggers in my database
  385. Volumn Shadow Copy Errors
  386. Sum Case Function
  387. Query to copy rows in a table with a change in two columns
  388. copy users on server to another - SQL 2005 SP2
  389. Problem Connect to Reporting Services via Mgmt Studio
  390. Replace
  391. uniqueidentifier Type
  392. how to setup sql server on home pc???
  393. Invalid column name error in sotred procedure
  394. Problem in DTS
  395. MS Access Macro Scheduling
  396. restoring msdb from a network tape backup
  397. SQL2005 login failure
  398. Join criteria and the Where Clause...
  399. Restore sql server express bak file as different db?
  400. how to change an existing table column to autoincrement with out affecting the data
  401. retrive the last saved date in table to select method in another page
  402. Communication link failure
  403. how can i send mail by using sql server
  404. SQL Query to sum values across 4 tables
  405. Query to reduce a 1-to-n relationship to 1-to-1
  406. SQL Server Conversion
  407. SQL Server Conversion
  408. Convert INT YYYYMMDD to date mm/dd/yyyy
  409. Convert CHAR YYYYMMDD to mm/dd/yyyy
  410. SQL Server 2005 Reporting Services Problem
  411. help with while loops
  412. Convert MS IIF STMT to SQL Server 2005
  413. Ntext column value to a file
  414. getting erorr Procedure 'up_reason' expects parameter '@EmployeeNominationID', which
  415. Deleting repeated data
  416. File upload into sql server
  417. Dynamic Columns
  418. Getting string part based on some character in MSSQL
  419. to query all days of a month
  420. getting the data from more than one table
  421. sql select max note for a row and join
  422. replacing string problem, please help
  423. SQL 2005 - Full Text Index question
  424. Some explaination needed on problem exporting a database
  425. Linking MS SQL tables into MS Access 2003 - too many indexes
  426. How transfer user accounts from SQL7 to SQL2005
  427. Run all .sql files (scripts) in project (SQL Server 2005 SP2)
  428. Amazing - Case Sensitive SQL Server 2005
  429. Unbelivable - SQL Server 2005 is Sace Sensitive
  430. Problem with Subscription
  431. Need Help with SUM Query
  432. Return DISTINCT Values
  433. column name and value in rows
  434. SQL sever 2005 express move windowns authentication choice to mixed authentication
  435. Restore LDF file after restoring backups in SQL Server 2005?
  436. How to find day from date
  437. Help me
  438. set a time out on a value
  439. Mapping tables to stored procedures
  440. Creating a sustaining counter as in work orders - unique
  441. Error converting data type varchar to numeric.
  442. Need to find instances of duplicates within a column; joining 2 tables.
  443. Runtime error
  444. Stored procedure to update multiple table same time
  445. REPLICATED SERVERS Index FT Data differently.... WHY?
  446. Can't sort duplicates SQL Server 2000
  447. Need help w/ a script
  448. distributed transaction problem ?
  449. ssis EXEC command
  450. HELP: Multiple GROUP BY !!!
  451. Problem with DB_OWNER role..
  452. Questions on inserting jpeg image into SQL table
  453. Help Please
  454. My question is in SQL
  455. Using an Aggregate in the GROUP BY
  456. Trigger: Update
  457. Rewrite from TransactSQL to CLR on c#
  458. Transact SQL Help
  459. Problem while 'clr enabled' in SQL Server 2005
  460. MS SQL dealing with duplicate columns in rows?
  461. alter colum
  462. losing ms sql server2000 data
  463. converting rows into columns when the count is not known
  464. Urgent Query
  465. Update Statement in Table - Please urgent help required...
  466. An expression of non-boolean type specified in a context where a condition is expected, near ')'.
  467. A floating point exception occurred in the user process
  468. SQL Server error
  469. ACT7 instance of Microsoft SQL server 2000
  470. Trigger SQL Server event from MS Access
  471. Error Msg 8120
  472. Log Shipping
  473. MS SQL Replication
  474. SQL Server 2005 Express Edition
  475. Help On Trigger
  476. Query to get the names of items with different levels
  477. Delete duplicate rows from two tables with same structure
  478. how to design social network database
  479. MY SQL trigger(PK generation problem)
  480. Dbms/rdbms
  481. Searching and matching string field
  482. Searching and matching string field
  483. Delete rows in relational database
  484. SQL SERVER - Access more than 0ne instant
  485. setting value to sql varialble thru access
  486. Excellent Resource
  487. inserting into db not working
  488. Update Specifc Record in Non-Referenced Tables
  489. How to check if a Table is <empty> ie doesnt contain any rows
  490. MSDE Database
  491. Subquery returned more than 1 value. This is not permitted when the subquery follows
  492. Connection problem with SQL Server 2005
  493. how to retrieve random values from a database table
  494. Changing Owner
  495. SQL Server
  496. Combine record
  497. Summary script
  498. Search and replace on all columns
  499. Join problem
  500. TABLESAMPLE question
  501. Sqlstate 22007 Sqlcode -181
  502. Algorithm for large set comparison
  503. Invoke Oracle procedure from SQL SERVER
  504. Trigger Help
  505. How to create an admin with some limitations?
  506. Pass Parameters to select Query
  507. Data base growth control
  508. Best way to capture/export about 45 fields - 3000 records
  509. Need to insert a header in a tsql select to run in an SSIS package
  510. WHERE question
  511. Geographic Locations in a database
  512. Passing table name to Stored Procedure
  513. import xml using ssis
  514. Inserting date issue
  515. SQL View of MS Access
  516. Change SQL from DAP
  517. Displaying Updated Columns
  518. Need help rewriting a subselect as a join
  519. IF Statement Error
  520. Blindare utente SQL amministratore
  521. Knowledgeable yet simple book for database modelling or database design
  522. ODBC Timeout problems but very hard to pin down
  523. Problem with logshipping, but no errors
  524. MS SQL copy new and modified rows from TABLE1 to TABLE2
  525. Problem performing remote queries
  526. Getting error while creating a trigger with INSTEAD OF UPDATE
  527. wants sql query
  528. Calculate leave days from Startdate to enddate of contract
  529. Newbie Question - Service Manager / Win 2003
  530. Arithmetic overflow error converting nvarchar to data type numeric.
  531. how to run dtexec from command prompt
  532. month name from the sql query
  533. Sql Server 2005
  534. Problem in Cursur
  535. How to update table that data came to another table using update trigger
  536. data transfer from .csv file to sql server 2000
  537. SQL Query - grouping?
  538. Reading Results From a Stored Procedure
  539. Increasing Database Size
  540. Need To Create "Back Up" Function
  541. Create script to insert 200 rows into table
  542. Limit query execution time
  543. How to create and delete tables in SQL Server.
  544. date change in sqo
  545. Remote connection Problem With SQL 2005 Thru VB Application
  546. standard and easy way to do schema design
  547. Standard Schemas?
  548. Job Schdule in MS SQL
  549. Replace function
  550. import data from .rpt file to SQL Server 2005 UsingSSIS