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