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