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