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. Finding "missing" rows
  2. Login failed for user 'sa'. Reason: Server is in single user mode.
  3. Connection String on shared server- Almost there but need a littlehelp
  4. Please recommend SQL book with excercises
  5. Re: T-SQL Duplicate Record Help
  6. Re: default value wich is not in DDL.
  7. Handle Triggers in MS Access 2003 with SQL Server as Back-End
  8. Calculating Opentime between several records.Using SQL Server 2000.
  9. Calculating Opentime between several records
  10. How to compare date,month,year
  11. Counting days in date fields
  12. SQL Query Email
  13. How to get Last Thursday Date
  14. Xml Bulk Load in SQL 2000 relationship error
  15. Suffix in dates
  16. Order of Triggers in SQL Server
  17. How to list all servers of MS SQL server?
  18. How are parameters passed in Triggers?
  19. Number of Queries in Stored procedures...in SQL Server
  20. SQL Query to select top 10 records except for the top 10 records
  21. Getting specific dates in SQL
  22. Help in writing SQL query
  23. SQL 2005 to XML
  24. Securing Tables/Views
  25. Using two different database data in one application
  26. xp_cmdshell syntax commands
  27. Selecting Query
  28. Violation of PRIMARY KEY constraint..how to solve this error?
  29. Merge multiple row values to a single row
  30. Primary Key
  31. List all Databases
  32. cannot change the type
  33. Log file needs shrinking
  34. Space Available 0.00
  35. SQL Server Migrating from XP to Vista - How to copy databases over
  36. Accessing VIEW via SELECT statement from another server
  37. using exec
  38. bulk copy
  39. Replication - SQL Server 2000
  40. Update SQL table with Dataset
  41. Join table from sqlserver and sybase
  42. sql job schedule
  43. Insert a record that has been deleted
  44. Join Query
  45. microsoft sql server management studio
  46. Format Number in Sql Query
  47. How use the substring method with sql 2000?
  48. Problem with Query
  49. How to get the month back from sql server 2000?
  50. Select a Random Sample of Raws
  51. Is it possible to run SQL-Cursor through cmd??
  52. hi needed help in a query
  53. How to stop writing into log file when DTS is executing.
  54. Convert Character Sets On Export
  55. Issue with inserting record in db table.
  56. How to reset Identity column
  57. Identity Column
  58. Issue Select statement to read Oracle table from SQL Server
  59. Using LIKE Operator
  60. How to set certain value into field?
  61. Select query help
  62. data type for a field in sql server
  63. How to calculate duration in a query
  64. Required Data between two dates
  65. Sql server 2000 Hanging problem
  66. How to display pop-up message in bold
  67. front end details
  68. Plannig indexing
  69. how to configure sql server 2005...
  70. How to fetch data using OPENDATASOURCE and Linked Server
  71. Date Between Problem
  72. DISTINCT UNION ALL query help (employees and dependents)
  73. Sql Stored Procedure
  74. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
  75. Check null values for more than one column
  76. Index On A Columns
  77. Cannot schedule a maintenance plan
  78. SQL Server Isolation Level - Table Locks
  79. Find hard coded strings in SQL: can it be done programatically?
  80. how to get the row count value
  81. Is it possible to insert records through view....
  82. If conditions for stored procedure
  83. Insert more than 40,000 records
  84. MS Project 2007 SQL Server Enterprise
  85. Updating multiple columns with several conditions
  86. Round Function
  87. Specific Reasons To Denormalize
  88. Differnece between SelectStatement in View and StoredProcedure
  89. where do I download sql odbc drivers from?
  90. (Newbie) Join problem.
  91. Problem with joins in SQL.
  92. Join zero padded char to varchar
  93. Exporting data from SSPS 15.0 to SQL Server 2000
  94. Alter Column datatype
  95. store procedure
  96. Access Runs SQL Server Slower
  97. Progress Bar
  98. Date calculation in SQL 2005
  99. Stuck with Truncate
  100. Stored Procedure for Searching
  101. auto generate ID'S in sqlserver
  102. Migrating Access to SQL "IIF Statement" Issue
  103. db open
  104. changing the position of column by writing a query
  105. How to activate distributer agent in subscriber or publisher?(REPLICATION)
  106. date problem
  107. Problem with Query
  108. Flag in SQL
  109. To change Date Format in Sql
  110. Any SQL statements to return no records found?
  111. plssssssssss help
  112. shorting problem in query
  113. Get number of days in a month
  114. Creation of DALC using stored procedures
  115. Regarding DALC Creation using stored procedures
  116. which datatype takes actuall value
  117. Converting Oracle SQL syntax to MS SQL 2005 syntax looking for a tool
  118. IF Statements in Stored Procedures
  119. Crystal Reports
  120. insert actuall value in sqlserver
  121. add float value
  122. copying from one table to another
  123. dataset transfer from client to server
  124. SQL Trace
  125. Using Round in a sql query
  126. Concatenating Certain Rows in Table
  127. sp
  128. Rows
  129. Parameter
  130. converting char to int question
  131. Showing a negative # as a positive?
  132. Update query not working in SQL Server
  133. SELECT data from two tables using same field labeled differently
  134. Table
  135. Permissions
  136. Differences
  137. Date
  138. select maximum in a table
  139. How to return a Pk value from one stored procedure to another stored procedure
  140. execute SSIS package from windows app
  141. Backup to a remote server
  142. how to use Regular Expressions
  143. Export
  144. User initializes variable through VB in a DTS package? Is it possible?
  145. Isolation levels??
  146. SUM of rows, when selection returns no rows
  147. Comparing the previous record
  148. Bcp
  149. Column Name
  150. Stored Procedure
  151. sql server stored procedure
  152. SQL Delete
  153. sql search query
  154. sql search query
  155. ERROR 1045 (28000): Access denied
  156. Storing a C# data of data type timestamp into sql server table and then perform SUM
  157. Calling A Crystal Report From Vb6 And Sql Server As Back End
  158. SqlCommand TimeOut
  159. downgrade dbase 7 to dbase 4 using command line
  160. Best match query and order by columns
  161. data type datetime ??
  162. Need Help in data Merging.
  163. Count child nodes in tree like data table, SQL Server 2005
  164. stored procedures question
  165. How to Eliminate NULL values from the SQL queries
  166. Limiting integers
  167. SQL SERVER Reports and multiple selects
  168. SQL Operation Performance Advice
  169. DATETIME - Time only needed
  170. Database Report Writer
  171. Regarding Date DataType
  172. Add A Constraint To An Existing Table
  173. Simple Query
  174. Regex in Stored Procedure Problem
  175. Dropdownlist
  176. Sql
  177. MSQL UPDATE table
  178. Nocheck Constraint
  179. SQL Server Stored Procedure
  180. Password format
  181. Cast an entire field from VARCHAR to FLOAT
  182. how to release table variables
  183. SSIS and HEX conversion.
  184. Constraint Triggers
  185. Creating multiple stored procedures at once
  186. SELECT and compare last two cost entries
  187. ssrs
  188. Database
  189. Sql
  190. SQL query calculation
  191. COMMIT & ROLLBACK
  192. select column names from table
  193. grid
  194. Performance based on design
  195. Create triggers
  196. if then else in stored procedure
  197. date/time in page layout - SSRS layout
  198. split color values into multiple records in sql server 2005
  199. mod operator
  200. xml datatype in sql serevr??
  201. @@rowcount
  202. Variable initialized by user each time DTS runs?
  203. What is @@SPID??
  204. Restoring MSSQL 2005 bak file to another instance
  205. Change Recovery Mode from Full to Simple
  206. Export Excel to SQL 2005 table
  207. SQL Server Express 2005 9.0.1399 Installer?
  208. % WildCard
  209. CASE stmt with isnull()
  210. problems with cursors
  211. SCOPE_IDENTITY issue
  212. I have a Problem With Stored proc_ help needed
  213. Cases in Select, Where, and OrderBy Dynamic Clause
  214. Problem with Query
  215. SQL Database design :- varchar datatype doubt
  216. Mismatch Records field need display Null
  217. Please Help In designing the Reports USing SSRS
  218. Trigger problem
  219. How do I add a folder to a ssmssln solution in MS SQL Server 2005?
  220. Add a list stored in a text file to a SQL Server 2005 database
  221. How to use WHERE IN syntax conditionally
  222. Insert into a table only if count is less than 'n'
  223. How can i have a copy of entire databse with out data??
  224. DateFormat
  225. Connect DTS with VB6
  226. SQL Server 2005 with SQL Server 2000 support
  227. How to retrieve the database which is deleted??
  228. how to use top 1
  229. Conversion failed when converting from a character string to uniqueidentifier
  230. getting max count - error: error aggregate function calls may not be nested
  231. Find the 3th,4th ,5th........... largest salary
  232. How can i change the column name?
  233. Beginning and Ending DATE of a Quarter
  234. Reinstall SQL Server 2005 Express Help
  235. Appending strings in query to create table name?
  236. Your upgrade is blocked because the existing component is a later version...
  237. Sub Query and join Difference
  238. Mapping values in one table column to another table column
  239. Can we use two orderBy in single Select statement ?
  240. Auto Generate Value
  241. My ASP application is not working when i moved from sql server 2000 to 2005
  242. how to query this?
  243. capturing object not found in SP
  244. Generating SSRS-2005 REPORTS with XML Data in C#..
  245. SQL Addition Problem
  246. Regular expression in SQL Server
  247. DTS Package SQL Server 2000
  248. Simple Query
  249. Joining two values together across multiple tables
  250. SSRS error
  251. multi-statement table valued UDF
  252. problem with union
  253. Apostrophe
  254. Concatenate two tables
  255. Retrieving Data Problem in sql
  256. Different types of joins
  257. Newbie select question (Just select first record)
  258. Diff B/w Stored Procedures & Functions
  259. SELECT @error_message vs SET @error_message
  260. split a string
  261. SQL Architecture
  262. Delete Duplicate Columns
  263. cannot insert duplicate key row in object 'Table' with unique index 'Index'
  264. Foreign Key on a table with no primary key
  265. MSSQL Time Diff?
  266. SSIS - convert dbf to sql server
  267. Counting rows part II
  268. how to rectify this error
  269. How to add a new field into already created Clustered Index?
  270. delete top (n) excluding the first row from table with no primary key
  271. Sql Error Message
  272. Connecting SQL 2000 to DB2
  273. I guess this is a relatively simple SELECT order by question
  274. Selecting From Multiple Time Periods
  275. Retrieve distinct records on the basis of other columns
  276. Stored Proc help
  277. Ssis Package For Moving/renaming File
  278. The multi-part identifier "..." could not be bound
  279. Information_schema.columns
  280. Add coloumns dynamically in a table
  281. How to GET DATA from Microsoft EXCEL Sheets for Generating REPORTS in SSRS 2005..
  282. Database Object/s disappeard after attaching the database to different machine
  283. Need help in get the result in the format
  284. To pull all emails from the domain-aol.com
  285. Matrix Table Layout Question
  286. resetting Identity column values
  287. Number of open connections
  288. To pull all emails that contains +,^,*,&,!
  289. How to Get Data From Log Files for Generating REPORTS in SSRS 2005..
  290. SQL Table
  291. Constipated publisher (SQL 2005)
  292. If Condition in SQL to search
  293. PHP/MS SQL - automatic formatting: varchar, datetime
  294. xSQL Profiler - monitor multiple SQL Servers from one centrallocation
  295. Retrieve Columns By joining Four Tables
  296. RDLC - Report Layout Issue
  297. SQL Query
  298. Pivot in SQL
  299. how to align concatinated column in sql
  300. Limit rows returned
  301. Cursor in Triggers ? ... What's best practice
  302. Query not getting all data
  303. Deleteing the duplicate Records
  304. Stored Proc not working in DTS
  305. How do I make a backup device file smaller ?
  306. Problems in CALCULATING PERCENTAGE in SSRS 2005 Reports..
  307. Database diagrams disappeared after attaching the database on different machine
  308. Where to write SQL query
  309. Trying to get data by distinct field values
  310. Scalar Function
  311. Replacing Columns within a Table
  312. Result Set In A Range Of Numbers
  313. Navigate a DataTable
  314. Delete Query
  315. SQL Query
  316. Stored Procedure Problem
  317. Database Creating
  318. SQL 2005: Renamed 'sa' account
  319. Deadlock issue... (not the average deadlock)
  320. PerformancePoint Server 2007
  321. SQL Server authentication
  322. Client side insert update
  323. Problem in implementing mirroring
  324. Counting rows
  325. help,a regular text file how to sql 2000 table code ?
  326. Sql Server database creation Problem
  327. Help finding 'pairs' of rows
  328. reference column name
  329. Code Listed: select max value in row that is less than my variable
  330. sql server (evaluation ver) expires daily
  331. SQL Server 2005 native client ODBC query
  332. Adding an autonumber that resets every month
  333. Report issue
  334. SQL Update with join
  335. 'Failed to enable constraints' Error on TableAdapter.Fill
  336. Returning one field multiple times with different values
  337. Problem Connecting .NET app to SQL Server
  338. Types of Functions
  339. sqlserver datetime
  340. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server conn
  341. SQL Table
  342. CheckPoint
  343. how to send mail using sqlserver
  344. Convert String to DateTime
  345. Inserting data from one MSSQL DB to a different MSSQL DB
  346. An optimum query..?
  347. boot camp
  348. Getting a total of a number of group by results
  349. getting tables that link to a table
  350. Restore DB without log file
  351. [IAT ELEZIONI] Presentazione candidati
  352. Simple Concatenation Question
  353. Display a roll having MINUMUM MARKS IN TWO SUBJECTS?
  354. Dynamic SQL generation
  355. ROLLBACK ALTER column statement
  356. List Columns in a Table in SQL 2005
  357. Join
  358. Saving two different records having different number of columns in one table.
  359. SQL Assistance required
  360. need same order as the IN list of ids ...
  361. Improving Select Query
  362. Error History?
  363. Deleting multiple columns from multiple objects
  364. OSQL -D parameter
  365. SQLServer 2005 integration services project
  366. from 'image' to 'varbinary(max)'
  367. partial indexing in sql server
  368. Data manipulation problem
  369. Dataset
  370. Schedule the Jobs in Sql Server 2005
  371. Is it possible to define sql parameter as INOUT
  372. What does it mean to SET a value?
  373. where to find the database?
  374. database truncation
  375. About Deleted Table
  376. Automatic creation of DB fields.
  377. passing textbox value to gridview using C#.net at runtime not using database
  378. Copying XLS (local) directly to SQL (remote) Table without Link srver and BCP
  379. Complex Calculation
  380. Stopping job if running after 7 a.m.
  381. difference between explicit inner join and implicit
  382. Foreach in MSSQL 2005
  383. testing if value is null
  384. delete output into <xml column of audit table>
  385. Varbinary(max)
  386. Deadlock problem
  387. Read table's next row
  388. How to type&pass variable from Excel SQLCMD to Stored Procedure
  389. operation must use an updatable query
  390. Application.StartupPath
  391. Internal query processor error
  392. Need to insert the dates between the start date and end date
  393. Diff B/w Windows & SQL Server Authentication
  394. sql server 2005- reporting - pagesetup
  395. Retrieve data from Three table using JOIN
  396. String(Varchar) ID Generator
  397. Finding SQL Server Event IDs
  398. DTS to .exe! HOW?
  399. Server: Msg 9002
  400. SQL Query IDENTITY Row Reset Help
  401. To create store procedure
  402. views on table having field text
  403. SSRS Reporting - Printing page set up problem
  404. getdate function help
  405. Violation of primary key
  406. CASE WHEN Equivalent in WHERE Clause?
  407. Uninstall SQL 2000 Workstation Components
  408. Scalar Query in SQL Server 2000 like in oracle
  409. Scalar Subquery in MS-SQL Server 2000
  410. A single query between two tables without link on its fields
  411. Problem Using Sum with Join
  412. SQL 2005 Express - problem with no "SQL Serevr Agent"
  413. tempdb space issue
  414. SSIS security
  415. cant connect to phpMyAdmin....
  416. Cant get sql statement to work in mysql 5
  417. DTS Copy File Issue
  418. DYNAMICALLY Generating Reports in SSRS 2005
  419. converting SQLTable to Excel Sheet
  420. Help needed for Update Query
  421. Data conversion
  422. sql query
  423. dbrpcparam datalen problem
  424. ADO vs ADO.net
  425. SQLServer - VC++
  426. How toTranspose a row values in to column values
  427. combining the results of two selects...
  428. DLL -> Database
  429. Unable to disconnect?
  430. Non-clustered, Non-unique index performance
  431. Navision data extract
  432. Cross / Outer Apply
  433. update record with data from another record in same table
  434. price field
  435. date formatting
  436. Redirect the output to a variable
  437. Trigger -help
  438. SQL Server 2005 : Piecemeal restore with fulltext index
  439. Selecting rows representing highest value for columname1 for each columname2
  440. SQL Server
  441. identity table
  442. help with DDL trigger. Moved from other newsgroup.
  443. UTF-8 Coding of MSSQL 2005 DB
  444. mmc cannot open the selected file(SQL SERVER 2005)
  445. Subquery returned more than 1 value. This is not permitted when the subquery...
  446. how to calculate rank in selected records in sql server 2000
  447. missing values of a sequence
  448. Creating an alert for a deleted row
  449. SQL Server - synchronizing database changes across servers
  450. Rounding not working
  451. How to connect to mainframe through Integration Service
  452. Getting record position in sql server 2000
  453. Deleting Tables
  454. whats the dataytype we should use to store multimedia file
  455. Change order of column in SQL 2005
  456. call script from another script
  457. nub question :(
  458. join tables with max record
  459. Triggers and Flag bit
  460. Space Delimiter in a flat file
  461. IO Completion Listener
  462. Error Message
  463. Create Table Conditional
  464. Selecting alphanumeric combinations that do not exist already intable?????
  465. Between & Dates
  466. Doing Summation on multiple criterias on the same column in a singlequery
  467. Stored Datapaths in SQL using C#
  468. Salray for SQL DBA (4 years exp) in UAE
  469. Identifying Error Line in a Stored Proc
  470. Table Schema
  471. Truncating the data for TEXT fields in select query.
  472. Data Type
  473. Table Schema
  474. Restoring Bakup File in sql2005
  475. Connection To Sql2005
  476. Case statements in MS SQL
  477. Data Shifting Between Records
  478. about number of columns in a table
  479. covert data from one table to another
  480. saving stored procedures in sql server 2005
  481. datetime field in SQL Server 2005
  482. Indexing in sql server 2005
  483. XP_cmdshell not working
  484. MSSQL View SQL from GUI
  485. What are my TRIGGER options?
  486. db mail questtion: How can I clean up the format
  487. DB Maintenance Plan Append Vs Overwrite
  488. got the error:provider: Named Pipes Provider, error: 40 - Could not open a connection
  489. insert querry doubt
  490. Duplicate key ignored AND statement terminated
  491. SQL Server 2005 ODBC Logging Problems
  492. Moving SQL 2000 to a new machine by copy-paste !!
  493. Probs in DateTime query
  494. SQL 2005 Workgroup Edition - how to run a trace
  495. SQL2005 performance problem
  496. Maitenance Procedures
  497. Newbie to T-SQL (and can't get my if..else to work in WHERE clause)
  498. Selecting all from Super-Types and Sub-Types
  499. While Loop
  500. Inserting nothing takes a long time
  501. how to export sql server-2005 table data into excel sheet
  502. Minimum values
  503. auto run
  504. Problem getting information form system tables
  505. traverse and finding dates
  506. Problem with table creation & query
  507. Your resume is shortlisted - apply immediately | More than 85 TOPcompanies recruiting this week
  508. Does Sql Server Enterprise Edition work on XP Machine?
  509. smalldatetime convert problem
  510. Help with the WHILE Statement
  511. Can users be connected during a SQL backup?
  512. job died but why?
  513. Lost SA password
  514. SQL Server OleDB Provider alternative
  515. What privilege is needed to run DTSRUN ?
  516. using fn_trace_gettable on trace files where the path contains aspace.
  517. mssql syntax error in stored proc
  518. Two timestamp datatypes in single table of SQL server2005
  519. Assertion
  520. Deleting a similar record
  521. JDBC Properties setting for ANSI
  522. Question
  523. To Create New User
  524. Probs In Query
  525. Informix SQL to SQL 2005
  526. Data Replication
  527. Osql error trapping
  528. Trigger to modify a table
  529. PatIndex function
  530. Dts
  531. JOIN from 2 Tables and combine several records into 1 record
  532. Stored Procedure Problem
  533. To connect to SQLServer 2005 database of a pc which is in domain from a pc in workgrp
  534. Retrieving data that matches a list
  535. Allow Guest account in Windows XP professional to use sql server
  536. Do not want to display record with same ID
  537. Selecting distinct values from joined table
  538. SQL Server 2000 Mail
  539. Updating selected options Logic
  540. 'nt Authority\anonymous Logon'
  541. URGENTT: Login failed for user '(null)'
  542. Functions
  543. Data from one table to populate a VB TreeView
  544. database connection for struts using sql server2005
  545. Porting Legacy Data to a PK
  546. Identifying which WINWORD process to proc.kill()
  547. Car-Sharing Offered - ICC Birmingham MS UK Product Launch, 19th March
  548. Bigint from a SQL Server table and viewing with Access
  549. query to text file
  550. Help with joining 2 tables