0
04:00 - 20:0020:00 - 23:00
Unexpected identity increment is good indicator of hidden problems.
Let's consider: "ROLLBACK TRANSACTION" always results it.
Try following:
CREATE TABLE table1 (id int identity(1,1), val int)
INSERT INTO table1 (val) VALUES (1)
SELECT * FROM table1 -- one row, id = 1
BEGIN TRANSACTION
INSE...
0
How to create a Microsoft SQL Server database by using ADO.NET and Visual C# .NET programmatically?
I need to create databases programmatically.
I use this code but after creating database, I cannot add a table to this DB due to permission problem
string str = "CREATE DATABASE MyDatabase ON PR...
Muphry's law is an adage that states that when a person criticises another's editing or proofreading, there will be a mistake of a similar kind in that criticism. The name is a deliberate misspelling of Murphy's law.
Similar laws have also been coined, usually in the context of online communication, under names including Skitt's Law, Hartman's Law of Prescriptivist Retaliation (or The Law of Prescriptive Retaliation), The Iron Law of Nitpicking, and McKean's Law. Further variations state that flaws in a printed or published work will only be discovered after it is printed and not during proofreading...
ALTER PROC [dbo].[SpProfitInDay3]
AS
BEGIN
------------------------------------------------------------------------------------------------------
CREATE TABLE #TempTableToday (DetailAccountId bigint,MandehToday bigint,soodHesab decimal(18,6),LastDate datetime);
CREATE TABLE #TempTableMinMand...
I need something that is the logical equivalent of
select cast(* as numeric IF data_type='decimal') from table_name
I didn't know how to do that, so i'm trying to reduce it into two steps:
select * from table_name where data_type!='decimal'
select cast(* as numeric) from table_name where dat...
I'm just take a guess here, but this should work....
SELECT S.Style
FROM Storage S
outer join ValidStyles vs on S.Style = VS.ValidStyle
WHERE vs.ValidStyle is null
SELECT Style
FROM Storage s
WHERE NOT EXISTS(SELECT * FROM ValidStyles vs WHERE vs.ValidStyle=s.Style)
0
In your data set all you need to do is add a derived column and set the value to this.
YourColumn == "" ? NULL(DT_WSTR,50) : YourColumn
You may also be able to check the box on the source that says keep null values to solve the issue.
The best practice is to explicitly define the date as part of your query:
DELETE FROM [schema].table WHERE times_stamp <= '2014-05-06';
However, you can accomplish this dynamically using:
DELETE FROM [schema].table WHERE DATEDIFF(day, times_stamp, SYSDATE()) >= 90;
This will remove rows tha...
04:00 - 20:0020:00 - 23:00
