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