Programming SQL
in [Microsoft SQL Server]
|
First
|
Prev |
Next
|
Last
Pages: 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294
sum up decimal value Hi! I have a question about summing up decimal value following is test data ----------------------------------------------------------- CREATE TABLE [dbo].[TEST_SUM]( [DATA_DTE] [datetime] NULL, [ID_NO] [varchar](50) NULL, [AMT] [decimal](19, 5) NULL) insert into TEST_SUM ([DATA_DTE],[ID_NO],[AMT]) Valu... 26 Jun 2008 14:38
SQL Server Express and network access Hi everyone, I am quite new to the database world, and particular to SQL Server Express. I like to do the following: Set up SQL Server Express so that an application I wrote use ODBC to access to it through network only, even if my application resides on the same machine that SQL Server Express is running (maybe ... 26 Jun 2008 10:30
prolbem on sending email I used this code to send html mail as table EXEC msdb.dbo.sp_send_dbmail @profile_name = 'profile1', @recipients= 'my mail', @subject = 'test htm', @body = N'<html> <body> <table border=''1''> <tr><th>Field1</th></tr> <tr> <td>myServce.com</td></tr></table> </body> </html>', @body... 26 Jun 2008 14:38
multiple update hi, my script is create table #ravenJobs ( opportunityref varchar(100), txtcompany varchar(100), txtRole varchar(100), txtcandidate varchar(100), txtDeal varchar(100), txtLocation varchar(100)) insert into #ravenJobs (opportunityref) values ('1') insert into #ravenJobs (opportunityref) values ('2') ins... 26 Jun 2008 14:38
output of showplan_xml into a table I want to run this to get the queryplan for a bunch of procedures loaded into a table but get the below error, any ideas? Thanks create table #plan (procPlan xml) set showplan_xml on insert #plan exec proc1 go insert #plan exec proc2 go set showplan_xml off go Msg 1067, Level 15, State 2, Line 1 The SE... 26 Jun 2008 11:32
Restore over the network vs from local disk 1- Last week I restored a 175GB .BAK file which creates a db of 205GB size using UNC (\\IP\Drive$\Backup\Filename.bak) where Drive$ is a resource of a SAN. The restore took 5.5 hours with 9.096 MB/sec. 2- Now I am currently restoring a more recent 175GB .BAK file which again creates a db of 205GB using ... 28 Jun 2008 01:29
Alternative to GETDATE() I've frequently written reports using GETDATE() to display data greater than a certain timeframe. For example: select * from dbo.WorkOrder where CreatedDate > ( getdate() - 1 ) I sometimes schedule these as part of a job, and I use the time I schedule the job for when I want the last days worth of information.... 26 Jun 2008 10:30
Check for the existance of a table What would the sql be in order to check for the existance of a table in a database? I need to use it in a vb project because it is part of a check for installation process. ... 26 Jun 2008 09:28
HOw to combine 2 rows into a single Row I am trying to combine two rows out of a table into one single row with two fields. Here is my example. Select * from myNames {results} Name: Joe Done (row 1) Name: Jane DoMe (row 2) Name: John Snake (row1) Name: Katy Pipes (row2) {desired results} Husband: Joe Done Wife: Jane Do... 26 Jun 2008 15:40
T-SQL Syntax to Alter Default value on a col I have a table with column defined as [LateFee] [decimal](18, 5) NULL CONSTRAINT [DF__Prop__LateFee__30C33EC3] DEFAULT (0.015) I want to alter the default to 0.01 .? ... 25 Jun 2008 20:10 |