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. UPDATE makes cells NULL
  2. Connect SQL server (64-bit) to Sybase SQL Anywhere 5.0
  3. sp_linkedservers did not help in linking server
  4. how we can display two columns according to the same rows in each column rowwise
  5. Select query execute very slow
  6. which database perform updation faster sqlserver or Ms access
  7. Joining tables in different databases instance and SQL servers
  8. SQL Starting issue
  9. need help with CASE function
  10. In Crystal, what does COUNT ({table.column1},{table.column1}) do? & SQL equivalent?
  11. Copy table from one SQL database to another SQL database
  12. @@ROWCOUNT always 0 :(
  13. append query
  14. Validating records in a table
  15. Validating records in a table
  16. Update a thousand rows with specific value
  17. is this update query works
  18. A CASE statement using another CASE statement as it's expression
  19. Why would SELECT returned record sequence change? SQL Server 2005
  20. How to go to the previous record with non consecutive ID numbers
  21. Go to previous record in sql query
  22. Date/Time Problem with SQL
  23. NULL In IN clause
  24. how to solve the following
  25. Sql server
  26. how to convert 2 rows into one column
  27. when I insert table, value is a string contains apostrophe - it throws an error there
  28. porblem of string
  29. Can I do this in a trigger?
  30. DTS package query
  31. Update using a join in the where clause
  32. Database import fails and prints "insert table failed for eventLog" - what issue?
  33. i need to start row number as 100
  34. i want to send sms from SQL SERVER 2000 or 2005
  35. SQL Server Express 2008 Off Domain Authentication
  36. Why is SQL Server faster than Access?
  37. Retriving 10 records per page through stored procedure
  38. Create username and password for my SQL Server 2005 database
  39. Update statement for whole table
  40. Unusual ordering of values in SQL
  41. Concatinate user defined variable with select statement
  42. pick the values separately from a column field
  43. combine data from different databases
  44. The request failed or service did not respond in timely fashion
  45. Sql Express installed using Package deployment does not provide change 'sa' password
  46. Linked tables in SQL Sever-ODBC connection
  47. Get sql row count
  48. Sql Server Error
  49. Divide a single column data to put into different rows.
  50. SQL SERVER 2000 T-SQL Problem
  51. Select Columns using nested select statement.
  52. WHERE question
  53. Copy &Inserting the dataStructure from one table to other table?
  54. login problem
  55. Inserting into multiple related tables using table valued parameters.
  56. Many to many relationship problem
  57. What other database can i use besides Microsoft SQL Server?
  58. MSSQL ID generation
  59. SQL NULL value logic
  60. connect web with a data base
  61. how to work with macrons and ms sql 2000/2005
  62. Subqueries are not allowed in this context. Only scalar expressions are allowed.
  63. HOW could i DO PIVOTING in SQL SERVER 2000
  64. Get the id of the next closest location
  65. Parametrized ADO Stored Procedure from C++
  66. HOW COUld i use POVIT ing sql server 2000
  67. recursive logic with sql server
  68. H0W Could i Get Next Day Date Of the Day Function in the Sql server 2000.
  69. Sorting
  70. moving sql servers to a new ou
  71. Query On DTS package
  72. DTS - import from excel ended with more records
  73. Select Between 17:00 Yesterday and 17:00 Today
  74. how to select the colums value as Column header?
  75. SQL 2005 and Ad Hoc queries not taking advantage of parallel processing.
  76. How to add data from two coloumns
  77. SQL Server 2005 Dev Edition : Data Flow Task error
  78. Interfacing to sql
  79. Issue of Full text search -- ContainsTable
  80. Selecting a specific value from an audit log
  81. General Network Error while running an ERP application on SQL Server 2000
  82. using currency in a stored procedure
  83. get last 3 most recent results based on a column
  84. Database (cache) memory allocation
  85. Help need in performance tuning
  86. MS SQL filter list of records
  87. how to display nth record from table
  88. How can I uninstall SQL Server 2005
  89. Dynamically Pivoting Rows to Columns in SQL Server 2008
  90. order by for 3 columns
  91. db design and performance for bulk insert
  92. Give a range in a query
  93. Doing a query through php to sql server 2005 and get query timeout
  94. what is meant by meta data in sql server??
  95. How to identify the ID of row which has been modified?
  96. How to deal with html source in SSIS packages..?
  97. join multiple tables
  98. connecting multiple table
  99. Question about differential restores (SQL Server 2005)
  100. Trying to update certain rows and its not producing the results i need
  101. How to add an identity column to a table with existing data
  102. how to insert the value of a function in the coloum
  103. How to convert row data into columns
  104. how can i update my table with the elapasedsecond as a new coloumn
  105. SQL Express Management Tools and Standard Edition Tools
  106. Selecting MAX date from a group of records
  107. Trigger in a certain period of time of day
  108. is there anysql equivalent to inner join ins on ins.address like '%a%'
  109. What is the Query?
  110. what are break points in sql server?
  111. Getting a proper Count for a month
  112. Why would I use a different table owner other than dbo
  113. SUBSTRING in where clause
  114. is there a chance of mixing up of data in secondary file?
  115. Writing a cursor with do while loop
  116. top 5 on the basis of a zone
  117. Date Peak
  118. Reducing Data type Lenght
  119. Problems with crystal after sql server protocol encryption
  120. Is it possible for sort select query based on input string?
  121. Export datas to a Excel file using query without openrowset method
  122. How to query another server with stored procedure
  123. Query across Multiple Tables MAX()
  124. Month to month yearly results - hard and slow help...
  125. SQL Query aggregate phone numbers
  126. query for relation between 2 fields
  127. The INSERT statement conflicted with the FOREIGN KEY constraint
  128. How to convert rows into different columns
  129. how i convert dbf file int sql file
  130. Can I calculate between different datasets?
  131. Query Engine Error after Forced Protocol Encryption on Crystal Report
  132. How to query untyped xml data
  133. TSQL query
  134. role permission of tempdb due to server restart
  135. Want to track the user who last modified the procedure
  136. How can i convert this query into sql server whereas this is working in MS ACCESS
  137. Insert table values from other table
  138. sql query
  139. Return all items in an order then add the shipping cost to only one item
  140. Raise Error problem when connecting to SQL Server through ODBC
  141. UPDATE and SELECT Combination
  142. openrowset works in sql 2005 but not Works in SQL 2000
  143. Use Excel modified date in Stored Procedure
  144. Using a pointer to a local varaiable in Dynamic SQL
  145. Unable to join 2 tables which are in 2 differenet servers
  146. trick for displaying result? SQL Server 2005
  147. Open SQL connection using T-SQL
  148. I'm trying to run a package in integration services
  149. SQL Server, how to the next value of identity(1,1) before insert
  150. How to publish Stored Procedures into a database
  151. sql query groups and min value
  152. How to split long string function in sql server?
  153. Easiest way to convert Microsoft Access SQL code to T-SQL code in SQL Server
  154. problem in query
  155. How to find the System Date Format?
  156. How to check if a value (null/non null) exists in database table using stored pro
  157. Job disappeared from Enterprise Manager
  158. Error : Calling SSIS package from .Net
  159. What values can a datetime data type hold other than date and time??
  160. RTF file in SQL Server 2005
  161. Automated Data Import from Excel
  162. I want to query of getting hour from date field
  163. Report Maker
  164. SQL server
  165. fit record in one page in SSRS
  166. Sql Compact Installation
  167. Sql update command question
  168. passing db table values from one sql server instance to another sql server instance
  169. Selecting seperate fields from file - each based on different criteria
  170. DTS Task not running... wierd...
  171. Connectoon timeout
  172. Query Data and Column Names
  173. Using aggregate fucntion to calculate standard deviation
  174. identity column (int) overflow
  175. SQL server 2000 - cannot telnet to port 1433
  176. Using extended properties on the DB objects. What is it?
  177. Problem in creating stored procedure.
  178. Using Joins
  179. Join or Transpose?
  180. How good to use Partition table?
  181. Database switching to read_only mode randomly
  182. How can I restore a database remotely from a different server?
  183. Adding leading zero's (padding out)
  184. sqlce in Xenocode
  185. Can you make a new table from query results in tsql?
  186. design a single normalised table
  187. How do I delete duplicates in a row?
  188. Table with various subfleets
  189. Multi-part identifier error
  190. Error converting data type varchar to numeric
  191. Need a script to backup db on one server and restore that db to another server
  192. How to tune this SQL
  193. Why does MSSQL server allow the attached code to work
  194. Converting String To Decimal
  195. removing duplicate records
  196. Problem with NULL values
  197. Stored procedure problem
  198. Australian Postcode with longitude/latitude
  199. SSIS import full text from html or combine rows
  200. Synchronization
  201. Query
  202. having trouble with joins
  203. how to use replace and substring correctly.
  204. Split a string where newline, carriage return
  205. Select with conditions
  206. replacing the 8th character in a varchar string
  207. insert rows dynamically
  208. Transferring data
  209. Help in Insert into select from SQL
  210. How to select top 1 from table1 where table2 contains a list of values to select on
  211. Violation of Unique Key contraint during update
  212. how to call Function
  213. How to convert a char value to date?
  214. Get employee with least work
  215. Taking Automatic Backup Of sql server database
  216. Dynamics column in SSRS 2005
  217. Embed a Google Map in SSRS
  218. SQL Server Import and Export Wizard steps
  219. Substring in SQL server
  220. Conditionals in a WHERE clause?
  221. Combining Multiple Projects
  222. Retrieve date now
  223. SQL Server 2008 SP1 not for XP?
  224. which sql download from net
  225. SQL Server Compact timed out waiting for a lock
  226. Quick question
  227. SQL query
  228. Report Builder 2.0
  229. How to use where wiht variable
  230. I am new to Sql and looking for some help with this error. Any advice would be apreci
  231. Select DISTINCT (This part of the query only)
  232. I have deleted the .MDF file accidently. I have never created a backup early on.
  233. Multiple results from a Case statement in a Where clause
  234. merging rows for the same time stamp
  235. Where is error-I need exec in function - result is without error,but not return data
  236. Conditional Having Statement
  237. ISNULL With date..
  238. Condition check for If table exist
  239. converting access 2007 update query to sql server 2005 update query
  240. Insert and Select statements for same table in begin trans and end trans
  241. Extracting documents from SQL database
  242. Help converting .xml feed to SQL
  243. sql create tables
  244. Quick questions About SQL Server 2000
  245. Best way to index a mostly static database
  246. How Access reads data stored in SQL Server
  247. How to run a scheduled AutoExec Macro that requires an ODBC password
  248. select addresses with distinct email address
  249. Can any of you SQL Guys help us olde Access boys out with this Thread?
  250. The LIMITations of ms-sql. Equivalent to MySql's LIMIT
  251. How to join update statement with select?
  252. How to decide optimum type
  253. Count group by query
  254. Multiple select
  255. Problem with MID() function
  256. Working with Multiple CASE WHEN Comments
  257. Find empty fields
  258. Bulk Load Copy - nvarchar is not recognized
  259. Trouble converting Access query to SQL Server
  260. Need guidelines - Query Optimization
  261. How can I detect changes in a row of some table?
  262. two questions: 1) Joins 2) Selects
  263. error "Could not open a connection to SQL Server"
  264. MSSQL "A network-related or instance-specific error" and IIS application pool
  265. Create Function
  266. problem with installing mssql - dot net framework
  267. Attempting to do an update in SQL Server 2005 with query originally created in Access
  268. running web application in MSSQL on server with MySQL; 4CRM SQL & EMS MSSQL Manager L
  269. converting queries from access 07 to sql server 05
  270. Multi-table JOIN issue
  271. How to insert Unicode data into table when pulling data from another table
  272. how to divide one column to two columns
  273. Create Function
  274. using union, temp columns, in a SQL based search string
  275. How i know if a report has Data in Reporting Services 2005?
  276. Am i able to insert into a table data from a temp table?
  277. Can I use LIKE with IN?
  278. How to update one sql table from another table
  279. Converting Text to Decimal
  280. If exists table using dynamic sql
  281. Need help urgently, have to compare dates between 2 rows in one table
  282. retrieve a last value from sql
  283. Use sub reports in the header of a report in SSRS
  284. Cannot specify an index or locking hint for a remote data source
  285. How do you change the default encoding on SQL server?
  286. SQL Query
  287. Transpose into fixed column
  288. Transpose into fixed column
  289. Multiple SQL servers in same query
  290. Cannot Reindex.
  291. Computed Binary Field
  292. Using parametrized "IN"
  293. question about cursor
  294. Nth location of string
  295. Remote server Problem in Sql server 2005
  296. Configuring Error Messages in SSRS
  297. make one table from merging two
  298. Dynamic SQL in an INSTEAD OF trigger causes recursion
  299. Dynamic user security in Reporting Services
  300. Questions about Foreign Keys
  301. substitute for 'PRINT' in server
  302. Combining Rows into 1 Column, and joined with another table
  303. scope_identity not working
  304. Filename Increments
  305. The INSERT statement conflicted with the FOREIGN KEY constraint
  306. sql AS function not working
  307. sql deletion with delimiters
  308. sql statement writing
  309. How to build a query based on four tables
  310. Concatenating Row Values into 1 Record/String
  311. Parameter query problem
  312. SELECT yesterdays records
  313. Issue when reading data from excel sheet
  314. Using an alises in the WHERE clause
  315. problem with writing arabic into database from out
  316. Current day
  317. retrieve n number of rows from table
  318. insert into - add multiple values in a column
  319. How do i phrase this simple query
  320. How to handle high-volume inserts?
  321. Multiple Functions
  322. Complicated Query by date
  323. no access to new instance of sql server
  324. Importing .txt to SQL 2000
  325. calling a pl sql procedure in Reporting Services
  326. SQL Query - Eliminating Duplicates
  327. Scheduled DTS Problem
  328. Distinct Count - SSAS
  329. SQL Server 2000 XML Element Order
  330. SSAS 2005 help
  331. Syntax error converting datetime fom character string
  332. Autonumber not updating fast enough
  333. Connecting through .adp file (not working on Vista/SQL Server 2008)
  334. How to compate two versions of the same database
  335. Set based solution instead of Cursor
  336. Find Credit Card numbers in text field
  337. Question using SP_ADDLINKEDSERVER
  338. Query with Counts Help...
  339. Select every 79th record
  340. Database Locking
  341. Return records 5 thru 10
  342. remove duplicated fields depending on time
  343. Inserting concatenated data with while construct
  344. Extract Numeric Data from text field
  345. Trying to get a case statement to work correctly
  346. Connect to DB2 server from SQL Server 2005
  347. Sql insert cursor
  348. Display flag if record exists in table
  349. Quary Confusion
  350. While loop with dynamic sql
  351. Linking from Access
  352. sql server compact edition 3.5
  353. Database normalization question
  354. Search a row by Primary Key
  355. generate & compare id from table in sql storeprocedure
  356. get tables
  357. Views in SQL server
  358. list of countries and their states
  359. How to Create an XML in MS SQL Server 2000
  360. Two instances on one machine
  361. need your help please
  362. SQL Error: Cannot resolve the collation conflict between "SQL_Latin1_General_
  363. Using SET statement in stored proc.
  364. Calling a UserDefined Function
  365. MSSQL Datetime snafu
  366. General Network Error- works if exe name is changed
  367. Using Single Quotes in a dynamic SQL
  368. Best way to send email from SQL
  369. simple question about date compare
  370. Move MDF From 2005 Back To 2000
  371. Trigger Before Insert or Update
  372. Problem inserting ' and ; in DB
  373. Problem with nestd query
  374. Need help with join - it's returning duplicate rows
  375. How can we generate a Script with all user permissions of all users in a particular d
  376. determining if an SQL database exists, etc.
  377. When to use trigger, constraint and when one cant
  378. SQL Query
  379. Help with Query To combine results from two Columns
  380. Problem with query
  381. problem in Updating database in windows application
  382. SP that updates a table according to optional parameters?
  383. problem with joins and aggregate functions
  384. Exporting data with Stored Procedures
  385. where's the dgDetails class?
  386. Stored Procedure Error
  387. proper Save location for SQL stored procedures
  388. one-to-many relationships
  389. Getting a count on one table using data from another table.
  390. how to “store” stored procedures
  391. Getting the count from two tables as rows not columns.
  392. SQL Query becomes too much
  393. learning sql server
  394. Pivots
  395. dataAdapter.Update / SQL PasswordHash NULL problem
  396. PasswordHash NULL problem
  397. query to store null
  398. How do I get PasswordHash value?
  399. displaying an auto-incremented identity column
  400. GetDate() with time-ignore
  401. Multi Table Query With Max Per Grouping
  402. datatype smalldatetime now requrement is there to store nil
  403. SQL / Access (Average Code)
  404. Only One Record
  405. why deadlock in this SPROC
  406. mapping error
  407. SQL Server Users and Roles
  408. System DB not able to restore
  409. auto-increment identity column
  410. How can I make SQLServer known to DB2 control center so that I can Federate?
  411. Need help with a query - may be easy for you but not me
  412. INSERT IGNORE duplicates
  413. Is a solution possible/viable?
  414. dataAdapter.Update problem
  415. Last Sales Price
  416. DataBase Size/space Query
  417. sql parmeter problem
  418. mssql
  419. SQL Server 2005 - Open SQL file with Query Analyzer behavior
  420. Loop through all databases
  421. Sql server 2005
  422. sql network
  423. collating records from different SQL Server tables
  424. Recursive stored procedure
  425. SQL Server connection problem
  426. How to uninstall AdventureWorks sample databases?
  427. ELSE IF statements
  428. ELSE IF statements
  429. database security
  430. Help me with SQL
  431. How to import ".mdb" files into SQL Server 2008?
  432. Can SQL Server 2008 access Northwind or Pubs databases?
  433. Access add record command button not working with SQL backend
  434. Optional Parameter in a SQL Function -- selecting all
  435. binary data in char field
  436. What will happen in such case to the table
  437. Calculating the Weekend Days(Saturaday,Sunday)
  438. AdventureWorks mayhem
  439. server database
  440. SSRS report parameters are not wroking properly
  441. PHP SQL Server 2005 suddenly down
  442. how to make SQL commands more dynamic?
  443. Problem with SQL query newbie
  444. Pub sample database
  445. Default file group
  446. set password
  447. Data Manipulation
  448. select statement
  449. Two or more select statements in a single query
  450. I can’t install SQL Server 2008 Express with Advanced Services - Help!
  451. SQL Query with some problems
  452. createing database problem
  453. how to obtain SQL Server FullText Search service?
  454. SQL2008.AdventureWorks install problem
  455. Any other SQL or MS Access / OleDb databases available?
  456. COUNT Duplicates using partial string
  457. dataset
  458. parent row
  459. LIKE Condition while using parameters
  460. Creating Custom data sets in reporting services
  461. How do I create custom Datasets in SSRS?
  462. Normalization
  463. How to solve memory leak in SQL 2000
  464. Find remaining balance - not a simple SUM()
  465. Custom WordBreaker for SQL Server Full-text
  466. Curser in SQL(for coonectiong to deifferent servers)
  467. Very weird bug with 'like' function
  468. Sql query to select Date between the range
  469. Error occured in execution of Procedure
  470. Recover SQL 2000 database restored over in error without backup
  471. Copy table to table, how?
  472. Covert Data in .DBF files to MS Sql
  473. Searching between 2 DateTime Values using SELECT stmt in Vb.Net
  474. conversion from varchar
  475. No error Description
  476. Condition as part of FROM statement???
  477. Subtracting sequentially from multiple sources
  478. Cursors
  479. local html webform page to local sql 2005 database possible?
  480. Intelectual property protection
  481. Getting unmapped records with mapping table query
  482. Subtracting from lowest value
  483. pivot
  484. Duplicate Entries
  485. How toRetrive XMLdata into database Table
  486. How to copy column(s) from one excel sheet to another using sql server.
  487. Sql server 2005 Installation problem
  488. Fixed Width File Spec for SQL Server
  489. per seat , per server , per processor
  490. columns operation
  491. sql connection
  492. saving userlogon time
  493. Can somebody please kill my cursor
  494. Update rows in
  495. How to eliminate selecting repeats in a statement
  496. Does SQL Server 2000 support foreign key in partitioning?
  497. how to create backup in sql 6.0 using sql command
  498. How to handle NULL parameters,EMPTY parameters and ERROR HANDLING in stored procedure
  499. creating a table
  500. How to migrate mysql stored procedures to sql server manually?
  501. Single stored procedure for multiple databases?
  502. Registration Form
  503. HELP ME Understanding the concept of Foreign
  504. Sql server date question {C#}
  505. Variable locking up query ??
  506. insert new columes
  507. Migrating DTS Packages from SQL server 2000 to SQL server 2005
  508. problems when trying to use the import wizard on mssql2005
  509. Regarding stored procedure help me
  510. Look at every *Third Tuesday* of the month on record ...?
  511. query that filters out those schoolcode
  512. Single table condition in join or where
  513. SQL query related to Date.
  514. Single Trigger for "SELECT" execution happens irrespective of any table.
  515. Data Conversion in ssis
  516. using a trigger to get values from one table into another
  517. Restore Database error in SqlServer
  518. trigger error
  519. Constraint on existing table, multiple columns
  520. How to recover database from MDF?
  521. BULK INSERT row terminator issue
  522. Convert mssql to mysql
  523. SQL server does not exits....
  524. how to put the sql-logfiles online?
  525. how to find whether particular value is present in database
  526. Need Help - Multiple Column in Group By clause with Data Type Error
  527. query to search even when user skips in between text
  528. CASE statement in subquery
  529. Multiple SUMS SQL Query
  530. Select/Insert/Update a column with out a header
  531. SQL Stored Procedure Insert List of variables
  532. speed uo to read rset from SQL Express
  533. executing block of code whenever a condition is satisfied
  534. fetch multiple columns value in stored Procedure
  535. Concat date and time in stored procedure
  536. Output of SP1 stored procedure in #Temp TABLE OF SP2.
  537. Export table to CSV
  538. database exist or not
  539. Help on Error:Only one expression can be specified in the select list when the subque
  540. Mutiple Table from Stored procedure
  541. How can sole that
  542. cross tabulation
  543. Issue with query results
  544. put rows together and group by another column
  545. Protecting .net dll's in Sql Server
  546. Split Function in Sql stored procedure
  547. Error using built in function SwitchOffset
  548. When to recreate index?
  549. export my sql server database to msaccess - Validating (Error)
  550. BULK INSERT not inserting string with 'D'