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