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