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