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