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