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