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