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. pwdcompare equivalent in Sql2005
  2. Identify Dulicates/Compare data in table to itself
  3. How to update 2 columns at the same time
  4. [SQL Server 2005] T-SQL for configuring replication
  5. Insertion automatically truncates the value
  6. OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005
  7. Need Query help please...
  8. Dynamic Query
  9. No mapping between account name and security ID
  10. Merge data in SQL Server 2000
  11. Copy one column to another
  12. Inserting values Using Stored Procedure
  13. table page allocation
  14. Connecting to SQL Server 2000 Via Internet
  15. Resource to learn code and share code and knowledge
  16. If Statement
  17. Birt201
  18. Quiz help required
  19. Best program for SQL database manipulation
  20. sql server
  21. different datatypes avaliable in SQL 2005
  22. Need Scheduling Support for Your Databases?
  23. how do I return a default record if result set is empty
  24. year month date format?
  25. mssql from linux
  26. Combining Values
  27. Update date field
  28. Mass Update on Table with Trigger
  29. Sending formated Email with database mail sql 2005
  30. Connecting to SQL 2005 using VB6
  31. Mismatch between Count(*) and Properties -> Rows
  32. How can i merge three table?
  33. SQL Hierarchy and Sum on Same Table
  34. SQL Query - Explain please
  35. how to find median in sybase /sql server (Using query)
  36. How to fetch primary key after an insert command? (MS SQL 2005 Express)
  37. How to write QA test Script
  38. Scope in derived tables
  39. Output Column names in each Row along with the row Value
  40. Problems getting return codes from xp_cmdshell
  41. my Log file size is 10GB....
  42. what is back end
  43. Count Parameter not right
  44. DTS Package user permission
  45. How do we know the change history of Stored Procedure
  46. How to make the DTS package fail, when the source table is empty
  47. Is Not Null and Query Optimization
  48. delete rows by checking conditions in more than one column
  49. Finding total and Concurrent number of users logged in
  50. how to stop the query
  51. Stored Procedure Help
  52. DELETE where syntax ... need help :)
  53. Incorrect syntax with Declare
  54. find the size of data base
  55. Performance between Standard Join and Inner Join
  56. SELECT QUESTION
  57. Can I install SQL SERVER 2005 on secondary drive?
  58. find a primary key
  59. How to make a SQL run longer?
  60. the best way to implement batch job
  61. This is a tough one. Help....
  62. mass alter table fields - script help
  63. Parse field into multiple rows
  64. Select rows containing users from same usergroups as current user
  65. sql Cannot resolve collation conflict equals - comparing rows and fileds between Table1 and View1
  66. SPROC: How To Change a Value From Positive to Negative??
  67. Using Pivot
  68. Copying large amount of data form MS Excel to MS Sql Server
  69. delete the databse
  70. Help with Dynamic SQL
  71. Stored Procedure definition not updating, causing DTS copy error
  72. How to find the maximum possible value of a given datatype
  73. Select Using field data length
  74. Concat tables into one row in view
  75. Help with Nested loops in SQL Server 2000-Transact SQL
  76. Permissions and Users in SQL Server 2005
  77. could this be done in SQL???
  78. stored procedure squery
  79. Strange performance issue with UPDATE FROM
  80. select alias -- invalid column name
  81. rman backup in sql server
  82. SQL order by only for non empty fields
  83. Sql Server Reporting service
  84. sql profiler trace file
  85. how to get the sum of the fields ...Very URGENT
  86. INSERT - EXEC never returns
  87. How do I convert Dates stored as int
  88. Finding a column in all tables within the DB
  89. Break in sequence
  90. Executing A File In Sql Query Analyzer
  91. compare 2 values in same solumn
  92. Subselect Query taking a long time in SQL Server 7.0
  93. Navicat ERROR: Cannot connect to MySQL server on localhost
  94. Trigger Deadlock
  95. sql server database tuning
  96. MS SQL Parelleism
  97. problem with highscore
  98. Parallel build and subsequent re-name of a cube
  99. Can any body help me for creating user datatype
  100. Security with SSAS 2005
  101. SQL 2000 date format problem after migration W2k to W2k3
  102. Tracing error
  103. Log Shipping does not Ship to Secondary database
  104. how to reconcile two tables using cursor.
  105. Dynamically input columns feilds in a select stmt
  106. Database design question - Isolated, unrelated tables
  107. MSSQL datadump
  108. date search in SQL
  109. triggers
  110. DB hostname, username, password etc
  111. Table alias in nested query
  112. Insert into two tables using transaction
  113. transpose columns
  114. Trouble with homework
  115. how To Create Auto Generated Unique Identity Code in a SQL Table
  116. error 126
  117. Foreign Key
  118. Sqlserver 2005 restore database
  119. BULK INSERT ignores UNIQUE index with IGNORE_DUP_KEY set?
  120. correct syntax for this select in SQL Server?
  121. count() and sum() on multiple tables
  122. Unable to connect to SQL Server Express Locally or Remotely
  123. Looking for code libraries for aggregate functions
  124. SQL Server Log
  125. BULK INSERT not loading all rows from a text file.
  126. Sql server
  127. Error Locating Server/Instance
  128. Deadlock transaction
  129. union query taken more time
  130. Need to shrink the size of log file
  131. System.data.sqlclient.sqlerror: cannot open backup device 'DLT VS80(\\.\Tape0)'.
  132. Help with Subquery
  133. Data base encodings
  134. Sum result of a Select
  135. Help with SQL IF
  136. Using the same column in bother SUM and ORDER BY? How?
  137. textcopy binary transfer fails on certain files
  138. Viewing backup in a different location
  139. Using CTE Common Common Table Expressions
  140. Insert into a table that has identity column
  141. SQL CASE Statements with IF EXISTS
  142. Migrating SQL 2000 to SQL 2005
  143. MS SQL Linked Servers(Linking MySQL to MS SQL) Collation problem.
  144. SQL Joins
  145. Reduce field data Length
  146. SQL Joins
  147. executing a query
  148. Foreign Key
  149. Need some help with query
  150. Can SQL Lose Records?
  151. Welcome to the -Net User Group
  152. Welcome to the -Net User Group
  153. Welcome to the -Net User Group
  154. Win2003 / Sql2000 Memory usage
  155. Help with a simple query
  156. Read Backup File Directly?
  157. SQL Duplicate Error
  158. User ip tracking
  159. Building Table for Duplicate Records
  160. How to use two pivot columns in a single querry
  161. Microsoft OLE DB Provider for SQL Server error '80004005'
  162. How to manipulate records using SQL
  163. SQL - how to - minimum number of steps
  164. automatic restoration
  165. Update a column
  166. can someone help me pls
  167. how to ignore time and get only date in a query?
  168. Help
  169. passing arguments to a trigger
  170. I need to find the rows that exist in one table but not in the other with condition
  171. Solution needed
  172. Creating table in linked server
  173. How to export/import database
  174. Problem mapping SQL Server mobile and Visual Studio 2005 Dataset
  175. SQL 2005 Function to Convert Dotted IPs to Long IP Format?
  176. Why won't MS SQL allow nullable primary key components?
  177. How to get the error message rather than the code error
  178. sql string
  179. how to make an Update trigger capture the foreign key text value
  180. Max value in SQL runtime
  181. Separating Address Field into Multiple Fields
  182. Alter existing table to add a IDENTITY column
  183. how to delete rows using linked server
  184. DateTime
  185. how do i know who accessed/ran a procedure or query
  186. Date Range
  187. NEED TO GO FASTER
  188. Search: CONTAINSTABLE
  189. Web Server Can't Connect to Sql Server
  190. how to compare 5-10 chars from 2 tables.
  191. Improving SELECT statement
  192. Hiding the Database list from a certain user\group
  193. Delete an excel worksheet only if it exists, in a dts package
  194. tlog size
  195. How To Connect Sql Server 2000 From Java
  196. mdac 2.8 and sql 2005 cursor performace issue
  197. tlog backup
  198. UDF for a complex calculation
  199. JSQLConnect MS SQL SERVER CONNECTION ISSUE
  200. converting char date value in date value
  201. Multi access in SQL Server
  202. T-SQL Pivot type of problem plus AVG
  203. Simple SQL Query need Help
  204. sql server 2000 connection fail
  205. Parameter for Stored Procedure
  206. How to conver 24 Hrs. time into 12 Hrs. time
  207. Simple SQL Query Need Help
  208. Help with database design.
  209. Help
  210. DB2 Viper 2 beta - Compatibility features, Need your help
  211. deadlock help please
  212. Go Through Each Row in Trigger
  213. Help with Setting up a SQL Insert Statment, from a web form
  214. timing out error
  215. Characters not allowed in SQL varchar?
  216. need an sql query for the following situation
  217. Turkish character problem in stored procedure
  218. T-sql
  219. Windows/Linux
  220. Windows/Linux
  221. Sleeping Status
  222. sp_columns
  223. work day fields?
  224. Dynamic database selection?
  225. how to implement fuzzy search using soundex in SQL SERVER 2005!
  226. Error handling with CREATE INDEX
  227. SQL 2005 error: Replication-Replication Distribution Subsystem: agent (null) failed.
  228. Syntax for storing query results from one server to another server
  229. update one colum with other column value in same table using update table statement
  230. Loose connection in vpn enviroment
  231. how to retrieve the value of a primary key
  232. Using SSIS to backup/restore databases
  233. Debugging SQL 2005 SP
  234. Select all tables in a database
  235. Problem in creating foreign key when .....in sql server 2005...pls help.thanxs
  236. Full text indexing on Encrypted columns
  237. Calculations in Database
  238. SSIS sp_send_dbmail
  239. maximum number of fields that can be created in a table
  240. Would like a stored proc to convert rtf field to text
  241. Move Images (BLOBs) from MSSQL to a folder
  242. many-to-many help
  243. Linking sql table in MS excess over dialup.
  244. how to learn
  245. new
  246. how much bytes needed in sql server
  247. bcp_init and SQL Native Client
  248. Transaction (Process ID 474 ) Deadlock
  249. transfer a value from one table to another
  250. Question about simple query..
  251. Error converting data type varchar to numeric.
  252. Modification Logs
  253. how to update foreign key while primary is auto generate int
  254. Creating query that allows user to choose criteria to be used in one or another field
  255. how to convert dvd-binary data-url
  256. Remove the last carriage return and line feed from sql text field
  257. Dynamic RDLC generation question
  258. Visual Studio
  259. Deadlock within stored procedure - need help
  260. User configurable table designs
  261. Creating DTS Package to archive database from one sql server to another
  262. timeout expired
  263. How calculate space that occupied?
  264. MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX?
  265. MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX
  266. Dynamic SQL and NewID function - pulling random records
  267. UPDATETEXT, WRITETEXT
  268. Stored Procedure Local Variables
  269. Trigger problem
  270. Duplicate table
  271. Can't Edit Maintenance Plan
  272. Can't connect to SSIS
  273. How do I execute a .sql file from command promt
  274. Establishing Precedence In ORDERBY Condition Causing Problems.
  275. MSSQL Insert Permissions
  276. sqlserver.exe-Applicatyion Error
  277. database security
  278. Local Admin Rights Needed to Use DSNs on W2K3 Server?
  279. Query help?
  280. can we use stored procedure inside trigger?
  281. hi all
  282. TSQL coding style - an example
  283. parentheses in a check constraint
  284. Lock Error
  285. Download Subform Alternate Colored Rows
  286. SQL Server 2005 with VB.net 2005
  287. How to Gnerate a Random ID Number
  288. Searching Binary data from sql server 2005
  289. Error: Must declare the scalar variable
  290. How to list tables with Primary keys
  291. Bulk Additions & Updates in SQL 2000/2005
  292. SQL 2005 Upgrade on a 64 bit machine
  293. WHAT HAPPENED?
  294. difference between MSDE and SQL SERVER 2000
  295. ALTER how long should it take?
  296. SQL Changing the Result from blank to something
  297. finding mismatched rows between identical tables based on 2 or more cols
  298. Database Design Question
  299. A binary field problem
  300. Syntax error in string in query expression
  301. Connection string to SQL Server database
  302. Build a Data Cube?
  303. Sql server security problem
  304. Login failed for user 'DomainName\shhi'. [SQLSTATE 28000] (Error 18456).
  305. In implicit conversions between char & varchar, are indexes used?
  306. execute a query command string
  307. Changing Datatypes
  308. SQL 2005 trigger Help
  309. SQL 2005 : AFTER INSERT - Trigger
  310. Error: Not associated with a trusted SQL Server connection
  311. Computed Column specification formula
  312. hierarchical selection within a select statment
  313. SQL Server and Net Apps
  314. Domain Change on SQL 2000
  315. float storage and usage
  316. how to quit an sproc
  317. Change name of exported csv file
  318. HELP NEEDED
  319. Unable to schedule DTS
  320. how to access a sql server 2005 which as by default windows authentication
  321. Order by Issue in SQL Code while using temporary tables.. ?
  322. MYSQL to MSSQL or vice versa
  323. Linux Servers
  324. Linux Server(Verified)
  325. Turn off "Documentation Feedback" section of BO for printing?
  326. Update query not working
  327. Strange character in column
  328. xml as sql script ?
  329. How To Script
  330. SQL 2K Combining similiar rows without creating temp table?
  331. Using SQL in VB
  332. Clustering SQL
  333. Problem looping through excel workbooks(sheets) in a excel file in ssis
  334. Full Text Indexing (job)
  335. Merge two exact tables
  336. find server name using query
  337. Linux Servers(Usage)
  338. Deadlock
  339. Extract text from fixed-length text rows to SQL table
  340. best way to add column not null
  341. How to pass table temp to DLL COM
  342. Openquery & Local Table
  343. Data import definition
  344. Help connecting pages which has Database connection.
  345. Returning different table results based upon variable
  346. SQLServer Table Partitioning
  347. Linking 2 Databases
  348. CASE statement advice needed
  349. Maintenance Plan Database Selection
  350. Linked Server, ODBC, OPENQUERY, Collation and Network Traffic
  351. How to?
  352. Problem with foreign key
  353. Bulk insert data conversion error (truncation) for row 1
  354. procedure using cursors
  355. Sub Query Help
  356. jdbc createConnection(String url) throws exception
  357. Restore Database Fails
  358. Nulls in columns additions when 1 or more column values is blank
  359. Copy Row Of Data From Table to Table In Same DB
  360. DTS import with dashes in source data
  361. Database Infrastructure Failover Capability
  362. ADODB Command (Stored Procedure)
  363. INVALID LENGTH PARAMETER PASSED....
  364. Reset Primary ID back to 1
  365. Failure Audit - MSSQLSERVER EventID 18456
  366. How to install SQL Server Schema (.sql) from remote machine
  367. Not Equal To
  368. Set Numeric_roundabort { On | Off }
  369. Dowt in create View
  370. Problem with inserted tuple in triggers
  371. How to Format date without "Convert " function in T-SQL
  372. Image Datatype in Sql Server
  373. Database connecytivity from ASP using IP address
  374. Db Design for Matrix Lookup
  375. escaping data for update query
  376. Converting Integers to DateTime
  377. My ms sqlserver database is in suspected state how to recover or restore it
  378. HCL hiring IT professionals -Chennai/Noida/Gurgaon/Bangalore
  379. How to format numbers in SQL Query
  380. SQLserver Image filter
  381. Updating Table syntax
  382. use array for storing multiple data
  383. dbinit(), dblogin(), how often?
  384. ANNOUNCE: Release 3 of Altova v2007 XML software available
  385. Problems backing up SQL DB.
  386. Copy rows across to another db
  387. Hi Here Nasir
  388. Update & Merge MultiDB into Single DB - Do this as a Routine - Weekly
  389. SQL Server error '80040e31': please help me!
  390. problem connecting to sql database
  391. ntext problem
  392. dbinit(), dblogin(), how often?
  393. Help on Partitioning column was not found.
  394. PACKAGESTART / PACKAGEEND In SSIS
  395. Is there a maximum perameter set for sql server?
  396. SQL connection logs
  397. merge rows of data within a table
  398. DTS w/ Oracle Issue
  399. insert into using a sub select apostrophe issue
  400. RebuildLog
  401. How to distinguish operation type in trigger?
  402. Locking Select queries on rows
  403. Count of is null of datetime field
  404. Programming a Dashboard using SQL
  405. Dynamic Granting of Insert Permissions?
  406. How to send email through stored procedure
  407. Nearest time from 3rd record
  408. SQLSTATE=42601 error
  409. Slow Query Processing
  410. connection to sql server
  411. Forcing a join
  412. Conversion from MSSQL 2000 to MSSQL 2005
  413. SQL Enterprise Manager - Not very usefull tool for building views
  414. OLE DB Error
  415. Book recall
  416. URGENT: Cascading Parameters in SQL Server Reporting Services 2005
  417. Select Most Recent Record for all Customer IDs
  418. sorting table while inserting
  419. Cross-database ownership chaining in SQL 2005
  420. MS Sql 2003 problems - HELP!
  421. Mssql New Shell
  422. Escaping international (unicode) characters in string
  423. What do you think about the checksum function ?
  424. Merging Dataset into exisitng SQL DB
  425. Sql query help
  426. sql query
  427. Transpose column into rows
  428. needed: 1 + null = 1
  429. Calling Function From Stored Procdure ???
  430. hi,need help.....
  431. sql server2000 a problem
  432. How to import/export dump file from command prompt in SQLServer
  433. Is SQL Server 2005 backward compatible with SQL Server 2000
  434. Trigger Problem
  435. Urgent - Strange Problem With Stored Procedure
  436. How To Take Copy of SQLSERVER 2005 DataBase
  437. Char or varchar for a primary key?
  438. Slow Query Processing
  439. Automatic Email Sending to multiple Email addresses
  440. Information about sql server
  441. problem with Stored procedure ,Please help
  442. Tracking when a Trigger runs... MS SQL
  443. Custom Software Development
  444. Moving database back to its original position
  445. uploading image files
  446. Database design
  447. Trigger problem
  448. Need Help with a SQL Statement - Trying not to use a Cursor
  449. Storing 2 instants of contact in a seperate table
  450. transfer users' telephone numbers from sql database to active directory users
  451. SQLExpress
  452. MS SQL Linked server - error on connection
  453. Use CVS server with SQL Server
  454. WHERE statement - need to check if Cell is blank
  455. Cluster IP address change and delay
  456. T-SQL automatic resizing of columns in table
  457. How to find Double Majors in a statement
  458. Any Input: Converting from Sybase to SQL
  459. Remove neighbouring duplicates
  460. Password Changed. udl refused to work
  461. Query result sent via e-mail
  462. summing up values in each record
  463. Synchronous Bulk-Copy into two table
  464. Converting Assertion to a code in sql server 2005
  465. Earliest Date from Common IDs
  466. DTS - send mail task fails
  467. SUM a range of records from a fixed DATE in the DB
  468. Selecting data from two databases within MSSQL
  469. SUBSTRING in User Defined Function - Invalid column
  470. Decimal Format
  471. How to copy data of Sqlserver 2000 to MySql
  472. Become MCSD Certified
  473. Question about Transaction isolation level="readCommitted"
  474. Select top (7 - (datepart(weekday, Fordate))) from table1
  475. hourly average help
  476. Installing Sql server 8
  477. Error in upgrade process
  478. Whats the use of creating the index
  479. Finding values containing milli seconds!
  480. Duplicate key insertion error when concurrent users insert same data into table
  481. query on procedure
  482. Invalid object name 'Product'.
  483. Sql server 6.5 Enterprise Edtn Installation
  484. Collection of All SQL Commands
  485. Accessing SQL Server 2005 via Scheduled Task
  486. [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation
  487. Stored Procdures
  488. Stored Procdures MS SQL
  489. SQL 2005 and Scheduled Tasks
  490. Sql server 6.5 Enterprise Edtn Installation
  491. Transaction log and tempdb
  492. Transaction log and tempdb
  493. Transaction log and tempdb
  494. Transaction log and tempdb
  495. Transaction log and tempdb
  496. constructing strings from table
  497. SQl server 6.5 Enterprise Edtn. Installation steps
  498. Sql server 6.5 Enterprise Edtn Installation
  499. Transaction log and tempdb
  500. view of max values from many tables
  501. Transaction log and tempdb
  502. export data from Sql table to xml file example please
  503. how can i access SQL 2005 OLAP Service
  504. To get the Child query for TreeView in .NET
  505. how can i access SQL 2005 OLAP Service
  506. SQL 2005 OLAP Service
  507. Using local VAR as FILENAME in CREATE DB Statement
  508. Getting Result of query inside another query
  509. Write a Script as Varchar Parameter in Stored Procedure
  510. Return data from multiple tables
  511. Uniccode Data trasformation from text file to a table
  512. how to setup a server?
  513. Inserting multiple rows with a single INSERT query
  514. How to choose SQL Collation for multi language
  515. Need help with converting Access Query to MSDE
  516. Bulk insert, skip rows with duplicate key error?
  517. SQL Query to insert data to a table
  518. self referential database table
  519. Help for Ordering the rows
  520. Transaction log file size - does it do any harm?
  521. help query sql server 2005
  522. Migration from MSSQL Server Reporting Services to OracleReports 10g.
  523. Excel based query for SQL-data extraction to excel
  524. Backing up a DB @ a Hosting Company
  525. JOB POSTING: Looking for a senior database manager /department head/ architecture
  526. Is it possible to change login of 'dbo'
  527. Trigger
  528. Moving SQL Server 2005 databases
  529. Syscomments system table limitation
  530. Trigger problem while updating
  531. SQL Log.ldf files reading
  532. is there a way using sqlexpress to review the most recent set of sql commands submitted to a database?
  533. Multiple values into single cell
  534. Run DTS within a DTS
  535. Microsoft SQL Server DBA's required immediately
  536. How to attach a MS SQL 2005 database (.mdf) file to MS SQL 2000
  537. SQL server 2005 express import and export
  538. SQL Query Error Help
  539. SQL Server Case
  540. Server Hardware
  541. SQL Server 2005 - > = 0 is not the same as > 0?
  542. Insert into problem
  543. Optimalization - SELECT tatement
  544. DTS package executing a stored proc
  545. Automatic Database Backup
  546. SQL Server 2000 - Recover Database using only File System Backup
  547. Hi Friends, JOB ID: SB 0501 >>> Urgent req for SQL/.NET
  548. SQL server 2000 - database problem
  549. join reducing selected data in undesired way
  550. SQL Server 2005 SSIS Progress Question