Querying Microsoft SQL Server : Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
843 reads
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
843 reads
Transaction Log in SQL server records all operation on database.This recoring depends on Recovery Model selected for database.You can find...
2013-03-08
635 reads
Sometimes you need to know how many and what instances of
SQL Server running in your organization over Network. You can...
2013-02-22
2,363 reads
Use following script to generate random Passwords
DECLARE @id int,@list varcharSET @list ='abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ23456789.,-_!$@#%^&*'selectreplace(SUBSTRING(CONVERT(varchar(255),NEWID()),8, 8),'-','')as RANDOM
Example:
Suppose you have a table tblUser with columns[id],[userid],[password].
CREATETABLE [dbo].[tblUser]( ...
2013-02-12
4,849 reads
What is NULL?
In SQL, A Null is an unknown or undefined value. Some interesting
operations on NULL.
--query --resultselect 3*NULL --NULLselect 3+NULL ...
2013-02-05
525 reads
Data to test:
CREATETABLE [dbo].[emp]( [emp_id]
[nchar](10)NULL, [emp_name]
[nchar](10)NULL, [salary]
[int] NULL)ON [PRIMARY] insert emp( emp_id,emp_name,salary ) select'1','ABC',-20000 insert emp( emp_id,emp_name,salary ) select'2','XYZ',-5000 insert emp( emp_id,emp_name,salary ) select'3','PQR',-7800 insert emp( emp_id,emp_name,salary...
2013-02-04
748 reads
What is SQL Server?Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software...
2013-01-28
416 reads
DBCC Commands:
DBCC commands are most useful for
performance and troubleshooting.
The DBCC Commands are used in Maintenance, Informational use, Validation on a
database,...
2013-01-28
2,024 reads
1.Select no of Months between two dates:
SELECT DATEDIFF(MONTH,'4/1/2011','01/23/2013')+ CASE WHENDAY('4/1/2011')<DAY('01/23/2013') THEN 1 ELSE 0 END
Output:
----------------
22
2.What will be the
output of following...
2013-01-24
494 reads
FOR XML CLAUSE: Sometimes we need to data in form of XML from
Database.SQL Server provide FOR XML Clause. For XML clause...
2012-12-26
766 reads
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Comments posted to this topic are about the item Three Times a Day
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers