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. Sql service is stopping.
  2. Creation of index on Varchar column
  3. Using SSRS with MS Access information?
  4. Order of execution in queries
  5. I cannt Start SQL Browser
  6. SQL Server does not exist or access denied.
  7. Slow SQL Trigger
  8. How to combine both row data with column name and get as output
  9. Add ForEachLoop in SSIS 2012
  10. SQL Server Keywords in XML
  11. How do I limit the count to 1?
  12. how to pass table name as parameter in stored procedure in sql?
  13. anonymous block
  14. Is Filtering on the basis of dates decreases the performance of query?????
  15. HQL Query Japanese Text in an NVarChar?
  16. what datatype should be used to save imageurl in database
  17. Code review tools for SQL 2005
  18. SSIS Package not able to loadfromSQLServer in a scripting task
  19. Microsoft SQL Certification Materials
  20. dynamic column creation
  21. Using BULK upload, how to remove Space present in file
  22. Show Multiple rows of data in line line
  23. How do you get the sum of all the detail rows in a BIDS report?
  24. error '80040e31' Timeout Expired but runs fast in Query
  25. Repeating in sql query, how to remove
  26. Bulk import CVS file (comma delimited)
  27. How can i upload a file in jsp and storing it in sql server using servlets?
  28. What is the best data type for storing different file types in ms sql server 2008 r2?
  29. How do I aggregate rows into a single row?
  30. My append query won't add new records.
  31. How to load data into table with foreign keys
  32. Import data to SQL DB Using Bulk Upload
  33. Incorrect Syntax near the keyword 'IN'
  34. MS access updating to SQL Server Identity Column potential weakness
  35. Bulk insert fails sometimes for a given file
  36. Function is Causing Deadlocks
  37. Using LIKE syntax in nested query
  38. Cannot attach mdf file named master
  39. SSIS job fails intermittently only on production.
  40. How can I find Miscrosoft SQL Sever 2005 notepad?
  41. SSAS and SSMS memory limitations
  42. Replace logic is required
  43. How can I set values of variables using a loop?
  44. sftp batch file
  45. load data from one DB in a server to another DB in another server
  46. ssis execute sql task
  47. Spatial index hints don't work in SQL Server 2008?
  48. Text searching
  49. SQL error 2714
  50. how to caluculate average of duration(starttime-endtime)
  51. Join T1.distinct_identifier to T2."choice"_identifier
  52. Please help writting this query
  53. How to Add an Auto-Increment Field With a Unique Name
  54. how sql server decides datetime format to use implicit conversions?
  55. Modify "Script Table as" template
  56. need to convert data
  57. Invalid column name 'RowTimestamp'. In Snapshot Replication(SQL Server2008)
  58. Is it possible (if so , how) to filter out Distinct values from a Query that uses two
  59. how to normalize tables
  60. text direction right to left for arabic text input
  61. Val() is not a recognized function name?
  62. A SQL query on the existence of columns in two tables
  63. Return value from stored procedure is "nothing"
  64. Jsp-Sql Server 2005-Unicode Symbols
  65. HHSS calculation
  66. set blank password for sqlserver 2005 for XP?
  67. T Sql join query
  68. MAX Date Value
  69. Restarting System?
  70. Transfer Data from one table to another table
  71. Inserting only time in the database
  72. Repeatable Read doesnt prevent this or am i wrong about it
  73. How to find Uppercase text in a text field
  74. SQL Server Report Builder 3.0, and I can't get the data to the formated report.
  75. Could not open a connection to SQL Server
  76. sql-Violation of UNIQUE KEY constraint 'UNQ_SID_PID_DOCTYP_DELMETH_SRC'. Cannot inser
  77. How to Add Dependent Variable into Where Clause?
  78. automatically run a SQL statement quarterly or monthly
  79. How to transpose this table ?
  80. Updating Datetime field in sql server database
  81. Dynamic date on Leap Year
  82. select max
  83. problem with trigger
  84. SQL agent Error - Critical
  85. using group by in tables joined together in sql server
  86. Joining tables on columns with differing data types
  87. How to speed up query that returns nulls and dates within a range
  88. Set timeout for a stored procedure across a link to another server
  89. Undoing a delete operation
  90. How to create a jobb that sends an email
  91. Performance Improvement of Stored Procedure
  92. Stored procedure to cancel an order
  93. SQL Server 2000 Temporary table(#temp) issue
  94. i want to calculate base on condition
  95. Picking latest 'duplicate' entry and linking to second table
  96. Change mdichild on runtime
  97. Update query with split funtion
  98. Help on selecting current record from one table with additional fields
  99. How to get rid of generated constraints?
  100. How can I hide my code from a stored procedure
  101. Case statement insde where clause
  102. Putting attribute on root node using FOR XML PATH & With XML NameSpaces
  103. Workstation Components
  104. Zip Count
  105. Rollback
  106. DB design for Privacy setting
  107. Combine more than one column in the same table and display the result as next next li
  108. Case statement and group by clause in function
  109. How to read from a text file in SQL query ?
  110. Median Calculation on a Column in a Table
  111. Nested Query
  112. substract two date
  113. Concatenation of Two Strings
  114. sql after insert trigger
  115. Not in or Not exists sql help please
  116. Case when statement in where clause
  117. creating an insert update trigger in sql
  118. WHERE clause with IN clause with CASE WHEN...
  119. COALESCE with MIN
  120. select count(*) from table_name not showing desired result
  121. How to validate textbox control in vbSql?
  122. How to correctly use join i sql queries
  123. Complicated date selection
  124. Multiple Queries from the same table ordered by user not working
  125. Right Join and Left Join acting different
  126. SQL Server query connecting through SAS
  127. Reset Database to default/initial state
  128. How Do I Retrieve job Information that how many times it occurs in a week?
  129. Transferring Data from one database to another located on the same server
  130. Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'mas
  131. How do i compare 2 rows from the same table (SQL Server)
  132. The conversion of a char data type to a datetime data type resulted in an out ofrange
  133. SQL Query to display records that dont match in consecutive rows
  134. Combine multiple records into a date time line.
  135. Sub query Question
  136. Sqlserver Instalation in command prompt with Mixed mode?
  137. Sql Server Tuning
  138. I am new to SQL can anyone tell me what this hint does?
  139. how to recover deleted records in sql table?
  140. how to fetch total working hours from the table for every employee for a week
  141. Disctinct query plus total column value
  142. subtract two datetime values
  143. Automating Sql(2008R2) backup/Restoration process
  144. Sql Transaction log for database is full
  145. data from Four table
  146. sp_who
  147. ssis derived column
  148. Output type of following query
  149. how to find working hours
  150. Remove Single Quotes from data
  151. Call .sql from .sql
  152. Converting number to text for concatenation
  153. SQL server VS2005 Between Date problem
  154. Ho Do I find List of file names on specified location in SQL Server
  155. To update single column of multiple table
  156. Printing File using SQL Procedure
  157. Txt File Print in SQL
  158. ssis derived column
  159. How do I Find Best Match of Disease from Symptoms
  160. IF ELSE to cause a WHERE
  161. SSIS send mail task
  162. call dll file in sqlserver
  163. How to Get Indian Standard Time in Sql server 2005
  164. getting the first letter of each word
  165. string vs varchar
  166. Ms sql
  167. Filter duplicate value
  168. Searching between 2 Date Values using vb sql
  169. date Form Datetime using Where Clause
  170. How do you select current record data to assign to variable in While statement.
  171. Case Select on 1 to many record relationship
  172. Question about RowNumber
  173. how to convert the unicode string to four byte signed integer
  174. How do I Set a defined variable = fieldname?
  175. Mutilple rows should write into one row with TAB delimited
  176. How to format a date from a form for SQL server
  177. I'm trying to import from a table of a password protected Ms Access database by using
  178. How to check indices with other columns?
  179. I got an error message when I am trying a select Query to import a table from Ms Acce
  180. The name "xxxx" not permitted in the Context (insert) ???
  181. GROUP BY troubles
  182. Avoid Duplication
  183. SQL Server Index Screwup??
  184. Choosing to select a column based on null values
  185. Using SQL Developer to work on SQL Server
  186. Timer for Executing the procedure automatically
  187. how to find the data type of a field in a table
  188. How does one do the reverse of a union query?
  189. sql exec copy file failed
  190. Converting from SQL server 2000 to SQL server 2005
  191. How to send tables as XML files?
  192. Help About Stored Procedure In Sql Server 2008
  193. Inserting values using INSERT INTO
  194. SubReportprocessing - RDLC
  195. Help in stored procedure Using Sql Server 2008
  196. How Can I Do Stored Procedure ?
  197. Batch script for database restoration
  198. Can one copy data dynamically from ms SQL to DB2
  199. getting error which says to create unique aliases for duplicate fields
  200. bulk query
  201. select sql query problem
  202. Insert into table after update trigger
  203. Sql database
  204. Dynamic SQL query Multiple rows based on table names linked in another table
  205. Update Last Record in SQL Server 2005
  206. SQL Server: Create an ID field (PK) based on two fields with a trigger-- HELP!
  207. How to Display Column Data in Comma Separated Form in SQL Server
  208. Can not connect to SQL Instance without specifying Port.
  209. migration
  210. How to provide password to SQL Database
  211. Bulk Insert with Errorfile
  212. SQL select query
  213. Is it possible to skip a bad record when selecting records from one Table?
  214. How to display the first record of the group in the group header in SSRS
  215. New to sql server could someone point out the error in this query
  216. Change php mysql to php mssql
  217. how to exec a query stored in table field and the field is TEXT
  218. Problem with a complex SQL Query for SQL Server
  219. Query multiple fields in same table.
  220. Sql, mysql
  221. Update statement in sql server timedout
  222. Using a variable in VARCHAR
  223. SQL Query
  224. SSIS packages - Transformation Help Require
  225. Result of comparing null
  226. SQL Query to text file "WHERE" syntax
  227. Can I safely disable VSS Writer?
  228. Return Only Sat/Sun dates in a date range
  229. Looking for some help with JOIN logic
  230. sql year function
  231. Bulk load: An unexpected end of file was encountered in the data file.
  232. Merge data from one table into another
  233. SQL Server mail won't alert my phone by text message
  234. Scheduling stored procedure to run once every hour
  235. How to get a cumulative total of fields up to a date specified in each record?
  236. sql if conditons
  237. server msg :207 errror
  238. Enter into database only new values found in the SQL statement, skip the ones already
  239. SQL Server Native Client
  240. SP to add next sequential user ID
  241. Prompt for User Input
  242. How to edit dataset.xsd created in sql server 2005 in sql server 2008?
  243. Delete error: Key column information is insufficient or incorrect
  244. Error in inserting multiple records
  245. Number of people logged onto SQL database
  246. updates in sybase
  247. append from table1 any sql equivalent query
  248. Connect to programme from other pc's
  249. Role Based Authorization to pages in an Application
  250. Maintenance Plan schedule fails
  251. Japanese sorting In SQL
  252. punctuation in between characters
  253. Agent Job Duration exceeds manually launched program duration
  254. Trigger to update multiple tables
  255. How can I transfer an encrypted stored procedure in SQL Sever 2008 R2
  256. how to join based on substring in sql query
  257. Insertion Into Multiple Tables Through Stored Procedures
  258. How to remove unwanted ASCII character in a SQL column
  259. How to decrypt the encrypted stored procedure in sqlserver 2008
  260. Pass throughs / UDF / Stored Proc / Views.. The differences in my upsize..
  261. SQL Server drive died, data drive is OK... now what?
  262. copy rows for a speadsheet that matched a word in a partuliar coloumn
  263. Our developers suddenly need to specify port number.
  264. Multiple foreignkey in single column
  265. Connecting Php with MSSQL server 2008 remotely
  266. SQL: what is the diff between "any" and "all"
  267. Error while using Aggregate function(sum) with joins in sqlserver
  268. sql server 2000 database file unable to attach in sql server 2008 ?
  269. SQL login error
  270. subtracting 2 datetime values
  271. PIVOT or CASE? - Combining multiple rows into 1 row..
  272. Fix Error SQL Server 2005 Reporting Service
  273. Transaction log
  274. Setting up Linked Server on multiple servers with mulitple types of authentication
  275. How to copy rows from one table to another with same structure
  276. Get records based on month and year
  277. how to extract an email from the FROM field
  278. How to retrieve column name of table in SQL 2005 and display in dropdownlist in ASP
  279. Report Service Subscription
  280. Data conversion
  281. How to get required output in sql
  282. Stored Procedure Sub-Select?
  283. find nearest meximum date
  284. How to remove carriage return and line feed at the last record of the flat file
  285. Is Microsoft SQL Server 2008 Standard version compatible only to Windows Server 2008?
  286. How can i use a different NT user (not the login one) to connect to sql sever?
  287. CLR for sql server 2005
  288. LIKE Parameter Problem Stored Procedure
  289. Update WHERE checking with another database
  290. Using a max for the Added Date
  291. Highlight max value in a subtotal row of a crosstab
  292. dynamic variable names from table
  293. SQL Server Express 2008 R2(free version) from SQL Server 2008 R2 Management Studio
  294. Displaying Query Result Vertical Display
  295. scientific notation to original numbers
  296. Installing ODBTP
  297. sql 2000 security sa password problem
  298. alter statement
  299. INSERT INTO EXCEPT doesn´t work
  300. removing redudant data
  301. How can I do a "Grouped TOP 1"?
  302. Comparing data in two tables to find missing records
  303. Getting current date as part of an Stored Procedure
  304. Add not null
  305. Dynamic order by
  306. Crystal report date parameter and sql expression
  307. update customer id numbers
  308. calc % from 1 col 1 table
  309. create after insert trigger
  310. Corruption of Metadata in Analysis Services
  311. INNER JOIN Options
  312. Trace Table in Sql Profiler
  313. bulk insert rowterminator issue
  314. How can i take my DB mapping?
  315. Last deleted record
  316. Copy of Production DB into Reporting DB on daily basis.
  317. how can get below output?
  318. What is the best practice for databases containing People and Organizations?
  319. error 26 connecting to named instance sql server from network share
  320. Installed SQL Server 2008, how to create an instance
  321. How to remove duplicate rows from a temp table
  322. Adding Active Directory User as Sql server users
  323. Id reset every 12am
  324. Displaying Data Accross
  325. Update a column when..
  326. SQL rows to columns plus calculations
  327. connection error with sql server 2000
  328. select count with table join
  329. Error while opening my Executable file?
  330. 95th percentile and Median functions in SQL server 2008/2005
  331. Query to Find Unmatched Data
  332. The dependency service or group failed to start/
  333. Transpose Data into Buckets
  334. Time Out Expires messages during printing and transactions
  335. Replace the variable value with new one (in all SP's)
  336. DBA member updated the data. How to confirm that he did the update.
  337. Updating ',' separated values in sqlserver with different values
  338. Encode special character for sql insert statement
  339. best book for SQL server 2008 design and implementation (70-433)
  340. Snap in Creation Failed
  341. SQL 2008 vs pervasive
  342. How to get reference information between parent and child tables (MS SQL Server)?
  343. Log Shipping inital Backup left in (restoring...) mode
  344. MS SQL Trigger only for insert.
  345. Overpunch Character Conversion
  346. how to write a trigger after insert
  347. SQL Table = Access DB Table = Excel Spreadsheet
  348. copy table data from ane database to another
  349. Import and Clean Dirty Excel 2007 Files to SQL Server 2005
  350. How to include count to complex 3 table query
  351. Outer Right Join on SubQuery
  352. Alter all tables of a database having one column common
  353. MSSQL - Search and Ranking - Strange Occurrence
  354. How to add years to date?
  355. Convert Access 2003 to SQL SERVER 2008
  356. Get table sizes from DB
  357. How to return results for multiple words in query?
  358. Invalid column name
  359. Inventory counting system advise/critique
  360. SSIS package script exception: device is not ready
  361. size limitation for dynamic SQl query
  362. What is the maximum number of records SQL Server 2000, 2005 and Oracle 11g can handle
  363. Visual Studio "freezes" when connecting to MSSQL
  364. SQL database design question
  365. eliminate comma from string
  366. Excel data to populate SQL tables
  367. Using Like statement in parameters
  368. sql query with sub clause
  369. Filter Scalar Subquery
  370. how to update a value in other table
  371. Data Of AutoGenerate ID Columns Of Sql-2000 Server
  372. SSIS: Comparing/Manipulating multiple .CSV files
  373. Sql Update Query
  374. Creating team match ups using unique combinations
  375. How to load records into a subform using stored procedure
  376. Cannot Start SQL Server 2k To Restore DB's
  377. SSIS Taking to Long in Pre-Execute phase after switching to Access 2007
  378. How to set dates in a single row?
  379. How do I arrange my tables information in alphabetical order
  380. Single login for multiple database.
  381. Help With Query to Get Totals Sorted by Month & Year
  382. how can i convert my DB access to MS-sqlserver?
  383. Should i create separate login table??
  384. how do I join two complex Statements with different number of targets
  385. Error converting data type nvarchar to float?
  386. how can transfer the data?
  387. database not support arabic language
  388. Getting results using Union
  389. Sql Server Works Slow in Network
  390. SQL Server 2005 how to partitioning an existing large table
  391. creating Trigger for every table in a database
  392. About syntax
  393. What is a SQL Injection?
  394. What is the exact meaning of sql pooling ?
  395. Select the first string
  396. Problem in installation of SQLEXPR32.EXE
  397. Anybody know how to restore sp_addlinkedserver procedure?I dropped accidentally..
  398. i have got an error when i execute an internal representation of the XML document.
  399. Need help for NOT EXISTS query
  400. VARCHAR(MAX) only contains 8000 characters?, Need more than 8000
  401. The column prefix does not match with a table name
  402. Importing multiple tables
  403. Only printing 8000 characters after using varchar(max) instead of max(8000)
  404. Getting error :- Msg 170, Level 15, State 1, Line 18: Incorrect syntax near 'MAX'.
  405. How can I grant "deny access" to all but 4 tables in a schema?
  406. How to update data in a table based on holidays of the specific year?
  407. SQLMail sitting in outlook
  408. Getting an error When i am going to convert my SP as dynamic
  409. get start date and end date sequence
  410. Login failed for user
  411. How to update the data using stored procedures code?
  412. Finding MAX value from emp_id column using SQL query?
  413. SQL Syntax Error
  414. Slow SQL Server Express (50 times slower than on other machine!)
  415. sql2000 with windows2008
  416. Query Req:of having same days
  417. DateAdd Function
  418. How do I create a trigger that will insert only changes to a field?
  419. Stored Procedure or Trigger for the login
  420. how to write script in datafolw from Excel to DBTable?
  421. Ambigiuous column name
  422. How to transfer Data from Multiple Excel sheets to single Database Table?
  423. Coverting decimal to a date value
  424. What is the syntax for nesting a query in mssql2005
  425. Sql pivoting dynamically
  426. nested query
  427. Increasing by percentage
  428. File Browser for Access 2010
  429. Sql SUM and Update
  430. How to install microsoft sql server 2000 as server tools on Windows XP?
  431. How can i use REGEXP_LIKE() in sqlserver?
  432. How to use concat method in sql server?
  433. How to use sequence method in sqlserver?
  434. How to select Max ID following Insert Statement and direct it to the following page?
  435. How to fix "Error : Source file or directory missing or cannot be read" error?
  436. How to connect to sql server 2000 on a LAN?
  437. My computer's SQL server is not working properly.
  438. Cannot create link from SQL Server to MYSQL
  439. How to fix "Source file or directory missing or cannot be read"
  440. How to query for conflicting values in a table?
  441. How to create an EXCEL file in advance and want to export data to it in sql2008?
  442. Error when using openrowset for particular record
  443. How to fix error "invalid column name"even though the column exists in the table?
  444. Calculating Min/Max Timestamp Intervals For Inserted Rows
  445. Who to return two counts in the recordset?
  446. how make stored in sql to search between 2 date and search by date only without time?
  447. SQL 'FOR XML' query
  448. How to modify records in tables on web server using desktop application?
  449. HELP: error 3154 when restoring a backup file
  450. how can i use NextVal() method in sqlserver?
  451. Hellp Convert MS Access Pivot querty to MS SQL
  452. Junction Table or bit field?
  453. SQL Create Dynamic Table View From Another Table
  454. How to Import CSV into MS SQL?
  455. Insert into two related tables
  456. Is there any equivalent for Oracle's NEXT_DAY function in SQL Server?
  457. How can I connect Sql Express?
  458. How to convert database from ms sql server to mysql?
  459. Recordset becomes NULL after first read/use
  460. Information-Schema and Sys user accounts
  461. How can I use output parameters to return some values from database usin sql server?
  462. MS Access connections issue with SQL server
  463. How to insert Arabic characters in MS SQL Server 2005?
  465. How to resolve error 233 in sql server 2005 in windows 7?
  466. How to pull multiple fields into one query row?
  467. How to create a job to run a query and save the output in .xls format?
  468. SQL 2005 Tables seem to have become read only from Access database
  469. two queries summing into a single value
  470. sql parameters
  471. How to convert rows into columns?
  472. check all data from a SQL table dependent upon another two tables
  473. Why unique takes only one null as we know all null are not equal?
  474. How to fix error 26 when trying to connect to a database file?
  475. How to fix Invalid object name errors on working query?
  476. i want to restore backup from Network drive in MSSQL server 2003
  477. How to search 3 or 4 numbers from a string?
  478. How to compare date and time field in sql query?
  479. How to sort calcuation by date and transaction id?
  480. How can we add bulk data into a variable in SQL Server using Stored procedure?
  481. How to delete records of one table that exist in another table have no keys?
  482. How to take averages of data and place them into a temp table?
  483. How to calculate the next available Sunday to the following Saturday?
  484. How to fix syntax errors in this query?
  485. Is there a way to use like with an array of values?
  486. How to propagate date table automatically?
  487. How to select all records one criteria, but not another?
  488. How to redirect the Web Site Adminstrative Tool or create the Security DB?
  489. How to Retrieve Records of any other Date IF Current Date Record is not present?
  490. Is it possible to cast the return value of a compute avg(X value) to show 4 decimal?
  491. Is it possible to use .MDF file without installing full SQL Server?
  492. How to save in Sql Server or Filesystem?
  493. How to mark a date stamp and also 2 fields as yes?
  494. How to drop & recreate all indexes via script?
  495. How to show dates from Sunday through Saturday?
  496. Getting error message ORA-01008: not all variables bound.
  497. How to convert rows into columns and vice versa in sql 2005
  498. Help! SQL select statement for an uncommon task
  499. How to convert commas into periods?
  500. send mail through sp_send_dbmail in sql 2005
  501. Query optimization - where - ISNULL
  502. Rounding up to the nearest minute
  503. Can a table be both parent and child to another table.
  504. How to get Max value from a column?
  505. Converting a stringbuilder object to a stored procedure
  506. Need help recovering a corrupt SQL database
  507. How to move mssql data to mysql database ?
  508. What am I doing wrong on this one?
  509. How to increase the users to connect SQL SERVER 2000?
  510. Problem with updating dates
  511. Query of SQL Server
  512. SQL Case Syntax Issue
  513. General question about specific SQL problem
  514. Is it possible to generate xml from a sql server database using php?
  515. Select queries with columns populated with Null
  516. How to make column data into column headers
  517. Invoking stored procedure takes a long time to start
  518. Street Address Clean up using sql server
  519. How can i get records from table A which is not in B in sql server. eg A-B
  520. Get all Records from table1 and the correspond values from table3 verify MId table2
  521. Need help with scripting
  522. How to solve this syntex error?
  523. SQL Loading where to start?
  524. possible to use @variable in function?
  525. How to display a numeric value in different formats depending on value
  526. Job action completed Exception occured:unable to export file [0x80020009 ]error
  527. To copy the data in Excel file,XML file into a database?
  528. How to get list of tables linked to current table
  529. fetch value without duplicate column
  530. what is wrong with my select for the retrieval of function data - getting error 216
  531. Unable to connect to DB using ODBC
  532. Converting Number to Time in SQL
  533. Performing desktop queries vs. server based
  534. How to delete a unwanted university field from my instructor table?
  535. when I wright the statement in SQL 2005 error
  536. How does data indexing work in MS SQL?
  537. Is it possible to rename table to datetime?
  538. Why are leading zeros not displaying?
  539. Difference between oracle 9i and sql server 2008
  540. How can I compute my Age_Group field? It's based on a calculated field, CURR_BAMTIME
  541. Adding a primary key to a table
  542. Do i need to shrink database
  543. Update table with result from stored procedure/query?
  544. how can I retrieve the data '2010/05' by using the getdate variable
  545. how to select specific year/mo from table stored as varchar(7) '2010/05' in query
  546. How to select yesterdays records in sql server 2008?
  547. Why does an SQL2000 database appear to change size, then revert to original?
  548. execute procedure automatically at the specified time...
  549. How to setup replication between different Domains?
  550. Is it possible to use Case in Where clause as follows?