Search the Community
Showing results for tags 'sql server'.
-
If you look in the DEFINITION and USAGE paragraph, you'll see that GETDATE() is being used instead of GETUTCDATE().
- 2 replies
-
- sql server
- t-sql
-
(and 1 more)
Tagged with:
-
Hi,As the title said, i'm trying to update an SQL Server DB with php. From my code below, you can see that i call once a stored proc to get information who will be in a table. One of the row allow me (supposed to be)(the last row who is an input), to change an other one (row name GL). But with the button save, it seems like nothing change at all. I tried to make some log with console and i can see test1 and test2. So it seems like it can go throught but doesnt ajust anything. I really don't know anymore and i really need your help. Any ideas or help will be really really appreciate. More on th
- 12 replies
-
- sql server
- php
-
(and 2 more)
Tagged with:
-
The root problem is an ASPX (ASP.NET) web page program, part of an important business program presently in development and connected to an sql server database (.mdf) file, is presently unable to do two procedures: rs=Server.CreateObject("ADODB.Recordset") and rs.Open (sql1,conn). Both operations return rs.State = False. The reason is not clearly understood. The system is Windows XP SP3. The only error observed in the MSSQL ERRORLOG is: The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure
-
I have a column which has more than 10,000 rows with string in the form of 05MAY2006:04:34:00.000000 it is stored as varchar(25). I need to save it as datetime in the same column. I have tried using update tablenameset columnname = (SUBSTRING(columnname,1,2) + '-' + SUBSTRING(columnname,3,3) + '-' + SUBSTRING(columnname,6,4) + ' ' + SUBSTRING(columnname,11,8));and then alter table tablenamealter columnname datetime;but later it shows up the errorMsg 242, Level 16, State 3, Line 1The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.How do I change it a
- 1 reply
-
- SQL 2012
- SQL management studio
-
(and 1 more)
Tagged with:
-
please suggest a website which offers tables and asked queries related to it.
-
HelloI know this is a total newb question, but i have the following SQL: SELECT FagNavn, adgangskrav, Ugedag, holdId, fagKode, CONVERT(CHAR(10), StartDato, 105) AS startDate, CONVERT(CHAR(10), slutDato, 105) AS endDate, afdeling, link, navn, deltagerBetaling, bt, niveau, Case When Ugedag = 'Mandag' Then frakl + ' - ' + tilkl Else '' End AS startSlutMandag, Case When Ugedag = 'Tirsdag' Thenfrakl + ' - ' + tilkl Else '' End AS startSlutTirsdag, Case When Ugedag = 'Onsdag' Thenfrakl + ' - ' + tilkl Else '' End AS startSlutOnsdag, Case When Ugedag = 'Torsdag' Then frakl + ' - ' + tilkl Else '' En
-
Hi,I have two branch offices, in two different countries (Country A and Country . In there I have several MS SQL Database servers. Country A: Server A1, Server A2Country B: Server B1, Server B2 All servers are connected via internet through local VPN. I want to configure database replication between Server A1 and Server B1. But it does not working correctly. I want to configure Merge replication. I have followed all the necessary process for replication and I did not found any error or warning. The problem is after configuration all the tables of Server A1 are not created in server B1. Only
-
Hi all, I want to find duplicate records from a joint table result (The two tables are from two different DB's). Bellow are the tables and my requirement. Table1 from DB D1EmpID205205205206207207208209210211 Table2 from DB D2PayID205206207 208 209 210 211 i have joined these two tables on the basis of EmpID = PAYID and got the following result SELECT T1.EMPID,T2.PAYIDFROM D1.table1 T1INNERJOIN D2.table2 T2 onT1.EMPID collate Latin1_General_CI_AI =T2.PayID EmpID PayID 205 205 205 205 205
- 3 replies
-
- sql server
- sql
-
(and 2 more)
Tagged with: