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