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