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