Pages

SQL
Hot In It
Money
Blogging Tips
Asp.Net
About Me

My Blog List

hotinit.com. Powered by Blogger.

Search This Blog

skip to main | skip to sidebar

Tips for Sql

A Blog about Sql Server 2008.Easy to understand Sql Server Tips and Tutorials for beginners and useful sql server knowledge information for database developers.

Online Support

Click Here For Free Online Chat

Showing posts with label Identity. Show all posts

Showing posts with label Identity. Show all posts

Get Identity of a Table

Friday, 8 July 2011

SELECT IDENT_CURRENT(TableName')

Posted by Madhu at 06:09 0 comments

Email This BlogThis!Share to X Share to Facebook

Labels: Identity

Older Posts Home

Subscribe to: Posts (Atom)

Popular Posts

CharIndex

select charindex ( 'an' , 'madhsan' ) --output 6 select charindex ( 'an' , 'madhsan' , 1 ) ...
Use the sp_executesql stored procedure instead of the EXECUTE statement.

· Use the sp_executesql stored procedure instead of the EXECUTE statement. The sp_executesql stored procedure supports paramete...
Precision, Scale, and Length (Transact-SQL)

Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example,...
Funtion to get Alphabet Parts of the Alphanumeric String

Alter function GetLetters ( @string NVARCHAR ( 50 )) RETURNS VARCHAR ( 20 ) AS BEGIN DECLARE @IncorrectCharLoc SMALLINT S...
bat file with parameters

-- save the code as cool.bat @echo on set ConsoleAppLoc=%1 set dcmraw=%2 set seriesid=%3 set dcmcompressed=%4 IF NOT EXIST %dcmcompr...
SQL String Functions

SQL String Functions Sql string function is a built-in string function. It perform an operation on a string input value and return a string...
Sql Server: Find Long Running Query Or Performace Killing Query

--To Find Long Running Query----- SELECT TOP 20 SUBSTRING ( qt . text , ( qs . statement_start_offset / 2 )+ 1 , (( CASE...
Accessing Cmd Prompt from Stored Procedures xp_cmdshell

DECLARE @CmdToExecute varchar= 'dir' -- displays directories DECLARE @returncode int EXEC @returncode = xp_cmdshell @C...
XML TO SQL SERVER

I f you’ve got some XML data in a SQL Server column, how can you flatten it out and query it or present it as though it was relational da...
Executing Commands listed in a notepad

create the below command as a .bat file FOR /F %%a in ( E:\test\command.txt ) do %%a Give the command file location from which the co...

Labels

Blogger templates

Archives

▼ 2013 (4)
- ▼ February (3)
- ► January (1)

► 2012 (9)
- ► October (1)
- ► June (5)
- ► May (3)

► 2011 (71)
- ► December (2)
- ► October (1)
- ► September (3)
- ► August (23)
- ► July (3)
- ► June (30)
- ► May (9)

Blogger news

Blogroll

Most Reading

Check Column exists in table, if not, add

Check For a Column Exists In A Table If Not Add IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_NAME = ...
SSIS Connection String Format

Connection String is assigned to a variable in the below format Data Source=10.200.2.55;User ID=sa;Password =Welcome123;initial Catalog=Med...
Precision, Scale, and Length (Transact-SQL)

Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example,...
Exe To Windows Service

How to convert an exe to a service? How to create user defined function in windows? How to create a PACS windows Service Using dc...
Importing XML File to Sql Server Table

Here is the example on how to import an xml file in the sql server installed machine to sql server table . Steps to do this 1. Save the ...
SQL SERVER - Insert from one table to another Table

In SQL Database , You can probably insert data from one table into another using two methods. 1. Insert Into - This is used when the tab...
Function to Parse AlphaNumeric Characters from String

CREATE FUNCTION dbo.UDF_ParseAlphaChars ( @string VARCHAR ( 8000 ) ) RETURNS VARCHAR ( 8000 ) AS BEGIN DECLARE @IncorrectCharLoc SMA...
Free Google Online Chat Support For Website and Blogs

Free Google Online Chat Support For Website and Blogs STEP1 Go to the following site and create a badge as shown in the Picture http://ww...
wait statistics -Dynamic Management Views

Select * from sys . dm_os_wait_stats Select * from sys . dm_os_waiting_tasks
XML TO SQL SERVER

I f you’ve got some XML data in a SQL Server column, how can you flatten it out and query it or present it as though it was relational da...

Tags

Copyright © . Tips for Sql For Quickbooks Support Contact SupportCensor.Com

8.6/10