PDA

View Full Version : Microsoft SQL / MS SQL Server



Pages : [1] 2 3 4 5 6 7 8 9

  1. how to determine the column is identity column?
  2. The results that fn_get_sql() returns.
  3. SQL Server 2000 Enryption and Decryption Capability
  4. Using DateDiff to get time duration
  5. Tricky order by problem
  6. Selecting 1 random row from each of n random groups
  7. SP with an multiple values as input
  8. what table alias to use on update with self join
  9. DELETED Table
  10. How to get a 0 for value field when no records exist for that datetime..
  11. DB Syncronization
  12. Automating SQL Script Generation
  13. transaction logs-too large?
  14. Can not shrink a Database!
  15. Embedded and direct SQL
  16. Problem with BULK INSERT on an empty file
  17. How to list all tables of a SQL database
  18. execute a string as a logical expression
  19. White Space Problem
  20. IDENTITY not working
  21. Is this Code Reliable enough ? pls give comments..thanks
  22. Need help with a Tricky Update statement
  23. SQL Forum Problem
  24. Should This Produce Syntax Error?
  25. Stored Procedure Syntax
  26. Group by query
  27. need help with string manipulation
  28. nextMember
  29. str function adds a space
  30. ISNULL(MyTextColumn, '') returns error in View editor
  31. table variable vs temptable
  32. stress testing
  33. Unique Index for two columns in a table
  34. WHERE clause error
  35. SQL query help
  36. Help with complex SQL statement?
  37. Need a Book about Database Design
  38. USE variablename
  39. How to determine temporary table existance
  40. query help with substring
  41. Insert data to crossib qurey
  42. I need the result set of SP-1 in SP-2, How to get it T-SQL?
  43. asp file upload
  44. CASE or IF/ELSE
  45. error in user defined function?
  46. Multiple Cascade Flaw in SQL Server 2K
  47. Large recordsets ...
  48. GROUP BY Problem
  49. tutorial sites
  50. Program that inserts values?
  51. do I have to have a PK/identity?
  52. Interesting Query- Need Help
  53. How should I connect from VB to SQL Server?
  54. Updating SELECTED rows
  55. SQL help needed
  56. Question about the behavior of DISTINCT
  57. Incremental Load
  58. Odd Datetime Query Error
  59. complex sql script?
  60. suser_name() inconsistencies across servers
  61. Baffling stored procedure problem
  62. Dynamic WHERE statement
  63. Complex and Dynamic SQL Query ----------Please help
  64. Huge Log Files
  65. Top N rows
  66. parsing bug?
  67. Backup tables
  68. stored procedure much slower then same query
  69. Correct placement of SET XACT_ABORT ON
  70. OPENQUERY(server, 'msdb..sp_help_job ')
  71. index on table variable
  72. Append Variable
  73. Newbie: calling a UDF from a stored procedure HELP
  74. Question on Ownership chaining:
  75. Views Collection
  76. changing the current database within a stored procedure
  77. TO CONNECT A DATABASE TO MSDE
  78. Simulated Function in SQL 7.0
  79. parameterized sql scripts
  80. Date Conversion!
  81. Check in a Stored Procedure What violations have been done
  82. How to concatenate strings across many to one relationships
  83. Help in formulating a Query.....
  84. Cascading Ref Integrity in 7.0
  85. Return Value from Stored Procedure
  86. Import from exel to sql server
  87. newbie - trigger - syntax
  88. What is a merge join?
  89. newbie - triggers - is this what they're for
  90. Primary key or constraints in temporary table
  91. Newbie: Update all records of 1 table
  92. Stored Procedure and Variables...
  93. Eqivalent of Varry in Oracle for SQL Server ?
  94. auto start sql service when OS starts
  95. tion of a database
  96. Building Adwords mechanisem
  97. Dynamic SQL with variables in user-defined Functions
  98. Update Question
  99. ??? Domain Error Occurred ???
  100. INSERT INTO ... EXEC sp_who
  101. Data Page Size
  102. Where/when to fill an empty field ?
  103. stored procs and temp tables
  104. Partial rollback of transaction
  105. arrays in tsql ?
  106. writing a row to a table on another database server + identity column
  107. Efficient solution
  108. Repeating records
  109. Copying a table definition and populating it
  110. To normalize or not
  111. Joining two tables where ID's from one table is selected using LIKE % (Index hints ?)
  112. Transaction logs...
  113. Something rare!
  114. Naming
  115. GMTime equivalent in SQL
  116. execute command to express rule
  117. query problem, #temptable
  118. connect problem
  119. Using Trigger to populate another table
  120. result of that procedure will be different from 1?
  121. How to use a variable in my SQL code?
  122. Possible to access SQL data via NON SQL methods
  123. how to get the number of users signed up on each day for the current month?
  124. Many values from a single field returned into one single string
  125. Server: Msg 8525, ...Distributed transaction...
  126. parsing data
  127. Violation of PRIMARY KEY constraint
  128. Heterogenous queries ERROR 7405
  129. Does the Query yzer have a visual query builder
  130. Big HAIRY emergency
  131. Execute UPDATE from CURSOR and better way???
  132. Creating Random Numbers or Characters
  133. Getting Rows from Stored Procedures
  134. Final request for help!
  135. writing an upgrade script using conditional information
  136. using a sql statement to do a string replace
  137. Adding variables to SQL statements from URL parameters
  138. Rating System / AVG (Easy Question)
  139. how can i change jobs on a MSX server
  140. i need to get a field from a record
  141. SQL Question: Update using correlated subquery?
  142. When to use VIEWS instead of Stored Procedures
  143. SQL Output to a file
  144. Limiting the currency field
  145. huge deletion
  146. Guru Advice Needed for Query on Interesting Data Scenario
  147. Use of GETDATE() in Stored procedure logic
  148. how to get the error message in a stored proc
  149. Capturing the plain-text output of a stored procedure
  150. table data type in Stored Proc
  151. bulk insert error: 'Operating system error code 5(Access is denied.)'
  152. Junction Table Question
  153. rank w/ reset on group by
  154. INSERT programming question
  155. Stored procedures recompiling
  156. anyone help me with sp_setapprole
  157. Using GETDATE() within a user defined function
  158. Openquery Select Statement Returning Only 1 Record
  159. unicode to dbcs
  160. Updating millions of records
  161. Transaction have not rolled back.
  162. guru advice needed on temporary table problem
  163. Finding trigger in Enterprise manager
  164. How to get the data from Two servers
  165. More than one update in a statement?
  166. READ ONLY StoredProcedure
  167. using DTS transforming those records in decimal
  168. Excel to SQL Server
  169. Sony laptop with AMD processor - Cannot install SQL
  170. Changing field to IDENTITY in TSQL
  171. add 2 fields
  172. Dynamic time zone per instance or database
  173. variable question
  174. SQL 2K - FileGroups
  175. Alter Table
  176. Scripting DROP Table *and* DROP (related) Foreign Keys...
  177. select statement help
  178. bouncing between servers, table entries
  179. constraint in SQL Server2000
  180. performance in query...
  181. Complex parameters in Transact SQL
  182. Newbie - Calling a user-defined function
  183. Multiple table compare and update
  184. Oracle equivlent to Access 'select top 1...' ???
  185. Math Greater/Max function ??
  186. Is THIS Trigger Correct under CASCADE DELETE ?
  187. Date
  188. Column names
  189. Update more than one record (Subquery returned more than 1 value)
  190. DB Design
  191. how can I roll back an insert??
  192. Querying....how can I write this?
  193. Fitler by yesterday?
  194. Start Indexing Service
  195. I really need your help!
  196. Retrieve last identity from a table
  197. Variable table select in function
  198. Getting a SUM
  199. Help with select query
  200. how to get a value from an EXEC (SQL) statement
  201. may cause cycles or multiple cascade paths
  202. Sql Server Paging/Limit of Resultsets
  203. construct a date string in TSQL
  204. DMO and SQL Jobs
  205. Special Rounding
  206. Help in writing a query
  207. Selecting column names
  208. How to add leading zeroes to a numeric field?
  209. ADO & SQL Server
  210. Archiving
  211. how to suppress "warning null value..."
  212. MS Access Report Can't Find Stored Procedure
  213. Solid Schema or NOT?!?
  214. get data from previous row
  215. the quote are killing me. Can anyone see the problem???
  216. New login does not have access to any objects
  217. previous row question
  218. Server Name. Database Name
  219. Best CAST resolution for converting ...
  220. DTS samples in C++
  221. Cache and Stored Procs vs Prepared plans
  222. search for records between dates
  223. prevent updates/deletes on certain rows
  224. date question
  225. Ranks
  226. Function to P Date from String
  227. Very Slow INNER JOIN
  228. BUG: QA results in grid
  229. DDT?
  230. Resultset of a stored procedure
  231. auto increment without using a identity column
  232. update problem
  233. SELECT "newest Version". Please help :)
  234. number columns
  235. Newbie Question(need help)
  236. no more lock classes available from transaction
  237. trying to join on a computed value
  238. QA
  239. newb question on data model
  240. Help with SQLServer trigger
  241. How many indexes can I use in this table?
  242. newbie insert question
  243. An easier way to Transpose?
  244. Calculation across date periods
  245. Drop temp tables in tempdb
  246. Default Stored Procs Parameters value
  247. Need a workaround: error when saving stored proceduce
  248. UCASE(ing) the first letters
  249. creating a view with a decimal format
  250. SQL Question