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. probleum in registering sql server7.0
  2. Where is SQL Server Enterprise Manager?
  3. DISTINCT is for a WHOLE rowset. How can I take out only ONE distinct column?
  4. About row size or length in mb or kb of a table
  5. Interview question
  6. Interview question
  7. Cascade Constraint
  8. Table Relationship Query
  9. MS SQL SERVER DBA/ CONTRACT/ IN
  10. Select from Stored Procedure
  11. Sum and Count in a Query
  12. Sql Server 2000: How To Handle Null In Select Statement
  13. How do you apply PK filters to FK tables?
  14. How to decrypt
  15. probleum in triggers
  16. Need Help, RaiseError, Check Constraint or Rules
  17. Sum up total hours for mutiple day entries
  18. Need help with creating a query to run in enterprise manager
  19. Info about system tables?
  20. Searching for Timestamp Datatype: New to MSSQL
  21. Triggers
  22. Creating an ODBC linked server in SQL2005
  23. Hi every one
  24. SQL Query Help
  25. mssql statment in visual basi c2005 experess edition
  26. Total row count from two different tables.
  27. Select every Nth row from a table
  28. help - extracting metadata
  29. Date Calculation Previous Years
  30. query to get number of columns in table
  31. SQL Query Problem
  32. Accessing Free-Text Noise Words File from SQL Server Clients
  33. IF condition in Stored Procedures
  34. What is encrytion and decryption
  35. count the no of emp under GPM list that emp with mgrid
  36. Finding SQL Licensing information?
  37. users connections
  38. SQL Servers equivilient for Oracles Lead and Lag
  39. Question about Update Statement - WHERE EXISTS
  40. osql
  41. Function - missing parentheses
  42. DateTime Automatic Formatting
  43. Table records will not appear...if
  44. help with sql server select statement
  45. Result Row
  46. Connecting to an SQLServer
  47. Urgent how to find set nocount is on or off in stored procedures
  48. Name value pair
  49. MS SQL question
  50. I want help with error message I get when I access remote DB
  51. SQL Select Statement Syntax
  52. How to Open Or read SQL Server log file .ldf
  53. MS SQL Trigger to update changes in a record
  54. How the data can be from .LDF file rather than .MDF file ?
  55. Moving Records from one table to another that meet a date between critiria
  56. function to extract delimited data
  57. ssis Bulk insert failed "Received an invalid column length from thebcp client...".
  58. help in sql query plaese. . .
  59. Ssrs + Iis
  60. MSSQL Full text search question
  61. Generating Reports from Two Different Databases in SSRS-2005
  62. MSSQL DISTINCT multiple fields throws up odd results
  63. Creating custom Primary Key in SQL Server 2005
  64. sql server installation problem
  65. Query only returns one value
  66. Problem Inserting Unique Rows into a Table
  67. converting nvarchar to int
  68. pictures in a database
  69. Email
  70. Select all the distinct rows with a condition.
  71. like function on a column
  72. At most one record can be returned by this subquery
  73. copying data WITHOUT DTS
  74. Comparing "Sets" of int`s in SQL Server 2005
  75. Formatting a Number
  76. Converting Rows into Columns
  77. xquery - dynamic field name
  78. Sub Query retrun many records
  79. Sequences in MS Server
  80. create trigger for insert (SQL Server)
  81. How to remove all data from a relational database
  82. Urgent : How to register an SPN for MS SQL EXPRESS 2005
  83. Basic Question About Sql
  84. Migration from PostgreSQL
  85. Top companies recruiting this weekend - Apply with updated resume
  86. Doing a bulk insert into SQL
  87. Combining two row values of a same column into one
  88. null data
  89. Question about foreign key replication
  90. Table design question.
  91. Joins Question
  92. Single Quote In Variable
  93. Exam 70-229 :Designing and Implementing Databases with Microsoft SQLServer 2000 Enterprise Edition
  94. SQL Server Tutorial
  95. Regarding DTS Package Execute SQL Task
  96. adding constraint
  97. How to decode in SQL Server 2005
  98. comparing two tables to look for mismatches and a way to edit the table value
  99. INSERT, UPDATE clause inside UDF
  100. is case sensitive & normalization
  101. SQL compact edition 3.5 insert multiple rows
  102. intersect & except
  103. How can I format a datetime as 'yyyymmddhhnnss'?
  104. Dynamic Union of Tables
  105. How to group by date irrespective of time
  106. Copying a table with different column names
  107. Need CASE Statement(s) to populate 5 fields based on values of 2
  108. SQL Server 2005 Licensing concern.
  109. Problems with select statement
  110. Lost Full Text catalog that won't delete!
  111. how to use SQL in place of Adodc
  112. How to join two tables where one table keeps rows on a separate row
  113. SQL UNION with Replace in the ORDER BY clause
  114. Drop Primary keys
  115. Set Variable From Query Results
  116. History Tables: Always Subtables?
  117. [basic]union-join questions
  118. Removing 1 hour from text field
  119. Get long date info
  120. how to drop a temporary table
  121. Count Subquery
  122. Auto Primary Keys in View
  123. How to check execution logs
  124. Working with Reports in SSRS-2005
  125. About Sys.sql_dependencies in sql2000
  126. Linking error
  127. Can someone help me get started on administering MSSQL?
  128. Trying to create a Update query to update data from one table to another
  129. multiple inserts
  130. Distinct values
  131. Accessing temporary table from stored procedure
  132. sql-group by week
  133. Field Expressions in SSRS-2005 Reports
  134. How do I Converting DBF database files to SQL Server 2005 in one step
  135. How can I use variables in this TSQL Statement
  136. Calculations between two different rows same Table
  137. IS Null
  138. how to build tables at run time in sql server 2005
  139. iam new to sql
  140. query help sought
  141. What is Data type of ISBN and YEAR ?
  142. where is import and dts on sql server 2005
  143. checkbox
  144. windows form
  145. OpenDataSource fails from worksheet name starts with a number in xls file
  146. calculate score in ms sql
  147. 512 error in delete statement
  148. Bulk Insert - Dynamic Errorfile Filename
  149. Greater than statement for 2 columns
  150. Intimate via email to indentify the DB Suspect
  151. Newbie : Updating a table from a query
  152. Newbie: Find unique records
  153. How to recover a DB From Suspect
  154. SQL Job Failure
  155. newbie question: How to add extra SQL Auth. account?
  156. Importing Text File To Sql 2000
  157. Max Occuring value in a column
  158. what's the best way of importing a query from access to be a view in MSSQL2005?
  159. Changing decimal places in a query
  160. @@identity
  161. equivalent of SET NEWPAGE NONE in SQL server 2005
  162. Commands not available in 2005 Express
  163. Reporting Services Hide Duplicates Problem
  164. system DSN connection
  165. how to Mutiply different data type columns
  166. how to set and reset column identity by a query?
  167. store image in database
  168. Sql Query problem
  169. t-sql query
  170. Stored procedures Again
  171. How do I calculate something using values from two tables?
  172. converting oracle script to SQL server 2005 script
  173. Using findstr on SQL 2005 ERRORLOG file
  174. caching in Reporting Services
  175. Using Formula
  176. Transfering data from SQL Server Standard to SQL Server Express
  177. delete query from two tables
  178. query
  179. Query - select common data from one column and display in severalcolumns
  180. Creating a dynamic SSRS report via URL
  181. Replication in sql SERVER 2005
  182. Passing Multiple values in stored procedure
  183. ado net
  184. Using a "match" table to store multiple columns for parent data
  185. First SQL job
  186. Full Stored Procedures?
  187. Trigger ISSUE
  188. Add 2 hours to a time value!
  189. SQL Qurery help
  190. Running MS Access queries from SQL Agent
  191. Help Please.. Repost..
  192. sQL HELP
  193. Numeric error..
  194. Deleting a maintenance plan
  195. Plz Help
  196. Trigger problem
  197. SS2005 Merge Replication through message queue
  198. Trigger to find specific New Value
  199. Trouble with a count
  200. Difference B/W Triggers and Stored Procedurs?
  201. Group by DatePart
  202. Dynamic Columns in a table
  203. Problem with a lot of inserts in short time - SQL Server 2000
  204. ASP.NET C# web application to connect to SQL SERVER 2000 database
  205. Problem in Database mail
  206. Syntax to access database on another server
  207. Oracle date problem in SQL SERVER REPORTING SERVICES 2005
  208. constraints
  209. Basic MSSQL Query help
  210. Loop
  211. reduce time for search query
  212. An existing connection was forcibly closed
  213. Error on Transaction log backup
  214. SQL Function Help
  215. Insert/Update
  216. Backup Exec and MS SQL Server 2005
  217. problem regarding connection of vb and oracle
  218. how to calculate the date
  219. Track changes made to SQL Server
  220. hi
  221. Spaces after data in field
  222. Access To SQL
  223. Rebuild Index Fails, need insight
  224. Need help with SQL Server Cluster
  225. Retrieving duplicate consecutive records(How to make query for this scenario?)
  226. Dropped tables
  227. Passing a varible as an linked server name in openquery
  228. error in running the join query
  229. Insert Query
  230. Urgent IT related openings with Corporate MNC companies all overIndia
  231. Working With Two Different Stored Procedures from Different Databases in Sql Server
  232. Problem in SQL Server 2005 in Database mail configuration
  233. SQL 2000 Profiler
  234. SQL database hang
  235. Replace one value with another in query result
  236. BCP import then export
  237. Doubt in COUNT(*)
  238. doubt in saving wave file
  239. Query string encryption in T-SQL
  240. system DSN connection
  241. how to check case for username password field in table?
  242. DB size increase from SQL 2000 to 2005
  243. stumped with stored proc and temp tables
  244. Linked Server - Connect to db2 on different server
  245. Get database name in run-time
  246. ROUND function
  247. Need Error_Number list with Error_Messages
  248. SQL question ( retrieving records based on a priority order )
  249. SQL2005 Aggregate Multiple Update optimazation: How-To?
  250. Autogeneration in MSSQL
  251. Use unique key for Sqlserver view for updates
  252. To fetch common values between two rows
  253. Sybase Event query (Multiple Inserts based on Select)
  254. get different result from 1 column in 1 query
  255. Help with SQL Query for Graph
  256. UPDATETEXT question
  257. Accessing values of comma delimited string
  258. Inventory SQL Server machines on your network
  259. xp_xmdshell and BCP select string problem
  260. Need help with delete trigger
  261. How to do the Bulk delete in Sql table?
  262. How to use Arrow keys to scroll the scroll bar
  263. Multiple Queries vs Dataset
  264. SQL Random number
  265. Why Same query results in two different # in SQL Server vs MS Access
  266. Trouble with one to many relationship in single SQL query
  267. Count from detail table
  268. MS SQL Server Multiple Rows into 1 column.. Semicolon Delimited.. Null Value Problem
  269. format date
  270. sql server data transmition
  271. Want to learn SQL in California....any school, literaturerecommendations?
  272. Problem converting access queries to sql
  273. Small SQL Engine
  274. SQL server multi-statement table function w/ openquery
  275. Calculate Client wait time with sql server process time
  276. Check for the Duplicates
  277. Freshers Recruitment & Walk-in For Freshers Feb 23-24
  278. SQL Script to sync. two servers
  279. AutoNumber
  280. Stored Procedure Thread Safe?
  281. Table replication question
  282. Sql Backup
  283. SQL Help with two table
  284. Replication in a single transaction
  285. Slow performance in SQL2005
  286. Need Help On Multiple Max Values
  287. Query Plan Tool on my web site
  288. Multiple Identity Columns
  289. SQL Query with Self Join
  290. Create a dynamically incremented field
  291. Append .bak (Backup) file to Database using Restore command
  292. Output of a query in row intead a column
  293. Timeout when specifying server name
  294. How to seed or increment NEWID() value
  295. Addition of two numbers
  296. Online Query Tool SQL Server 2005
  297. Zerofill
  298. Problem with a select statement
  299. trigger not doing anything
  300. DTS procedure
  301. Linked Server and Oracle10 Performance Issues
  302. Need help with database usage history and backtrack
  303. Log File Recovery.
  304. Compatibity of SQL server 2000 and 2005 database!
  305. Problem With SQL UPDATE
  306. Round Function
  307. Unmatched query multiple criteria
  308. SQL Server Performance Issue
  309. does the table follow normalization
  310. Running SQL scripts programatically
  311. Help Needed For writting a query (SQl Server 2005).
  312. simple connection
  313. Database Search
  314. Like
  315. Querying First Time In And Last Time Out
  316. CharIndex, Left T-SQL question
  317. importing multiple excel files
  318. delete otherwise duplicate records based on differing values in one column
  319. Duplicate records and set field to constant
  320. Multi-Line Coments
  321. Compound aggregate (Max of Count) procedure question
  322. Create user similar to 'sa'
  323. Trigger Question
  324. Subselect top1 - need two columns.
  325. Suggestions Plz
  326. convert oracle trigger to sql server
  327. Combine keyword and search result ?
  328. Patni Computers written test question
  329. SL Sum question
  330. sql and bcp bulk import tab delimited from text file
  331. What is the range for smallint
  332. get the latest changed records
  333. TimeOut expired error when selecting more than 300 rows
  334. Update table using triggers
  335. need of SQL Dumps
  336. Always return something on a ZipCode Search
  337. SQL 2005 OSQL qestion on Microsoft cluster
  338. group by Ntext
  339. Trigger
  340. How to insert Price in SQLServer usimg decimal datatype
  341. Query from two tables that looks for a missing value
  342. SQL Server 2000 Connectivity
  343. Adding conditions in the ON clause of a JOIN
  344. Enum the running SQL instances using DMO
  345. Calculating Age median from list of Dates of Birth
  346. Interactive Sort on Matrix in RS
  347. Update Table A based upon secondary query of Table A & Table B
  348. GetElevation function
  349. How to check setting of CONCAT_NULL_YIELDS_NULL
  350. Comparing results from a column to results from a form?
  351. Why does Error log show database restarting everytime a transactionlog backup runs?
  352. Full Text Search of Microsoft Word Document
  353. FIFO Stock Taking...in Sql 2000
  354. Dbcc Indexdefrag
  355. Urgent walkin interviews from top rated companies
  356. Problems character sets / special characters dot.Net <-> mssql-server
  357. Linking two databases and copying details to third database
  358. Changing the Owner of System tables in sql server 2000
  359. sql command error
  360. SQL Server Connectivity
  361. Subtracting grouped counts
  362. Trrigger problem
  363. server/client connection of sql 2000 in 2 computers
  364. update sql with results subquery
  365. on line discuss
  366. SQL -Need Help
  367. update subsquery with Not = condition
  368. SQL: Write 24 rows undependent of how many sows sql returns.
  369. xquery help needed... can .modify be parameterized?
  370. grab 2 sets of data from single table based on a condition
  371. Syntax help - Subtract two years from current date?
  372. how to write a sql select query script
  373. How to divide a value into Two
  374. Help
  375. SQL server instead of trigger
  376. Advantage of creating Reindex
  377. how to Know dboption
  378. need assistance with database mail, sp_send_dbmail
  379. ODBC connection monitoring
  380. Transfer mysql DB to MS SQL help
  381. Need example query using Timestamp
  382. SQL Data fetching from asp..net
  383. Best practice for comparing 2 tables
  384. Primary Key fails to copy in db Export
  385. sql server to access
  386. Stored Procedure for deleting multiple records from 3 tables
  387. System DB backup Error
  388. Group By with 2 outer joins
  389. Multi-Values??
  390. Aler tables in CASCADE Mode
  391. Filtering, sorting, summing
  392. Staging the Value
  393. What is wrong? Update value from one database to another
  394. SQL Server Reporting Services Configuration Error
  395. how do i create database in sql server
  396. Encrypt and Decrypt a string variable
  397. Why does numeric data type use storage inefficiently?
  398. Inserting Rows from a copy with a Primary Key, and a GUID
  399. Create a new table from csv file using SSIS
  400. Distributed Transactions across Linked Servers
  401. application.startuppath
  402. Trigger on Replicated table from another Database
  403. Execute a UDF
  404. Comparing strings in SP
  405. Help in Table level restore/backup
  406. Use of triggers in Sqlserver
  407. Where deleted DB/Tables stores?
  408. sql server migration issues
  409. Select
  410. MS SQL Server 2000: automatically rows inter changed in database
  411. how do i handle
  412. want to pull data with leading 0
  413. case in joins
  414. Basic MSSQL Query help
  415. Rowlock v. optimistic concurrency
  416. Sql Connectionstring
  417. Cross tab query
  418. Distinct Latest Records
  419. Databindings
  420. Identity on 2 fields
  421. How to display skeleton of table in sql server 2000
  422. Sending mail from DTS
  423. Syntax error in the case statment
  424. VB6/ADO/SQL Server -- Error 3265 : Item not found in this collection ...
  425. Crosstabbing (or rotating) a sql table
  426. stored procedures
  427. SQL Syntax Error
  428. how to hndle month
  429. Query to get total
  430. Get multiple column values as one item?
  431. Having problem with Update from query
  432. Complex MS SQL Query help
  433. Need link between MS Excel and MS SQL Server 2000
  434. How to find out the number of days in a financial year.
  435. Timeout
  436. Loops taking long time to run in SQL 2005 standard edition
  437. Help
  438. trigger:-Subquery returned more than 1 value. This is not permitted when the subquery
  439. Import dbf file into SQL Server - numeric fields shrink by 1 digit
  440. Table Data from Name
  441. Need help writing a stored procedure
  442. Command text was not set for the command object - error from dbms_lob.writeappend
  443. Combine rows in a table that are only different in one column
  444. Connect Access to SQL Server
  445. Query analyzer on desktop
  446. difference between primary&secondary files
  447. question
  448. How to set default value for a datetime column in mssql
  449. Slow Sql Query
  450. sql learning
  451. Migration of MDB forms into ADP and connecting to SQL
  452. autonumber
  453. Legacy DTS job to copy data from SQL005 to mainframe DB2
  454. Data Mashing
  455. Poor Performance with Lazy Spool Operator
  456. Transfer data to web page fields
  457. Sum
  458. Bit Data
  459. win32 or x64
  460. Dlookup issues with Query converted to Passthrough Query
  461. Need help merging 2 tables into 1
  462. Not able to update using LIKE % clause in MSSQL
  463. FreeTDS / SQL Server 2005?
  464. Recovery data from LDF file?
  465. Operators
  466. Calculating the Date Difference dynamically
  467. Inserting image into SQL database
  468. Rollback Of Modification
  469. Database optimizing vs Total Columns in a table
  470. [How to] avoid cross product/Cartesian product to improve performance
  471. Usage of CONVERT function in where clause (in SQLSERVER)
  472. Migrating data between two different servers
  473. Creating Report
  474. Need link between MS Excel and MS SQL Server
  475. sorting with null
  476. automation error, the specified module could not be found
  477. Inserting multiple records into two tables...with a twist
  478. Union Tables without duplicating lines with NULL values
  479. Sum
  480. Need help with reporting service security
  481. One subscriver, multiple phone numbers.
  482. trig errors
  483. MSSQL not showing seconds even after using datetime as the column type
  484. Create Report
  485. update with a one to many
  486. Sql Injection
  487. SQL-Server 2005 suddenly doesn't accept date format YYYYMMDD
  488. Procedure to moniter database
  489. Triggers in SQL 2005
  490. SQL server indexes through access (vba)
  491. Alert doesn't work on SQL 2005
  492. Sort By Name Except Other
  493. REPLICATION
  494. crazy statement :) please help
  495. aggregate rows of one column for each row of another column
  496. Select statement query
  497. delete records from one table that occur in another
  498. how to release a table lock..?
  499. Datatype
  500. connection string
  501. Datagridview Print
  502. Changing a column datatype
  503. multiple numbers in one statement
  504. Deploying CLR trigger to SQL-Server 2005 -- Permissions Required.
  505. help needed with update
  506. Get previous record before given date SQL Query problem
  507. sql query help
  508. helo needed with stored proc...
  509. top4 by bank
  510. SQL in(@parameter)
  511. Changing the datatype of column
  512. how to sort fields in table
  513. Converting rows in column header
  514. Database structure synchronization with LINQ to SQL model
  515. stored procedur
  516. Query Problem
  517. DTS import for VB6
  518. SP Generate Random String - Check if String Already Exists
  519. Process a String from a Table to decimal value
  520. How to use Print() in cursor?
  521. Rmote database inserts blocking local queries.
  522. get non matching rows from table 2
  523. SQL resolution order question
  524. Suddenly, queries against one table "never return"
  525. RecorCount get 0
  526. Tsql
  527. Exporting datas
  528. Problem with putting a database in single user mode
  529. stored procedur
  530. pls help me its urgent.....
  531. Performance issue using conditional WHERE clause
  532. MSSQL: Stored Procedure, using an in-line procedure?
  533. Update and select next value from a list
  534. Database table design for performance
  535. SQL Connection to Web Server
  536. Error in connection...The ConnectionString property has not been initialized
  537. Ordering Months in Calendar Order
  538. Moving data from SQL server to Postgre or Oracle or Cache
  539. aspnet_Roles and aspnet_usersinroles
  540. how to import values from a notepad file to a sql server 2005 table
  541. Sum statement has no records
  542. To filter store procedures that only do select operation in a particular Database
  543. Help with subquery WHERE EXISTS or IN
  544. Correlated Subqueries vs Joins
  545. Getting NULL value when Importing spread sht to sql table
  546. Months Between
  547. Problem migrating DTS to SSIS
  548. Transaction File Backups Not Deleting after specified timeframe
  549. Reports
  550. How to round a float value